Ms. Eugenia Pivot-R Code Snippet Generation

Example

df <- tibble::tibble(year = c(2020, 2021), sales_jan = c(200, 250), sales_feb = c(150, 300)) pivot_longer(df, cols = starts_with('sales'), names_to = 'month', values_to = 'sales')

Scenario

Used when you need to convert data from a 'wide' format (where data points spread across columns) to a 'long' format (where data points are gathered into a single column with variable identifiers). This is useful in cases where you need to perform operations like plotting or grouped statistics that require a long format.

Example

df <- tibble::tibble(year = c(2020, 2020, 2021, 2021), month = c('Jan', 'Feb', 'Jan', 'Feb'), sales = c(200, 150, 250, 300)) pivot_wider(df, names_from = 'month', values_from = 'sales')

Scenario

Used to spread a key-value pair across multiple columns, transforming data from a 'long' format back to a 'wide' format. This function is particularly handy for summarizing data or preparing it for reports where a comparative month-by-month breakdown is required.