This is an interactive area to better understand how common data transformations work. For now it explains the three most basic data transformations
cities
Groupingspartition the data for subsetquent operations but do not actually change it.
Mutations change existing data columns or add new ones, but leave the number of columns the same.
Sorts reorder the data by one or more columns but otherwise leave it untouched.
Filters remove rows based on a condition.
City
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cincinnati
Cleveland
Cleveland
Cleveland
Cleveland
Cleveland
Columbus
Columbus
Columbus
Columbus
Columbus
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Philadelphia
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
Pittsburgh
ST
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
OH
PA
PA
PA
PA
PA
PA
PA
PA
PA
PA
year
1800
1850
1900
1950
2000
1800
1850
1900
1950
2000
1800
1850
1900
1950
2000
1800
1850
1900
1950
2000
1800
1850
1900
1950
2000
population
0
115435
325902
503998
331285
0
17034
381768
914808
478403
0
17882
125560
375901
711470
41220
121376
1293697
2071605
1517550
0
46601
321616
676806
334563