Difference between revisions of "Sofia City: Data Preparation"
Yqchia.2017 (talk | contribs) |
Yqchia.2017 (talk | contribs) |
||
| Line 35: | Line 35: | ||
The EEA folder comes with 28 files across 6 stations from 2013-2018. It is observed that some of the stations do not have complete records (denoted by x in table below) across the years notably Orlov Most and Mladost. We first consolidate the dataset for each station by concatenating the files from 2013-2018.<br/> | The EEA folder comes with 28 files across 6 stations from 2013-2018. It is observed that some of the stations do not have complete records (denoted by x in table below) across the years notably Orlov Most and Mladost. We first consolidate the dataset for each station by concatenating the files from 2013-2018.<br/> | ||
| − | + | [[File:Info.jpg|500px|frameless|left]] | |
[[File:Concat 9421.jpg|500px|frameless]] <br/> | [[File:Concat 9421.jpg|500px|frameless]] <br/> | ||
| Line 42: | Line 42: | ||
[[File:Addincolumns.jpg|500px|frameless|left]] <br/> | [[File:Addincolumns.jpg|500px|frameless|left]] <br/> | ||
[[File:Combine EEA.jpg|500px|frameless|left]] <br/> | [[File:Combine EEA.jpg|500px|frameless|left]] <br/> | ||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
| + | |||
Revision as of 12:15, 18 November 2018
Understanding Air Quality in Sofia
|
|
|
|
|
|
|
Data Preparation
EEA Dataset
The EEA folder comes with 28 files across 6 stations from 2013-2018. It is observed that some of the stations do not have complete records (denoted by x in table below) across the years notably Orlov Most and Mladost. We first consolidate the dataset for each station by concatenating the files from 2013-2018.
The original files do not come with information on geographical location, altitude as well as common names of the station. These information, however, could be found inside the metadata table provided. We were to add these information into the individual air tube files by creating new columns “Longitude”, “Latitude”, “Altitude” and “Name” respectively.
The final working file is created by concatenating dataset from all 6 stations across all years.
