ISSS608 2018-19 T1 Assign Clara Chua Kiah Hwii Data Preparation
Jump to navigation
Jump to search
Sofia: So Smoggy
|
|
|
|
|
|
The following data preparation was done:
Task 1
- Joined all station files from EEA dataset, with metadata file from EEA data. This was done in JMP Pro, using the Table Join functions.
Task 2
- Joined tables from AirTube in R
- Ran geohash package in R to convert geohash data into longitude and latitude
- Subset geohashes within Sofia-grad (Sofia City Province) using the lasso tool in Tableau and extracting the data
- Filtered data for erroneous readings (approximately 131,000 data points excluded)
