The pivot_wider() function of the tidyr package reshapes data frames from long to wide format by transforming rows into columns. As a modern and more versatile replacement for the now-deprecated spread() function, pivot_wider() is actively maintained and supports advanced use cases. While spread() remains available for backward compatibility, it is recommended to use pivot_wider() for new code.
In this article, I will explore the pivot_wider() function, its syntax, parameters, and practical use cases. Through detailed examples, I will demonstrate how to transform long-format data frames into wide-format structures for better usability and presentation.
Key Points-
- Reshape long-format data into a wide format with
pivot_wider(). - Customize column names dynamically using
names_fromand their values withvalues_from. - Handle missing values with the
values_fillparameter. - Resolve duplicate column names using
names_repair. - Advanced control using options like
names_sep,names_glue, and more. - Returns a tidy tibble in a wide format.
- Replaces
spread()with enhanced functionality and active development.
<a id="h-r-pivot-wider-function"></a>
R pivot_wider() Function
The pivot_wider() function of the tidyr package transforms data from a long format to a wide format by reducing the number of rows in the original data frame. It converts specified column values into column names in the wide format, while another set of specified values becomes the corresponding column values.
<a id="h-syntax-of-pivot-wider-function"></a>
Syntax of pivot_wider Function
The general syntax of the pivot_wider() function.
# Syntax of the pivot_wider() function
pivot_wider(data,
id_cols = NULL,
names_from = NULL,
values_from = NULL,
names_prefix = "",
names_sep = "_",
values_fill = NULL,
values_fn = NULL)
Parameters
data:The input data frame or tibble.id_cols:Columns to use as unique identifiers for the wide format. IfNULL, defaults to all columns not specified innames_fromorvalues_from.names_from:Column(s) to use as the key for creating new column names.values_from:Column(s) to use as the values for the newly created columns.values_fill:A value to fill in for missing entries (default isNA).names_repair:Method for handling duplicate column names....:Additional arguments for customizing the output.
<a id="h-return-value"></a>
Return value
It returns a data frame or tibble in a wide format, where rows are rearranged into columns based on the specified parameters.
<a id="h-pivot-wide-format-with-r-pivot-wider"></a>
Pivot Wide Format with R pivot_wider()
To convert data from a long format to a wide format, you can use the pivot_wider() function. Specify the columns to use as new column names with the names_from argument and the columns that provide the data values with the values_from argument. It pivots the given data frame from a long to a wide format.
# Transform data from long format to wide format
# Load tidyr package
library(tidyr)
# Create data frame
df <- data.frame(
Student = c("Geetha", "Geetha", "Ram", "Ram"),
Subject = c("Math", "Science", "Math", "Science"),
Score = c(85, 80, 90, 85)
)
print("Original Data frame:")
print(df)
# Transform data from long to wide format
wide_df <- pivot_wider(
data = df,
names_from = Subject,
values_from = Score
)
print("Wide-Format Data:")
print(wide_df)
Yields below output.
<a id="h-pivot-wider-with-id-cols"></a>
pivot_wider with id_cols
By default, the pivot_wider() function automatically identifies columns in the input data to use as identifiers for the wide data frame. You can override this behavior and specify which columns to use as identifiers by using the id_cols argument."
# pivot_wider with id_cols
# Load tidyr package
library(tidyr)
df <- data.frame(
Class = c("A", "A", "B", "B"),
Student = c("Geetha", "Ram", "Sai", "Priya"),
Subject = c("Math", "Science", "Math", "Science"),
Score = c(85, 80, 90, 85)
)
# Specify ID columns
wide_df <- pivot_wider(
data = df,
id_cols = c(Class, Student),
names_from = Subject,
values_from = Score
)
print("Wide-Format Data with Specified ID Columns:")
print(wide_df)
Yields below output.
<a id="h-customize-column-names-with-names-prefix"></a>
Customize Column Names with names_prefix
You can customize the column names in the wide data frame using the names_prefix argument of the pivot_wider() function. It will add a specified prefix to the column names in the wide data frame.
# Customizing column names of wide data
wide_df <- pivot_wider(
data = df,
names_from = Subject,
values_from = Score,
names_prefix = "Score_"
)
print("Wide-Format Data With custom Column Names:")
print(wide_df)
# Output:
"Wide-Format Data With custom Column Names:"
# A tibble: 4 × 4
# Class Student Score_Math Score_Science
#
# 1 A Geetha 85 NA
# 2 A Ram NA 80
# 3 B Sai 90 NA
# 4 B Priya NA 85
<a id="h-handling-missing-values-in-r-pivot-wider"></a>
Handling Missing Values in R pivot_wider()
To handle missing values (NA) in the wide data, you can use the values_fill parameter to replace them with a specified value.
# Handling Missing Values in pivot_wider()
# Load tidyr package
library(tidyr)
# Filling missing values
wide_df <- pivot_wider(
data = df,
names_from = Subject,
values_from = Score,
values_fill = 0
)
print("Wide-Format Data with specified Missing Values:")
print(wide_df)
# Output:
# [1] "Wide-Format Data with specified Missing Values:"
# A tibble: 4 × 4
# Class Student Math Science
#
# 1 A Geetha 85 0
# 2 A Ram 0 80
# 3 B Sai 90 0
# 4 B Priya 0 85
<a id="h-frequently-asked-questions-of-r-pivot-wider"></a>
Frequently Asked Questions of R pivot_wider()
It reshapes data from long format to wide format, turning rows into columns for better readability or specific analytical purposes.
Both names_from and values_from accept multiple column names for greater flexibility.
values_fill replaces NA with a specified value for columns where data is missing.
The names_repair parameter can resolve duplicates by ensuring unique names.
<a id="h-conclusion"></a>
Conclusion
In this article, I have explained the pivot_wider() function from the tidyr package, which is an essential tool for transforming long-format data into a wide format. Its flexibility and advanced options make it a powerful choice for data-wrangling tasks. By customizing column names, handling missing values, and providing data integrity, pivot_wider() simplifies the process of preparing data for analysis and visualization.
Happy Learning!
<a id="h-related-articles"></a>
Related Articles
- Explain the tidyr gather() function with examples.
- Explain the R tidyr spread() function.
- Explain the pivot_longer() function in R.
- Explain the fill() function in R.
- Explain the drop_na() function in R.
- Explain the replace_na() function in R.
- Explain the separate() function in R.
- Explain the unite() function in R.
- Explain the separate_rows() function in R.
- Explain the complete() function in R.
<a id="h-references"></a>