Data Transformation Techniques
Write a program using R-Markdown solving and answering questions listed below under Exercises immediately after each section. For clarity, make sure to give an appropriate title to each section.
Sections: Introduction, Prerequisites, nycflights13, dplyr Basics, Filter Rows with filter(), Comparisons, Logical Operators, Missing Values.
  • Exercises: 1.1, 1.2, 1.3, 1.4, 1.5, 1.6,  3
Sections: Arrange Rows with Rows()
  • Exercises: 1 and 2
Sections: Select columns with select()
  • Exercises: 3
Sections: Add new variables with mutate(), Useful Creation Functions
  • Exercises: 2, 4, 5
Sections: Grouped summaries with summarize(), Combining multiple operations with the Pipe, Missing Values, Counts, Useful Summary Functions, Grouping by Multiple Variables, Ungrouping
  • Exercises: 5, 6
Sections: Grouped Mutates (and Filters)
  • Exercises: 2, 4, 7