Skip to content
Home ยป google spreadsheets

google spreadsheets

Prevent column type list when using read_sheet from R’s googlesheets4

  • by
  • 2 min read

Google Spreadsheets and R: a dynamic duo! An annoying feature in googlesheets4’s read_sheet(), is that within a column, it assigns a type to each cell individually when it is confused. However, this makes perfect sense. Sometimes, a column contains a mix of values that could be integers and values that…