ABCDEFGHIJKLMN
1
ScreencastDateTimestamp
Timestamp (with hours)
123
Timestamp (sec)
LinkDescriptionFunctionsPackagesConcepts
2
College Majors and Income2018-10-151:450:1:450145105https://www.youtube.com/watch?v=nx5yhXAQLxw&t=105sUsing read_csv function to import data directly from Github to R (without cloning the repository)read_csv
3
College Majors and Income2018-10-157:200:7:200720440https://www.youtube.com/watch?v=nx5yhXAQLxw&t=440sCreating a histogram (geom_histogram), then a boxplot (geom_boxplot), to explore the distribution of salariesgeom_histogram | geom_boxplot
4
College Majors and Income2018-10-158:550:8:550855535https://www.youtube.com/watch?v=nx5yhXAQLxw&t=535sUsing fct_reorder function to sort boxplot of college majors by salaryfct_reorder
5
College Majors and Income2018-10-159:350:9:350935575https://www.youtube.com/watch?v=nx5yhXAQLxw&t=575s
Using dollar_format function from scales package to convert scientific notation to dollar format (e.g., "4e+04" becomes "$40,000")
dollar_formatscales
6
College Majors and Income2018-10-1514:100:14:1001410850https://www.youtube.com/watch?v=nx5yhXAQLxw&t=850s
Creating a dotplot (geom_point) of 20 top-earning majors (includes adjusting axis, using the colour aesthetic, and adding error bars)
geom_point
7
College Majors and Income2018-10-1517:450:17:45017451065https://www.youtube.com/watch?v=nx5yhXAQLxw&t=1065sUsing str_to_title function to convert string from ALL CAPS to Title Casestr_to_title
8
College Majors and Income2018-10-1520:450:20:45020451245https://www.youtube.com/watch?v=nx5yhXAQLxw&t=1245sCreating a Bland-Altman graph to explore relationship between sample size and median salary
9
College Majors and Income2018-10-1521:450:21:45021451305https://www.youtube.com/watch?v=nx5yhXAQLxw&t=1305sUsing geom_text_repel function from ggrepel package to get text labels on scatter plot pointsgeom_text_repelggrepel
10
College Majors and Income2018-10-1528:300:28:30028301710https://www.youtube.com/watch?v=nx5yhXAQLxw&t=1710sUsing count function's wt argument to specify what should be counted (default is number of rows)count
11
College Majors and Income2018-10-1530:000:30:00030001800https://www.youtube.com/watch?v=nx5yhXAQLxw&t=1800sSpicing up a dull bar graph by adding a redundant colour aesthetic (trick from Julia Silge)
12
College Majors and Income2018-10-1536:200:36:20036202180https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2180sStarting to explore relationship between gender and salary
13
College Majors and Income2018-10-1537:100:37:10037102230https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2230sCreating a stacked bar graph (geom_col) of gender breakdown within majorsgeom_col
14
College Majors and Income2018-10-1540:150:40:15040152415https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2415sUsing summarise_at to aggregate men and women from majors into categories of majorssummarise_at
15
College Majors and Income2018-10-1545:300:45:30045302730https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2730sGraphing scatterplot (geom_point) of share of women and median salarygeom_point
16
College Majors and Income2018-10-1547:100:47:10047102830https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2830sUsing geom_smooth function to add a line of best fit to scatterplot abovegeom_smooth
17
College Majors and Income2018-10-1548:400:48:40048402920https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2920s
Explanation of why not to aggregate first when performing a statistical test (including explanation of Simpson's Paradox)
18
College Majors and Income2018-10-1549:550:49:55049552995https://www.youtube.com/watch?v=nx5yhXAQLxw&t=2995sFixing geom_smooth so that we get one overall line while still being able to map to the colour aestheticgeom_smooth
19
College Majors and Income2018-10-1551:100:51:10051103070https://www.youtube.com/watch?v=nx5yhXAQLxw&t=3070sPredicting median salary from share of women with weighted linear regression (to take sample sizes into account)lm
20
College Majors and Income2018-10-1556:050:56:05056053365https://www.youtube.com/watch?v=nx5yhXAQLxw&t=3365sUsing nest function and tidy function from the broom package to apply a linear model to many categories at oncenest | tidybroom
21
College Majors and Income2018-10-1558:050:58:05058053485https://www.youtube.com/watch?v=nx5yhXAQLxw&t=3485sUsing p.adjust function to adjust p-values to correct for multiple testing (using FDR, False Discovery Rate)p.adjust
22
College Majors and Income2018-10-151:04:501:04:50104503890https://www.youtube.com/watch?v=nx5yhXAQLxw&t=3890sShowing how to add an appendix to an RMarkdown file with code that doesn't run when compiled
23
College Majors and Income2018-10-151:09:001:09:00109004140https://www.youtube.com/watch?v=nx5yhXAQLxw&t=4140sUsing fct_lump function to aggregate major categories into the top four and an "Other" categoryfct_lump
24
College Majors and Income2018-10-151:10:051:10:05110054205https://www.youtube.com/watch?v=nx5yhXAQLxw&t=4205sAdding sample size to the size aesthetic within the aes function
25
College Majors and Income2018-10-151:10:501:10:50110504250https://www.youtube.com/watch?v=nx5yhXAQLxw&t=4250s
Using ggplotly function from plotly package to create an interactive scatterplot (tooltips appear when moused over)
ggplotlyplotly
26
College Majors and Income2018-10-151:15:551:15:55115554555https://www.youtube.com/watch?v=nx5yhXAQLxw&t=4555sExploring IQR (Inter-Quartile Range) of salaries by major
27
Horror Movie Profits2018-10-232:500:2:500250170https://www.youtube.com/watch?v=3-DRwg9yeNA&t=170s
Using parse_date function from lubridate package to convert date formatted as character to date class (should have used mdy function though)
parse_datelubridate
28
Horror Movie Profits2018-10-237:450:7:450745465https://www.youtube.com/watch?v=3-DRwg9yeNA&t=465sUsing fct_lump function to aggregate distributors into top 6 (by number of movies) and and "Other" categoryfct_lump
29
Horror Movie Profits2018-10-238:500:8:500850530https://www.youtube.com/watch?v=3-DRwg9yeNA&t=530sInvestigating strange numbers in the data and discovering duplication
30
Horror Movie Profits2018-10-2312:400:12:4001240760https://www.youtube.com/watch?v=3-DRwg9yeNA&t=760sUsing problems function to look at parsing errors when importing dataproblems
31
Horror Movie Profits2018-10-2314:350:14:3501435875https://www.youtube.com/watch?v=3-DRwg9yeNA&t=875sUsing arrange and distinct function and its .keep_all argument to de-duplicate observationsarrange | distinct
32
Horror Movie Profits2018-10-2316:100:16:1001610970https://www.youtube.com/watch?v=3-DRwg9yeNA&t=970sUsing geom_boxplot function to create a boxplot of budget by distributorgoem_boxplot
33
Horror Movie Profits2018-10-2319:200:19:20019201160https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1160sUsing floor function to bin release years into decades (e.g., "1970" and "1973" both become "1970")floor
34
Horror Movie Profits2018-10-2321:300:21:30021301290https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1290sUsing summarise_at function to apply the same function to multiple variables at the same timesummarise_at
35
Horror Movie Profits2018-10-2324:100:24:10024101450https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1450sUsing geom_line to visualize multiple metrics at the same timegeom_line
36
Horror Movie Profits2018-10-2326:000:26:00026001560https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1560sUsing facet_wrap function to graph small multiples of genre-budget boxplots by distributorfacet_wrap
37
Horror Movie Profits2018-10-2328:350:28:35028351715https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1715sStarting analysis of profit ratio of movies
38
Horror Movie Profits2018-10-2332:500:32:50032501970https://www.youtube.com/watch?v=3-DRwg9yeNA&t=1970s
Using paste0 function in a custom function to show labels of multiple (e.g., "4X" or "6X" to mean "4 times" or "6 times")
paste0
39
Horror Movie Profits2018-10-2341:200:41:20041202480https://www.youtube.com/watch?v=3-DRwg9yeNA&t=2480sStarting analysis of the most common genres over time
40
Horror Movie Profits2018-10-2345:550:45:55045552755https://www.youtube.com/watch?v=3-DRwg9yeNA&t=2755sStarting analysis of the most profitable individual horror movies
41
Horror Movie Profits2018-10-2351:450:51:45051453105https://www.youtube.com/watch?v=3-DRwg9yeNA&t=3105sUsing paste0 function to add release date of movie to labels in a bar graphpaste0
42
Horror Movie Profits2018-10-2353:250:53:25053253205https://www.youtube.com/watch?v=3-DRwg9yeNA&t=3205sUsing geom_text function, along with its check_overlap argument, to add labels to some points on a scatterplotgeom_text
43
Horror Movie Profits2018-10-2358:100:58:10058103490https://www.youtube.com/watch?v=3-DRwg9yeNA&t=3490sUsing ggplotly function from plotly package to create an interactive scatterplotggplotlyplotly
44
Horror Movie Profits2018-10-231:00:551:00:55100553655https://www.youtube.com/watch?v=3-DRwg9yeNA&t=3655sReviewing unexplored areas of investigation
45
R Downloads2018-10-305:200:5:200520320https://www.youtube.com/watch?v=nms9F-XubJU&t=320sUsing geom_line function to visualize changes over timegeom_line
46
R Downloads2018-10-307:350:7:350735455https://www.youtube.com/watch?v=nms9F-XubJU&t=455s
Starting to decompose time series data into day-of-week trend and overall trend (lots of lubridate package functions)
lubridate
47
R Downloads2018-10-309:500:9:500950590https://www.youtube.com/watch?v=nms9F-XubJU&t=590sUsing floor_date function from lubridate package to round dates down to the week level
48
R Downloads2018-10-3010:050:10:0501005605https://www.youtube.com/watch?v=nms9F-XubJU&t=605sUsing min function to drop incomplete/partial week at the start of the dataset
49
R Downloads2018-10-3012:200:12:2001220740https://www.youtube.com/watch?v=nms9F-XubJU&t=740s
Using countrycode function from countrycode package to replace two-letter country codes with full names (e.g., "CA" becomes "Canada")
countrycodecountrycode
50
R Downloads2018-10-3017:200:17:20017201040https://www.youtube.com/watch?v=nms9F-XubJU&t=1040sUsing fct_lump function to get top N categories within a categorical variable and classify the rest as "Other"fct_lump
51
R Downloads2018-10-3020:300:20:30020301230https://www.youtube.com/watch?v=nms9F-XubJU&t=1230sUsing hour function from lubridate package to pull out integer hour value from a datetime variablehourlubridate
52
R Downloads2018-10-3022:200:22:20022201340https://www.youtube.com/watch?v=nms9F-XubJU&t=1340s
Using facet_wrap function to graph small multiples of downloads by country, then changing scales argument to allow different scales on y-axis
facet_wrap
53
R Downloads2018-10-3031:000:31:00031001860https://www.youtube.com/watch?v=nms9F-XubJU&t=1860sStarting analysis of downloads by IP address
54
R Downloads2018-10-3035:200:35:20035202120https://www.youtube.com/watch?v=nms9F-XubJU&t=2120sUsing as.POSIXlt to combine separate date and time variables to get a single datetime variableas.POSIXlt
55
R Downloads2018-10-3036:350:36:35036352195https://www.youtube.com/watch?v=nms9F-XubJU&t=2195s
Using lag function to calculate time between downloads (time between events) per IP address (comparable to SQL window function)
lag
56
R Downloads2018-10-3038:050:38:05038052285https://www.youtube.com/watch?v=nms9F-XubJU&t=2285sUsing as.numeric function to convert variable from a time interval object to a numeric variable (number in seconds)as.numeric
57
R Downloads2018-10-3038:400:38:40038402320https://www.youtube.com/watch?v=nms9F-XubJU&t=2320sExplanation of a bimodal log-normal distribution
58
R Downloads2018-10-3039:050:39:05039052345https://www.youtube.com/watch?v=nms9F-XubJU&t=2345sHandy trick for setting easy-to-interpret intervals for time data on scale_x_log10 function's breaks argumentscale_x_log10
59
R Downloads2018-10-3047:400:47:40047402860https://www.youtube.com/watch?v=nms9F-XubJU&t=2860sStarting to explore package downloads
60
R Downloads2018-10-3052:150:52:15052153135https://www.youtube.com/watch?v=nms9F-XubJU&t=3135sAdding 1 to the numerator and denominator when calculating a ratio to get around dividing by zero
61
R Downloads2018-10-3057:550:57:55057553475https://www.youtube.com/watch?v=nms9F-XubJU&t=3475s
Showing how to look at package download data over time using cran_downloads function from the cranlogs package
cran_downloadscranlogs
62
US Wind Turbines2018-11-063:500:3:500350230https://www.youtube.com/watch?v=O1oDIQV6VKU&t=230sUsing count function to explore categorical variablescount
63
US Wind Turbines2018-11-065:000:5:000500300https://www.youtube.com/watch?v=O1oDIQV6VKU&t=300sCreating a quick-and-dirty map using geom_point function and latitude and longitude datageom_pointVisualisation
64
US Wind Turbines2018-11-066:100:6:100610370https://www.youtube.com/watch?v=O1oDIQV6VKU&t=370sExplaining need for mapproj package when plotting maps in ggplot2coord_mapmapproj
65
US Wind Turbines2018-11-067:350:7:350735455https://www.youtube.com/watch?v=O1oDIQV6VKU&t=455sUsing borders function to add US state borders to mapbordersVisualisation
66
US Wind Turbines2018-11-0610:450:10:4501045645https://www.youtube.com/watch?v=O1oDIQV6VKU&t=645sUsing fct_lump to get the top 6 project categories and put the rest in a lumped "Other" categoryfct_lump
67
US Wind Turbines2018-11-0611:300:11:3001130690https://www.youtube.com/watch?v=O1oDIQV6VKU&t=690sChanging data so that certain categories' points appear in front of other categories' points on the mapVisualisation
68
US Wind Turbines2018-11-0614:150:14:1501415855https://www.youtube.com/watch?v=O1oDIQV6VKU&t=855s
Taking the centroid (average longitude and latitude) of points across a geographic area as a way to aggregate categories to one point
69
US Wind Turbines2018-11-0619:400:19:40019401180https://www.youtube.com/watch?v=O1oDIQV6VKU&t=1180sUsing ifelse function to clean missing data that is coded as "-9999"ifelse
70
US Wind Turbines2018-11-0626:000:26:00026001560https://www.youtube.com/watch?v=O1oDIQV6VKU&t=1560sAsking, "How has turbine capacity changed over time?"
71
US Wind Turbines2018-11-0633:150:33:15033151995https://www.youtube.com/watch?v=O1oDIQV6VKU&t=1995sExploring different models of wind turbines
72
US Wind Turbines2018-11-0638:000:38:00038002280https://www.youtube.com/watch?v=O1oDIQV6VKU&t=2280s
Using mutate_if function to find NA values (coded as -9999) in multiple columns and replace them with an actual NA
mutate_ifData cleaning and manipulation
73
US Wind Turbines2018-11-0645:400:45:40045402740https://www.youtube.com/watch?v=O1oDIQV6VKU&t=2740sReviewing documentation for gganimate packagegganimate
74
US Wind Turbines2018-11-0647:000:47:00047002820https://www.youtube.com/watch?v=O1oDIQV6VKU&t=2820sAttempting to set up gganimate mapgganimateVisualisation
75
US Wind Turbines2018-11-0648:550:48:55048552935https://www.youtube.com/watch?v=O1oDIQV6VKU&t=2935sUnderstanding gganimate package using a "Hello World" / toy example, then trying to debug turbine animationgganimateVisualisation
76
US Wind Turbines2018-11-0656:450:56:45056453405https://www.youtube.com/watch?v=O1oDIQV6VKU&t=3405sUsing is.infinite function to get rid of troublesome Inf valuesis.infiniteData cleaning and manipulation
77
US Wind Turbines2018-11-0657:550:57:55057553475https://www.youtube.com/watch?v=O1oDIQV6VKU&t=3475s
Quick hack for getting cumulative data from a table using crossing function (though it does end up with some duplication)
crossingData cleaning and manipulation
78
US Wind Turbines2018-11-061:01:451:01:45101453705https://www.youtube.com/watch?v=O1oDIQV6VKU&t=3705sDiagnosis of gganimate issue (points between integer years are being interpolated)gganimateVisualisation
79
US Wind Turbines2018-11-061:04:351:04:35104353875https://www.youtube.com/watch?v=O1oDIQV6VKU&t=3875sPseudo-successful gganimate map (cumulative points show up, but some points are missing)gganimate
80
US Wind Turbines2018-11-061:05:401:05:40105403940https://www.youtube.com/watch?v=O1oDIQV6VKU&t=3940sSummary of screencast
81
Malaria Incidence2018-11-122:450:2:450245165https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=165sImporting data using the malariaAtlas packagemalariaAtlas
82
Malaria Incidence2018-11-1214:100:14:1001410850https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=850sUsing geom_line function to visualize malaria prevalence over timegeom_line
83
Malaria Incidence2018-11-1215:100:15:1001510910https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=910sQuick map visualization using longitude and latitude coordinates and the geom_point functiongeom_point
84
Malaria Incidence2018-11-1218:400:18:40018401120https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1120sUsing borders function to add Kenyan country borders to mapborders
85
Malaria Incidence2018-11-1219:500:19:50019501190https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1190sUsing scale_colour_gradient2 function to change the colour scale of points on the mapscale_colour_gradient2
86
Malaria Incidence2018-11-1220:400:20:40020401240https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1240sUsing arrange function to ensure that certain points on a map appear in front of/behind other pointsarrange
87
Malaria Incidence2018-11-1221:500:21:50021501310https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1310sAggregating data into decades using the truncated division operator %/%%/%
88
Malaria Incidence2018-11-1224:450:24:45024451485https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1485sStarting to look at aggregated malaria data (instead of country-specific data)
89
Malaria Incidence2018-11-1226:500:26:50026501610https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1610sUsing sample and unique functions to randomly select a few countries, which are then graphedsample | unique
90
Malaria Incidence2018-11-1228:300:28:30028301710https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1710sUsing last function to select the most recent observation from a set of arranged datalast
91
Malaria Incidence2018-11-1232:550:32:55032551975https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=1975s
Creating a Bland-Altman plot to explore relationship between current incidence and change in incidence in past 15 years
92
Malaria Incidence2018-11-1235:450:35:45035452145https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2145sUsing anti_join function to find which countries are not in the malaria datasetanti_join
93
Malaria Incidence2018-11-1236:400:36:40036402200https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2200s
Using the iso3166 dataset set in the maps package to match three-letter country code (i.e., the ISO 3166 code) with country names
maps
94
Malaria Incidence2018-11-1238:300:38:30038302310https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2310sCreating a world map using geom_polygon function (and eventually theme_void and coord_map functions)geom_polygon | theme_void | coord_map
95
Malaria Incidence2018-11-1239:000:39:00039002340https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2340sGetting rid of Antarctica from world map
96
Malaria Incidence2018-11-1242:350:42:35042352555https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2555sUsing facet_wrap function to create small multiples of world map for different time periodsfacet_wrap
97
Malaria Incidence2018-11-1247:300:47:30047302850https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=2850sStarting to create an animated map of malaria deaths (actual code writing starts at 57:45)
98
Malaria Incidence2018-11-1251:250:51:25051253085https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=3085sStarting with a single year after working through some bugs
99
Malaria Incidence2018-11-1252:100:52:10052103130https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=3130s
Using regex_inner_join function from the fuzzyjoin package to join map datasets because one of them has values in regular expressions
regex_inner_joinfuzzyjoin
100
Malaria Incidence2018-11-1255:150:55:15055153315https://www.youtube.com/watch?v=5_6O2oDy5Jk&t=3315sAs alternative to fuzzyjoin package in above step, using str_remove function to get rid of unwanted regexstr_remove