Home ยป r

r

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… 

Excel’s LEFT, RIGHT and MID in R

  • by
  • 2 min read

LEFT() and RIGHT() are probably the most used string functions within Microsoft Excel (or other spreadsheet software). Many people who make the transition to R wonder where to find these functions. Short story: they’re not available out-of-the-box. However, why not create them yourself or find a library that suits your…