ISSS608 2018-19 T1 Assign Chen Jingyi Data preparation

ISSS608 2018-19 T1 Assign Chen Jingyi

Overview

Data Preparation

Task 1

Task 2

Task 3

Data source	Data preperation
Official air quality measurements (5 stations in the city)(EEA Data.zip)	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) |- | 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... |}