ISSS608 2018-19 T1 Assign Huang Shan Methodology&Dashoboard

From Visual Analytics and Applications
Revision as of 21:53, 27 November 2018 by Shan.huang.2017 (talk | contribs)
Jump to navigation Jump to search

1.png

Overview

Methodology&Dashoboard

Insights

Conclusion

 


Data Preparation

It is time to explore the particular datasets. There are four files in the dataset then I will utilize them for different purposes.The datasets and analysis have been prepared using Tableau, JMP, R and Excel.

Official Air Quality Measurements

EEA Data made up of 29 excel files and 1 text file. Of 28 excel files with PM10 concentrations values from 2013 to 2018 at the 6 different official air quality stations.I found that not every file is complete from 2013 to 2018. Below the table display the data structure:

2.png


Firstly, I used JMP Pro 13 to combine the data of each AirPollutionStation from 2013 to 2018.This column identifies the name of the source data table in the corresponding rows.Then I continue to use the same method to merge the six data in the previous step into a complete one with JMP. Finally, The combine data file is joined with metadata file by AirQualityEOLStationCode as the link.


3.png 4.png

Citizen Science Air Quality Measurements