Difference between revisions of "YunnaWei DataPreparation"
Jump to navigation
Jump to search
| Line 3: | Line 3: | ||
<p align="justify"> The given data sets are respectively a map and a csv file.</p> | <p align="justify"> The given data sets are respectively a map and a csv file.</p> | ||
=== Mapping the coordinates of each location === | === Mapping the coordinates of each location === | ||
| − | < | + | <table > |
| − | < | + | <tr> |
| − | [[File:WYN Corrdinates.png| | + | <td>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.</td> |
| − | </ | + | <td>[[File:WYN Corrdinates.png|700 px|left]]</td> |
| + | </tr> | ||
| + | </table> | ||
| − | |||
===Creating new variables === | ===Creating new variables === | ||
| − | < | + | <table> |
| − | + | <tr> | |
| + | <td>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.</td> | ||
| + | <td> | ||
| + | [[File:WYN Path.png|center]] | ||
| + | </td> | ||
| + | </tr> | ||
| + | </table> | ||
| + | |||
</div> | </div> | ||
==== Travelling Path ==== | ==== Travelling Path ==== | ||
Revision as of 15:24, 9 July 2017
Contents
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
| 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. |
 |
