Introd u ction to Tid y Data W OR K IN G W ITH DATA IN TH E - PowerPoint PPT Presentation

Introd u ction to Tid y Data W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist

WORKING WITH DATA IN THE TIDYVERSE

The Great British Bake Off Series 8 WORKING WITH DATA IN THE TIDYVERSE

WORKING WITH DATA IN THE TIDYVERSE

Tame b u t u n - tid y juniors_untidy # A tibble: 4 x 4 baker cinnamon_1 cardamom_2 nutmeg_3 <chr> <int> <int> <int> 1 Emma 1 0 1 2 Harry 1 1 1 3 Ruby 1 0 1 4 Zainab 0 NA 0 WORKING WITH DATA IN THE TIDYVERSE

Tid y data juniors_tidy # A tibble: 12 x 4 baker spice order correct <chr> <chr> <int> <int> 1 Emma cinnamon 1 1 2 Harry cinnamon 1 1 3 Ruby cinnamon 1 1 4 Zainab cinnamon 1 0 5 Emma cardamom 2 0 6 Harry cardamom 2 1 7 Ruby cardamom 2 0 8 Zainab cardamom 2 NA 9 Emma nutmeg 3 1 10 Harry nutmeg 3 1 11 Ruby nutmeg 3 1 12 Zainab nutmeg 3 0 WORKING WITH DATA IN THE TIDYVERSE

Who w on ? Co u nt it ! juniors_tidy %>% count(baker, wt = correct) # A tibble: 4 x 2 baker n <chr> <int> 1 Emma 2 2 Harry 3 3 Ruby 2 4 Zainab 0 WORKING WITH DATA IN THE TIDYVERSE

Who w on ? Plot it ! ggplot(juniors_tidy, aes(baker, correct)) + geom_col() WORKING WITH DATA IN THE TIDYVERSE

Which spice w as the hardest to g u ess ? Co u nt it ! ggplot(juniors_tidy, aes(baker, correct)) + geom_col() WORKING WITH DATA IN THE TIDYVERSE

Which spice w as the hardest to g u ess ? Plot it ! ggplot(juniors_tidy, aes(spice, correct)) + geom_col() WORKING WITH DATA IN THE TIDYVERSE

Insert title here ... WORKING WITH DATA IN THE TIDYVERSE

Let ' s get to w ork ! W OR K IN G W ITH DATA IN TH E TIDYVE R SE

Gather W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist

The ` tid y r ` package 1 h � p :// tid y r . tid yv erse . org ## Title ```y aml t y pe : F u llSlide ke y: e 6 e 5223 c 49 hide _ title : tr u e ``` WORKING WITH DATA IN THE TIDYVERSE

Gather : u sage ?gather WORKING WITH DATA IN THE TIDYVERSE

Gather : arg u ments ?gather WORKING WITH DATA IN THE TIDYVERSE

Gathering j u niors WORKING WITH DATA IN THE TIDYVERSE

Gathering w hat y o u ha v e into w hat y o u w ant WORKING WITH DATA IN THE TIDYVERSE

The ke y col u mn WORKING WITH DATA IN THE TIDYVERSE

The v al u e col u mn WORKING WITH DATA IN THE TIDYVERSE

A little trick WORKING WITH DATA IN THE TIDYVERSE

Let ' s get to w ork ! W OR K IN G W ITH DATA IN TH E TIDYVE R SE

Separate W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist

Gathering the j u niors data WORKING WITH DATA IN THE TIDYVERSE

Separate : u sage ?separate WORKING WITH DATA IN THE TIDYVERSE

Separate : arg u ments ?separate WORKING WITH DATA IN THE TIDYVERSE

Separating w hat y o u ha v e into w hat y o u w ant WORKING WITH DATA IN THE TIDYVERSE

Separate ` spice ` WORKING WITH DATA IN THE TIDYVERSE

Reminder : pre - separate juniors_untidy %>% gather(key = spice, value = correct, -baker) # A tibble: 12 x 3 baker spice correct <chr> <chr> <int> 1 Emma cinnamon_1 1 2 Harry cinnamon_1 1 3 Ruby cinnamon_1 1 4 Zainab cinnamon_1 0 5 Emma cardamom_2 0 6 Harry cardamom_2 1 7 Ruby cardamom_2 0 8 Zainab cardamom_2 NA 9 Emma nutmeg_3 1 10 Harry nutmeg_3 1 11 Ruby nutmeg_3 1 12 Zainab nutmeg_3 0 WORKING WITH DATA IN THE TIDYVERSE

Gather and separate juniors_untidy %>% gather(key = "spice", value = "correct", -baker) %>% separate(spice, into = c("spice", "order")) # A tibble: 12 x 4 baker spice order correct <chr> <chr> <chr> <int> 1 Emma cinnamon 1 1 2 Harry cinnamon 1 1 3 Ruby cinnamon 1 1 4 Zainab cinnamon 1 0 5 Emma cardamom 2 0 6 Harry cardamom 2 1 7 Ruby cardamom 2 0 8 Zainab cardamom 2 NA 9 Emma nutmeg 3 1 10 Harry nutmeg 3 1 11 Ruby nutmeg 3 1 12 Zainab nutmeg 3 0 WORKING WITH DATA IN THE TIDYVERSE

Gather , separate , and con v ert t y pes juniors_untidy %>% gather(key = "spice", value = "correct", -baker) %>% separate(spice, into = c("spice", "order"), convert = TRUE) # A tibble: 12 x 4 baker spice order correct <chr> <chr> <int> <int> 1 Emma cinnamon 1 1 2 Harry cinnamon 1 1 3 Ruby cinnamon 1 1 4 Zainab cinnamon 1 0 5 Emma cardamom 2 0 6 Harry cardamom 2 1 7 Ruby cardamom 2 0 8 Zainab cardamom 2 NA 9 Emma nutmeg 3 1 10 Harry nutmeg 3 1 11 Ruby nutmeg 3 1 12 Zainab nutmeg 3 0 WORKING WITH DATA IN THE TIDYVERSE

Before and after separate # A tibble: 12 x 3 # A tibble: 12 x 4 baker spice correct baker spice order correct <chr> <chr> <int> <chr> <chr> <int> <int> 1 Emma cinnamon_1 1 1 Emma cinnamon 1 1 2 Harry cinnamon_1 1 2 Harry cinnamon 1 1 3 Ruby cinnamon_1 1 3 Ruby cinnamon 1 1 4 Zainab cinnamon_1 0 4 Zainab cinnamon 1 0 5 Emma cardamom_2 0 5 Emma cardamom 2 0 6 Harry cardamom_2 1 6 Harry cardamom 2 1 7 Ruby cardamom_2 0 7 Ruby cardamom 2 0 8 Zainab cardamom_2 NA 8 Zainab cardamom 2 NA 9 Emma nutmeg_3 1 9 Emma nutmeg 3 1 10 Harry nutmeg_3 1 10 Harry nutmeg 3 1 11 Ruby nutmeg_3 1 11 Ruby nutmeg 3 1 12 Zainab nutmeg_3 0 12 Zainab nutmeg 3 0 WORKING WITH DATA IN THE TIDYVERSE

The ` sep ` arg u ment ?separate WORKING WITH DATA IN THE TIDYVERSE

Let ' s practice ! W OR K IN G W ITH DATA IN TH E TIDYVE R SE

Spread W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist

Gather WORKING WITH DATA IN THE TIDYVERSE

Spread WORKING WITH DATA IN THE TIDYVERSE

Spread : u sage ?spread WORKING WITH DATA IN THE TIDYVERSE

Spread : arg u ments ?spread WORKING WITH DATA IN THE TIDYVERSE

Using spread juniors_jumbled %>% juniors_jumbled spread(key = key, value = value) # A tibble: 12 x 3 # A tibble: 4 x 4 baker key value baker age outcome spices <chr> <chr> <chr> <chr> <chr> <chr> <chr> 1 Emma age 11 1 Emma 11 finalist 2 2 Harry age 10 2 Harry 10 winner 3 3 Ruby age 11 3 Ruby 11 finalist 2 4 Zainab age 10 4 Zainab 10 finalist 0 5 Emma outcome finalist 6 Harry outcome winner 7 Ruby outcome finalist 8 Zainab outcome finalist 9 Emma spices 2 10 Harry spices 3 11 Ruby spices 2 12 Zainab spices 0 WORKING WITH DATA IN THE TIDYVERSE

Spread and con v ert juniors_jumbled %>% juniors_jumbled spread(key = key, value = value, convert = TRUE) # A tibble: 12 x 3 baker key value # A tibble: 4 x 4 <chr> <chr> <chr> baker age outcome spices 1 Emma age 11 <chr> <int> <chr> <int> 2 Harry age 10 1 Emma 11 finalist 2 3 Ruby age 11 2 Harry 10 winner 3 4 Zainab age 10 3 Ruby 11 finalist 2 5 Emma outcome finalist 4 Zainab 10 finalist 0 6 Harry outcome winner 7 Ruby outcome finalist 8 Zainab outcome finalist 9 Emma spices 2 10 Harry spices 3 11 Ruby spices 2 12 Zainab spices 0 WORKING WITH DATA IN THE TIDYVERSE

Spread re v ie w WORKING WITH DATA IN THE TIDYVERSE

Let ' s practice ! W OR K IN G W ITH DATA IN TH E TIDYVE R SE

Tid y m u ltiple sets of col u mns W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist

Introd u ction to Tid y Data W OR K IN G W ITH DATA IN TH E - PowerPoint PPT Presentation

Introd u ction to Tid y Data W OR K IN G W ITH DATA IN TH E TIDYVE R SE Alison Hill Professor & Data Scientist WORKING WITH DATA IN THE TIDYVERSE WORKING WITH DATA IN THE TIDYVERSE The Great British Bake Off Series 8 WORKING WITH DATA

Introd u ction : Working With Web Data in R W OR K IN G W ITH W E B DATA IN R Oli v er Ke y

Introd u ction to Te x t Encoding FE ATU R E E N G IN E E R IN G FOR MAC H IN E L E AR N IN G

Introd u ction VISU AL IZIN G G E OSPATIAL DATA IN P YTH ON Mar y v an Valkenb u rg Data

Introd u ction to iterators P YTH ON DATA SC IE N C E TOOL BOX ( PAR T 2 ) H u go Bo w ne -

Introd u ction to a u dio data in P y thon SP OK E N L AN G U AG E P R OC E SSIN G IN P YTH ON

Introd u ction to APIs and JSONs IN TE R ME D IATE IMP OR TIN G DATA IN P YTH ON H u go Bo w

Introd u ction to the dataset W OR K IN G W ITH G E OSPATIAL DATA IN P YTH ON Joris Van den

Introd u ction to s w imming data C ASE STU D IE S IN STATISTIC AL TH IN K IN G J u stin Bois

Introd u ction to statistical seismolog y C ASE STU D IE S IN STATISTIC AL TH IN K IN G J u

Introd u ction to relational databases IN TR OD U C TION TO IMP OR TIN G DATA IN P YTH ON H u

Introd u ction to databases STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo uz

Introd u ction to E x plorator y Data Anal y sis STATISTIC AL TH IN K IN G IN P YTH ON ( PAR T 1

Introd u ction to spreadsheets STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo

Introd u ction IN TE R ME D IATE IN TE R AC TIVE DATA VISU AL IZATION W ITH P L OTLY IN R

Introd u ction to the space la u nches data IN TE R ME D IATE IN TE R AC TIVE DATA VISU AL

Introd u ction to the NASA fireball data set BU IL D IN G DASH BOAR D S W ITH SH IN YDASH BOAR

Introd u ction to JSON STR E AML IN E D DATA IN G E STION W ITH PAN DAS Aman y Mahfo uz Instr

Introd u ction to Net w orks IN TR OD U C TION TO N E TW OR K AN ALYSIS IN P YTH ON Eric Ma

Introd u ction to animation IN TE R ME D IATE IN TE R AC TIVE DATA VISU AL IZATION W ITH P L

Welcome and Introd u ction SU P E R VISE D L E AR N IN G IN R : R E G R E SSION Nina Z u mel and

Introd u ction to Teacher Forcing MAC H IN E TR AN SL ATION IN P YTH ON Th u shan Ganegedara

Introd u ction IN TR OD U C TION TO DATA VISU AL IZATION W ITH G G P L OT 2 Rick Sca v e a

Introd u ction to NLP feat u re engineering FE ATU R E E N G IN E E R IN G FOR N L P IN P YTH

Introd u ction to P y D u b SP OK E N L AN G U AG E P R OC E SSIN G IN P YTH ON Daniel Bo u