5  Dataframes

First, everyone should know how to use MS Excel to format columns correctly, numbers, dates, times, dollars, etc. and do the following:

• Sort
• Filter
• Make Pivot Tables

Knowing how to make a pivot table in MS Excel is a very useful thing to know how to do in MS Excel.

These ideas all translate in to Tidyverse commands in R.

• Select
• Filter
• Mutate
• Groupby
• Summarize
• %>%
• pivot_wider
• pivot_longer
• unify

The Tidyverse gives commands to work with data in dataframes.