Looking over the data variables available in your notes, you should be able to get a sense of what information is available in each data entry and what information might be useful to you. Once you have observed the contents of a dataset, modification of the data is naturally what comes next. Here are some examples of changes that you might make:
- Extracting particular data variables
- Merging data sources
- Converting between formats
- Restructuring the data
- Removing outliers
- Correcting errors
In this exercise, I'm just going to extract some data variables from the original dataset, specifically the following:
- address
- created_at
- description
- lng
- lat
- rating