-
Notifications
You must be signed in to change notification settings - Fork 0
/
workshop_R.aux
143 lines (143 loc) · 12.5 KB
/
workshop_R.aux
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
\relax
\providecommand\hyper@newdestlabel[2]{}
\providecommand\HyperFirstAtBeginDocument{\AtBeginDocument}
\HyperFirstAtBeginDocument{\ifx\hyper@anchor\@undefined
\global\let\oldnewlabel\newlabel
\gdef\newlabel#1#2{\newlabelxx{#1}#2}
\gdef\newlabelxx#1#2#3#4#5#6{\oldnewlabel{#1}{{#2}{#3}}}
\AtEndDocument{\ifx\hyper@anchor\@undefined
\let\newlabel\oldnewlabel
\fi}
\fi}
\global\let\hyper@last\relax
\gdef\HyperFirstAtBeginDocument#1{#1}
\providecommand\HyField@AuxAddToFields[1]{}
\providecommand\HyField@AuxAddToCoFields[2]{}
\@writefile{toc}{\contentsline {section}{Introduction}{4}{section*.2}\protected@file@percent }
\newlabel{introduction}{{}{4}{Introduction}{section*.2}{}}
\@writefile{toc}{\contentsline {subsection}{What is a RAP?}{4}{section*.3}\protected@file@percent }
\newlabel{what-is-a-rap}{{}{4}{What is a RAP?}{section*.3}{}}
\@writefile{toc}{\contentsline {subsection}{What is R/R Studio?}{4}{section*.4}\protected@file@percent }
\newlabel{what-is-rr-studio}{{}{4}{What is R/R Studio?}{section*.4}{}}
\@writefile{lof}{\contentsline {figure}{\numberline {1}{\ignorespaces R studio panels\relax }}{5}{figure.caption.5}\protected@file@percent }
\providecommand*\caption@xref[2]{\@setref\relax\@undefined{#1}}
\newlabel{fig:unnamed-chunk-1}{{1}{5}{R studio panels\relax }{figure.caption.5}{}}
\@writefile{toc}{\contentsline {section}{ADA and databricks}{6}{section*.6}\protected@file@percent }
\newlabel{ada-and-databricks}{{}{6}{ADA and databricks}{section*.6}{}}
\@writefile{toc}{\contentsline {section}{Pre-workshop requirements}{6}{section*.7}\protected@file@percent }
\newlabel{pre-workshop-requirements}{{}{6}{Pre-workshop requirements}{section*.7}{}}
\@writefile{toc}{\contentsline {subsection}{Technical requirements}{6}{section*.8}\protected@file@percent }
\newlabel{technical-requirements}{{}{6}{Technical requirements}{section*.8}{}}
\@writefile{toc}{\contentsline {subsection}{Working in groups}{6}{section*.9}\protected@file@percent }
\newlabel{working-in-groups}{{}{6}{Working in groups}{section*.9}{}}
\@writefile{toc}{\contentsline {section}{Getting started \ldots {}}{7}{section*.10}\protected@file@percent }
\newlabel{getting-started}{{}{7}{Getting started \ldots {}}{section*.10}{}}
\@writefile{toc}{\contentsline {section}{Creating a project}{7}{section*.11}\protected@file@percent }
\newlabel{creating-a-project}{{}{7}{Creating a project}{section*.11}{}}
\@writefile{toc}{\contentsline {subsection}{Functions and packages}{8}{section*.12}\protected@file@percent }
\newlabel{functions-and-packages}{{}{8}{Functions and packages}{section*.12}{}}
\@writefile{toc}{\contentsline {subsubsection}{Using renv (optional)}{8}{section*.13}\protected@file@percent }
\newlabel{using-renv-optional}{{}{8}{Using renv (optional)}{section*.13}{}}
\@writefile{toc}{\contentsline {section}{Your initial script}{9}{section*.14}\protected@file@percent }
\newlabel{your-initial-script}{{}{9}{Your initial script}{section*.14}{}}
\@writefile{toc}{\contentsline {subsection}{Comments and headings}{9}{section*.15}\protected@file@percent }
\newlabel{comments-and-headings}{{}{9}{Comments and headings}{section*.15}{}}
\@writefile{lof}{\contentsline {figure}{\numberline {2}{\ignorespaces R Studio section headers navigation\relax }}{11}{figure.caption.16}\protected@file@percent }
\newlabel{fig:unnamed-chunk-2}{{2}{11}{R Studio section headers navigation\relax }{figure.caption.16}{}}
\@writefile{toc}{\contentsline {subsection}{Adding and running code}{11}{section*.17}\protected@file@percent }
\newlabel{adding-and-running-code}{{}{11}{Adding and running code}{section*.17}{}}
\@writefile{lof}{\contentsline {figure}{\numberline {3}{\ignorespaces R Studio run and source buttons\relax }}{12}{figure.caption.18}\protected@file@percent }
\newlabel{fig:unnamed-chunk-3}{{3}{12}{R Studio run and source buttons\relax }{figure.caption.18}{}}
\@writefile{toc}{\contentsline {subsection}{Data types and objects in R}{12}{section*.19}\protected@file@percent }
\newlabel{data-types-and-objects-in-r}{{}{12}{Data types and objects in R}{section*.19}{}}
\@writefile{toc}{\contentsline {subsubsection}{Basic data types}{13}{section*.20}\protected@file@percent }
\newlabel{basic-data-types}{{}{13}{Basic data types}{section*.20}{}}
\@writefile{toc}{\contentsline {subsubsection}{Basic data objects}{13}{section*.21}\protected@file@percent }
\newlabel{basic-data-objects}{{}{13}{Basic data objects}{section*.21}{}}
\@writefile{toc}{\contentsline {subsection}{Loading in the data}{16}{section*.22}\protected@file@percent }
\newlabel{loading-in-the-data}{{}{16}{Loading in the data}{section*.22}{}}
\@writefile{toc}{\contentsline {subsubsection}{Reading in CSVs}{16}{section*.23}\protected@file@percent }
\newlabel{reading-in-csvs}{{}{16}{Reading in CSVs}{section*.23}{}}
\@writefile{toc}{\contentsline {subsubsection}{Writing to and reading from a SQL database (optional section)}{17}{section*.24}\protected@file@percent }
\newlabel{writing-to-and-reading-from-a-sql-database-optional-section}{{}{17}{Writing to and reading from a SQL database (optional section)}{section*.24}{}}
\newlabel{writing-a-table-to-a-sql-database}{{}{18}{Writing a table to a SQL database}{section*.25}{}}
\@writefile{toc}{\contentsline {paragraph}{Writing a table to a SQL database}{18}{section*.25}\protected@file@percent }
\newlabel{reading-a-table-from-a-sql-database}{{}{19}{Reading a table from a SQL database}{section*.26}{}}
\@writefile{toc}{\contentsline {paragraph}{Reading a table from a SQL database}{19}{section*.26}\protected@file@percent }
\@writefile{toc}{\contentsline {section}{Cleaning data}{20}{section*.27}\protected@file@percent }
\newlabel{cleaning-data}{{}{20}{Cleaning data}{section*.27}{}}
\@writefile{toc}{\contentsline {subsection}{Dealing with missing values}{20}{section*.28}\protected@file@percent }
\newlabel{dealing-with-missing-values}{{}{20}{Dealing with missing values}{section*.28}{}}
\@writefile{toc}{\contentsline {subsection}{Dealing with duplicates}{22}{section*.29}\protected@file@percent }
\newlabel{dealing-with-duplicates}{{}{22}{Dealing with duplicates}{section*.29}{}}
\@writefile{toc}{\contentsline {section}{Descriptive statistics}{23}{section*.30}\protected@file@percent }
\newlabel{descriptive-statistics}{{}{23}{Descriptive statistics}{section*.30}{}}
\@writefile{toc}{\contentsline {section}{Manupilating data}{24}{section*.31}\protected@file@percent }
\newlabel{manupilating-data}{{}{24}{Manupilating data}{section*.31}{}}
\@writefile{toc}{\contentsline {subsection}{Aggregate \& filter data}{24}{section*.32}\protected@file@percent }
\newlabel{aggregate-filter-data}{{}{24}{Aggregate \& filter data}{section*.32}{}}
\@writefile{toc}{\contentsline {subsection}{Reorder and rename columns}{27}{section*.33}\protected@file@percent }
\newlabel{reorder-and-rename-columns}{{}{27}{Reorder and rename columns}{section*.33}{}}
\@writefile{toc}{\contentsline {subsection}{Suppression (and writing functions)}{29}{section*.34}\protected@file@percent }
\newlabel{suppression-and-writing-functions}{{}{29}{Suppression (and writing functions)}{section*.34}{}}
\@writefile{toc}{\contentsline {subsubsection}{Writing functions}{30}{section*.35}\protected@file@percent }
\newlabel{writing-functions}{{}{30}{Writing functions}{section*.35}{}}
\@writefile{toc}{\contentsline {subsubsection}{Nested functions}{31}{section*.36}\protected@file@percent }
\newlabel{nested-functions}{{}{31}{Nested functions}{section*.36}{}}
\@writefile{toc}{\contentsline {subsubsection}{if() and ifelse() statements}{32}{section*.37}\protected@file@percent }
\newlabel{if-and-ifelse-statements}{{}{32}{if() and ifelse() statements}{section*.37}{}}
\@writefile{toc}{\contentsline {subsubsection}{Function for suppression}{33}{section*.38}\protected@file@percent }
\newlabel{function-for-suppression}{{}{33}{Function for suppression}{section*.38}{}}
\@writefile{toc}{\contentsline {subsection}{Adding new columns}{36}{section*.39}\protected@file@percent }
\newlabel{adding-new-columns}{{}{36}{Adding new columns}{section*.39}{}}
\@writefile{toc}{\contentsline {subsection}{Joins \& joining geographic codes via lookup tables}{37}{section*.40}\protected@file@percent }
\newlabel{joins-joining-geographic-codes-via-lookup-tables}{{}{37}{Joins \& joining geographic codes via lookup tables}{section*.40}{}}
\@writefile{lof}{\contentsline {figure}{\numberline {4}{\ignorespaces R studio panels\relax }}{38}{figure.caption.41}\protected@file@percent }
\newlabel{fig:unnamed-chunk-4}{{4}{38}{R studio panels\relax }{figure.caption.41}{}}
\@writefile{toc}{\contentsline {subsection}{Reformatting data (wide -\textgreater {} long)}{39}{section*.42}\protected@file@percent }
\newlabel{reformatting-data-wide---long}{{}{39}{Reformatting data (wide -\textgreater {} long)}{section*.42}{}}
\@writefile{toc}{\contentsline {subsection}{Regular expressions}{40}{section*.43}\protected@file@percent }
\newlabel{regular-expressions}{{}{40}{Regular expressions}{section*.43}{}}
\@writefile{toc}{\contentsline {section}{Running a SQL query}{40}{section*.44}\protected@file@percent }
\newlabel{running-a-sql-query}{{}{40}{Running a SQL query}{section*.44}{}}
\@writefile{toc}{\contentsline {section}{Creating plots}{42}{section*.45}\protected@file@percent }
\newlabel{creating-plots}{{}{42}{Creating plots}{section*.45}{}}
\@writefile{toc}{\contentsline {subsection}{Creating functions for plots}{43}{section*.46}\protected@file@percent }
\newlabel{creating-functions-for-plots}{{}{43}{Creating functions for plots}{section*.46}{}}
\@writefile{toc}{\contentsline {section}{Using online resources}{44}{section*.47}\protected@file@percent }
\newlabel{using-online-resources}{{}{44}{Using online resources}{section*.47}{}}
\@writefile{toc}{\contentsline {subsection}{Google questions and errors}{44}{section*.48}\protected@file@percent }
\newlabel{google-questions-and-errors}{{}{44}{Google questions and errors}{section*.48}{}}
\@writefile{toc}{\contentsline {subsection}{Using chatGPT}{45}{section*.49}\protected@file@percent }
\newlabel{using-chatgpt}{{}{45}{Using chatGPT}{section*.49}{}}
\@writefile{toc}{\contentsline {section}{w-RAP it up}{47}{section*.50}\protected@file@percent }
\newlabel{w-rap-it-up}{{}{47}{w-RAP it up}{section*.50}{}}
\@writefile{toc}{\contentsline {section}{Unit testing in R}{47}{section*.51}\protected@file@percent }
\newlabel{unit-testing-in-r}{{}{47}{Unit testing in R}{section*.51}{}}
\@writefile{toc}{\contentsline {section}{dplyr vs.\nobreakspace {}data.table}{49}{section*.52}\protected@file@percent }
\newlabel{dplyr-vs.-data.table}{{}{49}{dplyr vs.~data.table}{section*.52}{}}
\@writefile{toc}{\contentsline {section}{Troubleshooting}{50}{section*.53}\protected@file@percent }
\newlabel{troubleshooting}{{}{50}{Troubleshooting}{section*.53}{}}
\@writefile{toc}{\contentsline {subsection}{renv}{50}{section*.54}\protected@file@percent }
\newlabel{renv}{{}{50}{renv}{section*.54}{}}
\@writefile{toc}{\contentsline {subsubsection}{renv::restore()}{50}{section*.55}\protected@file@percent }
\newlabel{renvrestore}{{}{50}{renv::restore()}{section*.55}{}}
\@writefile{toc}{\contentsline {subsubsection}{Updating packages in renv}{51}{section*.56}\protected@file@percent }
\newlabel{updating-packages-in-renv}{{}{51}{Updating packages in renv}{section*.56}{}}
\@writefile{toc}{\contentsline {subsubsection}{Installing old package versions in renv}{51}{section*.57}\protected@file@percent }
\newlabel{installing-old-package-versions-in-renv}{{}{51}{Installing old package versions in renv}{section*.57}{}}
\@writefile{toc}{\contentsline {subsection}{`Can't find make' error}{51}{section*.58}\protected@file@percent }
\newlabel{cant-find-make-error}{{}{51}{`Can't find make' error}{section*.58}{}}
\@writefile{toc}{\contentsline {section}{Excel functions in R}{53}{section*.59}\protected@file@percent }
\newlabel{excel-functions-in-r}{{}{53}{Excel functions in R}{section*.59}{}}
\@writefile{toc}{\contentsline {subsection}{VLOOKUP}{53}{section*.60}\protected@file@percent }
\newlabel{vlookup}{{}{53}{VLOOKUP}{section*.60}{}}
\@writefile{toc}{\contentsline {subsubsection}{Using base R}{53}{section*.62}\protected@file@percent }
\newlabel{using-base-r}{{}{53}{Using base R}{section*.62}{}}
\@writefile{lof}{\contentsline {figure}{\numberline {5}{\ignorespaces R studio panels\relax }}{54}{figure.caption.61}\protected@file@percent }
\newlabel{fig:unnamed-chunk-5}{{5}{54}{R studio panels\relax }{figure.caption.61}{}}
\@writefile{toc}{\contentsline {subsubsection}{Using dplyr}{55}{section*.63}\protected@file@percent }
\newlabel{using-dplyr}{{}{55}{Using dplyr}{section*.63}{}}
\@writefile{toc}{\contentsline {section}{SQL functions in R}{56}{section*.64}\protected@file@percent }
\newlabel{sql-functions-in-r}{{}{56}{SQL functions in R}{section*.64}{}}
\gdef \@abspage@last{58}