Jeremy Selva shares a useful workflow for handling problematic spreadsheets in R. Despite initial issues, fixes in unheadr v0.4.0 address various spreadsheet problems like date formatting and using text colors for units. By using functions like type_convert() and lubridate, the data can be properly parsed and transformed. Annotating cell color codes with unheadr’s annotate_mf functions reveals hidden formatting issues. After some data manipulation, a clean and usable dataset is obtained. Following good data organization practices in spreadsheets is essential to avoid such problems. Kudos to Jeremy for the inspiration and guidance. Check out Jenny Bryan’s Spreadsheet Resources for more insights.
https://luisdva.github.io/rstats/problematic-spreadsheets/