YunnaWei DataPreparation

Data Preparation

The given data sets are respectively a map and a csv file.

Mapping the coordinates of each location

For the map, it will be useful to get the coordinates of each location so that we can plot the map with traffic going through to gave a whole picture of how the traffic looks like. Tableau is used to manually label the coordinates of each location. The locations are mapped within a 200x200 scale.

Creating new variables

Travelling Path

The given csv data set has the variables of Car_id, timestamp,car-type, and gate name. To find out more information about the traffic patterns, new variables should be created based on the given variables.