ISSS608 2018-19 T1 Assign Cao Xinjie DataPrep

From Visual Analytics and Applications
Jump to navigation Jump to search

WechatIMG8.png Sofia Air Pollution - Be a Visual Detective

Overview

Data Preparation

Visualizations

Dashboard


TASK1 DATA PREPARATION

The data for tsak1 is EEA Data. There totally 28 timeseries data and a metadata. After using JMP to concatenate all the time series data, we use "AirQuantityStation" to be the matching value join the timeseries data and the matadata. .

Pre.png

.

DATASET DESCRIPTION

This dataset is provided by Beijing Municipal Environmental Monitoring Center. We only select the data in 2017 to do the further analysis in our project, which contains 87,361 records for the Beijing air quality each hour, which starts from 2017-01-01 to 2017-11-01. The dataset includes the columns: City, Date, Hour, View point, AQI, Air Quality Descriptor, 1-hr PM2.5, 24-hr PM2.5, 1-hr PM10, 24-hr PM10, 1-hr SO2, 24-hr SO2, 1-hr NO2, 24-hr NO2, 1-hr CO, 24-hr CO, 1-hr O3, 8-hr O3 and Primary pollutant.

The following header shows part of the dataset:

TOOLS

ggplot2

tidyverse

zoo

shiny