ISSS608 2018-19 T1 Assign Chen Jingyi Data preparation
Revision as of 19:48, 15 November 2018 by Jingyi.chen.2017 (talk | contribs)
ISSS608 2018-19 T1 Assign Chen Jingyi
|
|
|
|
|
|
| Data source | Data preperation |
|---|---|
| Official air quality measurements (5 stations in the city)(EEA Data.zip) |
1.。。 2... |
| Citizen science air quality measurements (Air Tube.zip) |
1.。。 2... |
| Meteorological measurements (1 station) (METEO-data.zip) |
1.。。 2... |
| Topography data (TOPO-DATA) |
Nothing special should be done for this data set. 2... |
1. Use vlookup to match data from 5 stations with information in metadata, the following graph shows how to handle each column.
2. use tableau to create fields.
2.1 consider var & hour as the same group(since there is only 1 minute’s difference in the time length), group them together in a new group named “hour & var”.
2.2 Similarly, group time together.
3 create new field called “weekday” to generate day information of the week.
4. Group by air quality station type(background=Druzhba +Hipodruma+Nadezhda, traffic=IASO+Orlov Most)
