Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!
Get Started for Free

tidyr

Tidy Messy Data

Tools to help to create tidy data, where each column is a variable, each row is an observation, and each cell contains a single value. 'tidyr' contains tools for changing the shape (pivoting) and hierarchy (nesting and 'unnesting') of a dataset, turning deeply nested lists into rectangular data frames ('rectangling'), and extracting values out of string columns. It also includes tools for working with missing values (both implicit and explicit).

Functions (39)

billboard

Song rankings for Billboard top 100 in the year 2000

chop

Chop and unchop

complete

Complete a data frame with missing combinations of data

construction

Completed construction in the US in 2018

deprecated-se

Deprecated SE versions of main verbs

drop_na

Drop rows containing missing values

expand

Expand data frame to include all possible combinations of values

expand_grid

Create a tibble from all combinations of inputs

extract

Extract a character column into multiple columns using regular expression groups

extract_numeric

Extract numeric component of variable.

fill

Fill in missing values with previous or next value

fish_encounters

Fish encounters

full_seq

Create the full sequence of values in a vector

gather

Gather columns into key-value pairs

hoist

Rectangle a nested list into a tidy tibble

nest

Nest and unnest

nest_legacy

Legacy versions of nest() and unnest()

pack

Pack and unpack

pipe

Pipe operator

pivot_longer

Pivot data from wide to long

pivot_longer_spec

Pivot data from wide to long using a spec

pivot_wider

Pivot data from long to wide

pivot_wider_spec

Pivot data from long to wide using a spec

reexports

Objects exported from other packages

relig_income

Pew religion and income survey

replace_na

Replace NAs with specified values

separate

Separate a character column into multiple columns with a regular expression or numeric locations

separate_rows

Separate a collapsed column into multiple rows

smiths

Some data about the Smith family

spread

Spread a key-value pair across multiple columns

table1

Example tabular representations

tidyr-package

tidyr: Tidy Messy Data

tidyr_legacy

Legacy name repair

tidyr_tidy_select

Argument type: tidy-select

uncount

"Uncount" a data frame

unite

Unite multiple columns into one by pasting strings together

us_rent_income

US rent and income data

who

World Health Organization TB data

world_bank_pop

Population data from the world bank

tidyr

Tidy Messy Data

v1.1.3
MIT + file LICENSE
Authors
Hadley Wickham [aut, cre], RStudio [cph]
Initial release

We don't support your browser anymore

Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.