Data manipulation with dplyr

Kevin Bairos-Novak presents Data manipulation with dplyr --CHAT-- 00:07:31 Katrina Kaposi: hello :) 00:07:45 Jacob Westaway: Good Morning! 00:16:06 Katrina Kaposi: limited... 00:16:08 Ronal: no experience Kevin (beginner) 00:16:09 Maxine: Less than beginner 00:16:10 Kathleen Vowles: intermediate 00:16:11 Ryley Dorney: Intermediate 00:16:12 Katrina Kaposi: still trying to get my head around everything 00:16:23 Jacob Westaway: Love you Kevin 00:16:27 Ashton: Beginners here in Cairns as well 00:17:07 Aurelie Moya: Used to be intermediate a few years ago but now I feel like I’m beginner ;) 00:22:12 Natalia: Short cut to type ‘% % ‘ is “shift” “command” 00:22:35 Natalia: Ups : shift command M 00:22:56 Ronal: installed 00:34:27 Legana Fingerhut: - 00:38:23 Kevin Erickson: - 00:38:27 Legana Fingerhut: ! 00:38:29 Natalia: ! 00:38:50 Legana Fingerhut: != 00:40:18 Legana Fingerhut: % % 00:40:23 Legana Fingerhut: Year == 2007 00:42:38 Kevin Erickson: Note South Sudan will be in 2011 and newer, not before. 00:45:02 Kevin Bairos-Novak [JCU]: How’s everyone travelling? Anyone get it yet? 00:45:11 Yomani Sarathkumara: Africa - gapminder% % filter(continent=="Africa")% % select(year, country,lifeExp) 00:46:04 Legana Fingerhut: Great Yomani 🙂 00:46:40 Kevin Bairos-Novak [JCU]: https://regexone.com/ 00:46:55 Aurelie Moya: Got it too now. I had forgotten the % % between the filter and select. 00:46:56 Legana Fingerhut: The select function is also useful for rearranging column names 00:47:03 Aurelie Moya: Thank you 00:50:42 Legana Fingerhut: head() works too to get the column names for a dataset, but its mostly only efficient for small datasets 00:56:11 Katrina Kaposi: this is amazing! 01:01:14 Legana Fingerhut: gapminder % % group_by(country) % % summarise(average_life_exp = mean(lifeExp)) % % arrange(average_life_exp) 01:04:27 Jacob Westaway: I do it! 01:04:31 Jacob Westaway: often! 01:04:31 Katrina Kaposi: yes! 01:06:47 Legana Fingerhut: One nice thing about the count function is that is has a built in sort argument 01:07:17 Legana Fingerhut: So you can sort it by values easily. e.g. gapminder % % count(continent, sort = TRUE) 01:14:15 Katrina Kaposi: Hi I have to run... thank you so so so much everyone! 01:14:21 Katrina Kaposi: Thanks Kevin! 01:14:23 Legana Fingerhut: Bye Katrina! 01:14:28 Legana Fingerhut: Thanks for coming 🙂 01:15:19 Legana Fingerhut: I loooooooove ifelse … and case_when 🙂 01:17:33 Aurelie Moya: Thank you very much!!! 01:17:34 Ashton: Really great session, thank you 01:18:06 Natalia: `summarise()` ungrouping output (override with `.groups` argument) 01:21:35 Aurelie Moya: Thank you!