Data Transformation Techniques

Data Transformation TechniquesWrite 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