Skip to main content

Week 3 Blog: Playing with DataFrames—Correcting Errors and Analyzing Fictional Poll Results

 

Week 3 Blog: Playing with DataFrames—Correcting Errors and Analyzing Fictional Poll Results





Introduction

This week's assignment involved working with a fictional dataset representing poll results from the 2016 U.S. Presidential election. The dataset included seven candidates and their results from two polling sources: ABC and CBS. However, before diving into the analysis, I encountered a few errors in the initial dataset that I had to correct.

Initial Errors and Corrections

The data I was provided had some formatting issues that needed fixing before I could proceed. For example:

  1. Quotation Marks: Some of the names had incorrect quotation marks (“ ” instead of "), which R couldn’t recognize. I fixed this by replacing all smart quotes with regular quotation marks (").

  2. Commas: The ABC and CBS poll results had some missing commas. Without proper separation, R would misinterpret the values. I inserted the missing commas to correctly format the vectors.

Here’s how the corrected data looked:






Analyzing the Data

After cleaning the data, I created a data frame to store the candidate names and their respective poll results from ABC and CBS:






Next, I wrote code to determine the winners of each poll by identifying the candidates with the highest number of votes. Initially, I wrote a more manual approach, but after improving it with some help, I made the code more efficient.

Here’s the code I used to identify the winners of both polls:








Results

Using the corrected data and the improved code, I found the following results:


Donald won both polls decisively based on the fictional data provided.

Conclusion

This assignment helped me improve my data cleaning skills and practice handling issues in R such as formatting errors and missing separators. It also reinforced how to efficiently analyze data using functions like which.max() to determine the top performers in a dataset.

You can view the full code and project on my GitHub repository - (Named -assignment3).




Comments

Popular posts from this blog

DNA Sequence Alignment and Visualization with "SequenceAlignment" Package

 DNA Sequence Alignment and Visualization with "SequenceAlignment" Package In bioinformatics, sequence alignment plays a crucial role in comparing biological sequences, especially DNA sequences. It helps in identifying similarities, differences, and evolutionary relationships between sequences. In this blog, we’ll explore how to use the SequenceAlignment R package for performing sequence alignments, visualizing the results with plots like barplots and heatmaps , and analyzing DNA sequences against multiple reference sequences stored in FASTA files. What is Sequence Alignment? Sequence alignment is the process of comparing two or more biological sequences (e.g., DNA, RNA, or proteins) to identify regions of similarity or difference. In DNA sequence alignment, the sequences are compared to see how closely they match, which can provide insights into genetic similarities, mutations, or evolutionary trends. The SequenceAlignment Package The SequenceAlignment package is a powerf...

Journey Through R Programming: Week 1

  Journey Through R Programming: Week 1 Introduction Welcome to my blog! As part of my Open Source R course with Professor Alon Friedman at the University of South Florida, I’m excited to document my weekly progress in learning R programming. A bit about me: I’m currently pursuing a Master’s in Bioinformatics & Computational Biology, following an undergrad in Biotechnology. My programming journey began with Python through the “100 Days of Code: The Complete Python Pro Bootcamp” on Udemy, which included around 8 mini projects. This experience has made transitioning to R a bit smoother, as many concepts overlap. To support my learning, I’m using the book  The Art of R Programming  and the edX course  Data Science: R Basics  from Harvard University. These resources have been invaluable in deepening my understanding of R. Summary 1. Function Creation Objective: Create a function to count the number of odd numbers in a vector. Code: What I Learned: The modulus op...

Week 9 : Exploring Cancer Survival Data Visualization in R

 Week 9 : Exploring Cancer Survival Data Visualization in R In this Assignment, I explored ways to visualize cancer survival data across different organs using a variety of R plotting methods, including base R’s   barplot() ,   ggplot2 , and an   xyplot()   with   lattice . Here’s a breakdown of the journey, the challenges faced, and what I learned along the way. The Data: Mean Survival Time by Organ The dataset I worked with contains information on the survival times across different organs from cancer . To understand the average survival time for each organ, I first calculated the mean survival time by using the following code: Once I had the mean survival times, I set out to visualize the data using four different approaches, each with its unique set of functionalities and aesthetics. 1. Basic Bar Plot with Base R My first plot used a simple   barplot()   to display the mean survival times. This method provided a quick and straightforward way t...