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 > | + | <table cellspacing="10" border="1"> |
<tr> | <tr> | ||
<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>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> | ||
| Line 11: | Line 11: | ||
===Creating new variables === | ===Creating new variables === | ||
| − | <table> | + | ==== Travelling Path ==== |
| + | <table cellspacing="10" border="1"> | ||
<tr> | <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>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> | ||
| Line 19: | Line 20: | ||
</tr> | </tr> | ||
</table> | </table> | ||
| − | |||
| − | |||
| − | |||
Revision as of 15:28, 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
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. |
 |
