DA542 - Intermediate Applications of R

Course Description

Build on your R analysis skills as you move into more complex data manipulation and data analysis. Learn how to manipulate, arrange, sort, merge, and summarize your data. Understand how to shape your dataset, combine data tables, and transposedata. Apply the filter function to select the appropriate data for analysis. Learn to aggregate your data and then find totals, averages, minimums, and maximums.Explore manipulating rows and columns with dplyr. Discover group processing to pull out the top three of a category or to rank items within a category, Learn to combine rows and columns, delete columns,and delete dataframes. Understand how to query your data with SQL syntax. Topics include chaining, data aggregation, summarizing data, and using the dplyr library. Additional topics include importing Excel files, ranking data, working with data relationships, merging dataframes, and working with slices or subsets of data.

In this course, you will learn to: 

• A Review of R Syntax 

• More on Managing Rows and Columns 

• Installing Packages 

• The Power of the dplyr Library 

• Data Aggregation (Group By) 

• Summarizing Data 

• Using merge() to Combine Data Tables 

• Combining Rows and Columns 

• Transposing Data 

• Importing Excel Files Directly 

• The SQL Library 

Applies Towards the Following Certificates

• Data Analysis Certificate : Data Analytics and Visualization
• Python Data Analysis Certificate : Electives