Difference between revisions of "YunnaWei DataPreparation"
Jump to navigation
Jump to search
| Line 17: | Line 17: | ||
<td> | <td> | ||
[[File:WYN Path.png|center]] | [[File:WYN Path.png|center]] | ||
| + | </td> | ||
| + | </tr> | ||
| + | </table> | ||
| + | ==== Other Variables ==== | ||
| + | <table cellspacing="10" border="1"> | ||
| + | <tr> | ||
| + | <td> | ||
| + | <ul> | ||
| + | <li>Camping or Not: Organizing the activities of visitors into camping or Noncamping.</li> | ||
| + | <li>Travelling Duration: Calculate the travelling duration of each car id and categorize them into travelers whose duration is within one day and travelers whose duration is more than one day.</li> | ||
| + | <li>Visiting month: Calculate the visiting month of each car id.</li> | ||
| + | <li>Visiting quarter: Calculate the visiting quarter of each car id.</li> | ||
| + | <li>Entering hour: Calculate the entering hour of each car id.</li> | ||
| + | <li>Day or Night Trip: Based on the entering hour, categorize the traffic into day or night traffic.</li> | ||
| + | </ul> | ||
| + | </td> | ||
| + | <td> | ||
| + | [[File:WYN Other Variables.png|center]] | ||
</td> | </td> | ||
</tr> | </tr> | ||
</table> | </table> | ||
Revision as of 15:55, 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. |
 |
Other Variables
|
 |
