
The “separate_rows” Function in R
To separate cells that contain multiple values into multiple rows, duplicating all other data as necessary.
The “fill” Function in R
To fill missing values in a column with the most recent non-missing value.
The “extract” Function in R
To extract substrings from a character vector based on a regular expression pattern.
The “expand” Function in R
To create a complete set of combinations from the combinations of existing data.
The “pivot_wider” Function in R
To pivot data from long to wide format by spreading a key-value pair into multiple columns.
The “pivot_longer” Function in R
To pivot data from wide to long format by gathering multiple columns into key-value pairs.
The “unnest” Function in R
To unnest a nested data frame column, expanding it into separate rows.
The “nest” Function in R
To create a nested data frame column, where each row contains a nested data frame or list.
The “complete” Function in R
To ensure that all combinations of values in specified columns are present in the data, filling in missing combinations with NA.
The “unite” Function in R
To unite multiple columns into a single column by concatenating their values.
The “separate” Function in R
To separate a single character column into multiple columns based on a delimiter.
The “spread” Function in R
To reshape data from long to wide format by spreading a key-value pair into multiple columns.