Get the latest tech news
Formatted spreadsheets can still work in R
Tackling problematic spreadsheets
This recent post by Jeremy Selva shows a nice workflow for working with problematic formatted spreadsheets in R. lovely These issues vary in how hard they are to address in downstream analyses, but as they accumulate we are more tempted to give up and work with the file directly in Excel (or Calc). Now we can conditionally convert pounds to kilograms, then remove the color annotation from the id variable, which we’ll use to merge this object with the dataframe we were working on initially.
Or read this on Hacker News