For the last 4 screen casts, Ellis Hughes and I have been showing methods of cleaning messy excel data. Now that you have the data cleaned and structured in a data frame, you might need to write that data back out to an external file. Perhaps you need to save it as a csv and upload it to a database or maybe you want to write it out to a cleaner excel file that has the data in an accessible manner for your end users.
This week, we will write our cleaned data out to csv and excel in four formats:
- Write to csv
- Write the flat file out to a single excel sheet
- Write the flat file out to individual athlete tabs within an excel sheet
- Write the flat file out to individual athlete tabs within an excel sheet along with a bunch of custom excel formatting, available via the {openxlsx} package.
To watch the screen cast, CLICK HERE.
To access our code, CLICK HERE.