{"id":35,"date":"2026-03-03T06:52:52","date_gmt":"2026-03-03T06:52:52","guid":{"rendered":"https:\/\/gigz.pk\/r\/?post_type=lesson&p=35"},"modified":"2026-04-01T11:00:02","modified_gmt":"2026-04-01T11:00:02","slug":"working-with-tidyr-for-data-tidying","status":"publish","type":"lesson","link":"https:\/\/gigz.pk\/r\/lesson\/working-with-tidyr-for-data-tidying\/","title":{"rendered":"Working with tidyr for Data Tidying"},"content":{"rendered":"\n

tidyr<\/code> is a powerful R package designed to help you clean, reshape, and organize messy data into a tidy format. Tidy data makes analysis, visualization, and modeling easier and more efficient. Each variable should have its own column, each observation should have its own row, and each value should occupy its own cell.<\/p>\n\n\n\n

1. Installing and Loading tidyr<\/strong><\/h1>\n\n\n\n

Before using tidyr<\/code>, install and load the package:<\/p>\n\n\n\n

install.packages(\"tidyr\")  # Install tidyr
library(tidyr)             # Load tidyr<\/pre>\n\n\n\n
2. Key tidyr Functions<\/strong><\/h1>\n\n\n\n
a) gather() \/ pivot_longer()<\/strong><\/h2>\n\n\n\n
pivot_longer()<\/code> (modern replacement for gather()<\/code>) converts wide-format data into long-format data. This is useful when columns represent values instead of variables.<\/p>\n\n\n\n
data <- data.frame(
  Name = c(\"Alice\", \"Bob\"),
  Math = c(90, 85),
  Science = c(88, 92)
)# Convert wide data to long format
long_data <- pivot_longer(data, cols = c(Math, Science), 
                          names_to = \"Subject\", 
                          values_to = \"Score\")<\/pre>\n\n\n\n
Result:<\/strong> Each row represents one subject score per student.<\/p>\n\n\n\n
b) spread() \/ pivot_wider()<\/strong><\/h2>\n\n\n\n
pivot_wider()<\/code> (replacement for spread()<\/code>) converts long-format data into wide-format data.<\/p>\n\n\n\n
wide_data <- pivot_wider(long_data, names_from = Subject, values_from = Score)<\/pre>\n\n\n\n
Result:<\/strong> Each subject becomes a separate column again.<\/p>\n\n\n\n
c) separate()<\/strong><\/h2>\n\n\n\n
separate()<\/code> splits a single column into multiple columns based on a separator.<\/p>\n\n\n\n
data <- data.frame(ID = c(\"A-01\", \"B-02\"))
separate(data, col = ID, into = c(\"Letter\", \"Number\"), sep = \"-\")<\/pre>\n\n\n\n
d) unite()<\/strong><\/h2>\n\n\n\n
unite()<\/code> combines multiple columns into one.<\/p>\n\n\n\n
data <- data.frame(Letter = c(\"A\",\"B\"), Number = c(\"01\",\"02\"))
unite(data, col = \"ID\", Letter, Number, sep = \"-\")<\/pre>\n\n\n\n
e) drop_na() and fill()<\/strong><\/h2>\n\n\n\n