Paths
Data Wrangling with R
Data wrangling is the process of transforming and mapping data from one form into another, with the intent of making it more available for data analytics. This skill teaches... Read more
What You Will Learn
- Data Wrangling with R conveys commonly performed data wrangling and transformation patterns using R.
Pre-requisites
- Data Literacy
- Mathematics
- bR for Data Analysts
- Visualizing Data with R
- Importing Data with R
Beginner
You’ll learn different ways to combine, group and merge your data.
Merging Data Sources with R
1h 28m
Description
In your R data science projects, you need very often to work with data which is spread out across multiple data sources. For example, given two separate data sets on products and their sales, how can you merge them into a new data set? In this course, Merging Data Sources with R, you will gain the ability to merge data from different sources in a controlled way that enables you to keep only the data you need. First, you will learn to merge vectors, which includes using the paste() and append() methods. Next, you will discover how to join data sets with the merge() function, which includes left, inner, right and full outer joins, on data frames that can have one-to-one, one-to-many, or many-to-many relationships. Finally, you will explore how to join data sets with the dplyr package, which covers the previous joins plus anti and semi joins. When you are finished with this course, you will have the skills and knowledge of merging data from different sources, needed to do data wrangling with R.
Table of contents
- Course Overview
- Managing Vectors
- Joining Data Sets with the Merge() Function
- Joining Data Sets with dplyr
Splitting and Combining Data with R
1h 57m
Description
Summarizing statistics across groups is invaluable for comparing categories of observations. In this course, Splitting and Combining Data with R, you'll explore splitting data into groups based on some criteria, applying functions or calculations to each group independently, and combining the results into a data structure. To begin, you’ll learn how to create custom categorical variables for grouping, and custom numeric variables to which you can apply functions. Next, with the criteria for grouping created, you will split the data, apply functions, and combine the data into a data structure. Finally, with the raw data transformed, you’ll discover how a grouped dataframe can then be ungrouped with summary statistics maintained, or keep the grouped dataframe intact with plotting functions for visualizing variation between groups. By the end of this course, you’ll have a better understanding of how to use R to build data pipelines with dplyr, manipulate strings and dates for feature engineering, and create customized ggplot charts. .
Table of contents
- Course Overview
- Creating Variables to Combine/Summarize Data
- Grouping and Summarizing Data
- Plotting Combined Data
Intermediate
Normalize data to make it appropriate for an analysis with dplyr and reshape long and wide data for further analysis.
Reshaping Data with R
1h 59m
Description
Have you ever thought about the format of data you are dealing with? Is it long or wide? Which format is better for your analysis? In this course, Reshaping Data with R, you will gain the ability to reshape and aggregate data using the R programming language. First, you will learn how to transform wide-format data into long-format data. Next, you will discover how to reshape data from long format to wide format. Finally, you will explore how to aggregate data with and without group variables. When you are finished with this course, you will have the skills and knowledge of reshaping data needed to manage your data more effectively for statistical analysis and data visualization. Software required: R*
Table of contents
- Course Overview
- Introduction
- Reshaping Wide Data to Long Data
- Reshaping Long Data to Wide Data
- Reshaping Data Based on Aggregated Values
- Course Recap
Advanced
Transform data encoding to enable further analysis.
Encoding Data with R
37m
Description
Encoding Data can be time consuming and lacks proper data insights in the process. In this course, Encoding Data with R, you will gain the ability to encode data to utilize a data set, while being able to find data frequencies and insights that fit your data set and business goals. First, you will learn the factor() function for converting data types. Next, you will discover how to find data frequencies through the table() function. Finally, you will explore how to encode data for a indicator flag or for a potential model. When you are finished with this course, you will have the skills and knowledge to encode data to find insights quickly.
Table of contents
- Course Overview
- Converting Values to Factors in R
- Finding Frequency Data Summaries in R
- Preparing Qualitative Data for a Database in R
- Encoding Data for a Potential Model in R
Learning Paths
Data Wrangling with R
4 courses
6 hours- Skill IQ
Data wrangling is the process of transforming and mapping data from one form into another, with the intent of making it more available for data analytics. This skill teaches common data wrangling practices employed with the R programming language.
Courses in this path
Beginner
You’ll learn different ways to combine, group and merge your data.
Intermediate
Normalize data to make it appropriate for an analysis with dplyr and reshape long and wide data for further analysis.
Advanced
Transform data encoding to enable further analysis.
Learn with the best
