if (!dir.exists('csv')) {dir.create('csv')}csv_fn <-"csv/psych-490-2023-fall-presentations.csv"googledrive::drive_download(file ='PSYCH 490.009 Fall 2023 Project Info (Responses)', path = csv_fn, type ='csv', overwrite =TRUE)
Auto-refreshing stale OAuth token.
File downloaded:
• 'PSYCH 490.009 Fall 2023 Project Info (Responses)'
<id: 1tgG8etFwMSyGVLeFbQUCChTmVLt0aImZlc9QEAbrXfs>
Saved locally as:
• 'csv/psych-490-2023-fall-presentations.csv'
if (file.exists(csv_fn)) { presentations_df <- readr::read_csv(csv_fn, show_col_types =FALSE)} else {message("File not found: ", csv_fn) presentations_df <-NULL}
Clean the data
new_names <-c("Timestamp","Authors","Title","Format","Give_talk","Preferred_date" )# Make new data frame with long and short names for referencepresentation_qs <- tibble::tibble(q_long =names(presentations_df), q_short = new_names)# Swap out old (long) names for new (short) namesnames(presentations_df) <- new_names