📦 ae03-data-wrangling

Importing, cleaning, exploring and correlating data

Author

Eduard (Eddie) Bukin

An RStudio project with four exercises and the five datasets they use. Covers data wrangling and describing data.

Unzip it, then open ae03-data-wrangling.Rproj in RStudio. Every path inside the exercises is relative to that project, so the data will load without edits.

What is inside

ExercisesRead online

ae03-01-import-clean-sum-plot.Rmd Import messy Excel and CSV files, clean the column names, produce first summaries and plots. rendered source

ae03-02-plastic-waste.Rmd Explore the distribution of plastic waste per capita across countries. rendered source

ae03-02-plastic-waste-solutions.Rmd Worked solutions to the plastic waste exercise. rendered source

ae03-03-correlation.Rmd Compute correlations, read their strength, and see where they mislead. rendered source

DataDownload

data/plastic-waste.csv Plastic waste generation and mismanagement by country. csv

data/NHIS2009.csv US National Health Interview Survey extract, used for health-insurance comparisons. csv

data/chicken.csv Small tidy dataset used for the first import and plotting steps. csv

data/commodity-prices.xlsx Commodity price series — the readxl import example. xlsx

data/dirty_data.xlsx Deliberately messy spreadsheet used to practise cleaning with janitor. xlsx

Project

ae03-data-wrangling.Rproj RStudio project file — open this first.

What is inside

Related