DATA MANIPULATION IN R
How to create a pivot table (the Excel PivotTable way)
Data transformation
How to do a VLOOKUP (and INDEX MATCH and XLOOKUP)
Data transformation
Text to columns : split a column into several columns
Data transformation
Missing values (NA) : find, count, remove and replace
Data transformation
Remove duplicates with unique(), duplicated() and distinct()
Data transformation
Reshape data with pivot_longer() and pivot_wider() from tidyr
Data transformation
Tables with table() and prop.table()
Data transformation
Remove leading and trailing whitespaces with trimws()
String manipulation
Lowercase and uppercase with tolower() and toupper()
String manipulation
Extract and replace substrings with substring() and substr()
String manipulation
rbind() and cbind() functions
Data transformation
Split strings with strsplit()
String manipulation
¿What is DATA MANIPULATION?
Data manipulation, also known as data wrangling, refers to the process of transforming and cleaning raw data into a structured format suitable for analysis. This process involves various operations such as filtering, sorting, aggregating, merging, reshaping, and transforming data to make it more organized, understandable, and ready for analysis. R provides several functions to perform these tasks, but dplyr is one of the most popular and widely used R packages for data manipulation.
-
Base R
Data manipulation in base R involves using the core functions and methods provided by R's base package for handling, transforming, and manipulating data structures such as vectors, matrices, arrays, data frames, and lists. -
dplyr
dplyris an R package designed for efficient and user-friendly data manipulation. It provides a set of functions that streamline data wrangling tasks by offering a consistent grammar for manipulating data frames and data tables.