Data Representation in R

What should our data look like before it’s loaded into R?

Spreadsheets—Microsoft Excel, Google Sheets, and more—are useful for entering data but not necessarily for analyzing data. Their flexible nature enables the user to enter all sorts of different pages with various notes and gives the user a way to store that data. We can do things like color-code individual cells or columns. At the same time, people are often terrible at organizing their data to make it ready for analysis. They may view their spreadsheets as a simple place to dump information. We need our Excel file to be cleaner than that. It’s not a scrapbook. For example, look at the figure below: