In this workshop you will learn how to import messy data from an Excel spreadsheet, and develop the R skills to turn this mess into tidy data ready for analysis. If your answer to any of the following questions is “yes”, then this is the right workshop for you. (1) Do you frequently receive untidy data for analysis in Excel spreadsheets? (2) Does this drive you slightly batty?(3) Do you want to learn how to make your life easier with a suite of data cleaning tools? The workshop is designed for those with some experience in R. It will be assumed that participants can perform basic data manipulation. Experience with the {tidyverse} and the pipe operator is a plus, but not required. You will learn how to (1) To import Excel files with (common, messy) data problems; (2) To address and clean common messy data problems in each variable; and (3) To address and clean data with more complex metaproblems, like pivoting to long format for data analysis, dealing with multicolumn headers, colorcoded data (gah!), and unpivoting pivot tables into tidy data.

More Resources

R/Medicine Event site: https://events.linuxfoundation.org/r...
Main site: https://www.rconsortium.org/
Blog: https://www.rconsortium.org/news/blog
Join: https://www.rconsortium.org/about/join
Twitter:   / rconsortium  
LinkedIn:   / rconsortium  
Mastodon: https://fosstodon.org/@RConsortium