SoDA Workshop Series - Introduction to Data Science with R (Workshop 11: Dealing with Messy Data in R)

Workshop 11: Dealing with Messy Data in R
When Nov 30, 2017
from 12:00 PM to 01:00 PM
Where B001 Sparks -- The Databasement
Contact Name
Contact Phone 814-267-2720
Attendees All interested members of the PSU community are welcome to attend.
Add event to calendar vCal
Workshop 11: Dealing with Messy Data in R

In this workshop, we will go over the basics of cleaning up spreadsheet data containing errors or other formatting problems. This is one of the areas where R really shines, as it allows one to automate the process of cleaning data using loops, conditionals, and user defined functions. Data cleaning is often more of an art than a science (because every dataset comes with its own unique challenges), but in this workshop I will take you through some of the greatest hits I have encountered in messy data, all packed into one example dataset.
General Information about the Workshop Series

Do you want to develop the skills to program and manage data using R? If so, this workshop series is for you! We will be meeting (almost) weekly for an hour throughout the semester to cover everything from basic R programming up through big data analytics and high performance computing. This workshop series will start with several weeks introducing R and basic R programming, so no prior experience is required (only a laptop). We will then move on to a series of workshops on reading in, cleaning, transforming, and combining multiple, complex datasets (including text and social network data) -- using our newfound R programming skills. Once we have the basics of data mangament down, we will cover web-based data collection, both from traditional web pages, and from the Twitter API. Finally, we will get into performance and scalability issues, and go over the steps for accessing the ICS cluster resources at Penn State.

These workshops will be offered (most) Thursdays during the Fall 2017 semester from 12:00-1:00 in Sparks B001 (The DataBasement). Directions to the DataBasement here: . Bring laptop! 

The instructor for the workshop is Matt Denny, who can be contacted at

Materials (including slides, video tutorial, and pictorial tutorial) are available on the workshop website: 

Filed under: Rstats, data science, workshop