Difference between revisions of "YunnaWei DataPreparation"
Jump to navigation
Jump to search
| (6 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| + | <div style="background:#002060; border:#002060; padding-left:15px; text-align:center;"> | ||
| + | <font size = 5; color="#FFFFFF"><span style="font-family:Century Gothic;">Yunna Wei - ISSS608 Visual Analytics and Applications_Assignment1</span></font> | ||
| + | </div> | ||
| + | <!--MAIN HEADER --> | ||
| + | {|style="background-color:#002060;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
| + | | style="font-family:Century Gothic; font-size:100%; solid #000000; background:#002060; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[ISSS608 2016-17 T3 Assign WEI YUNNA| <font color="#FFFFFF">Introduction</font>]] | ||
| + | |||
| + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#C00000; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[YunnaWei_DataPreparation| <font color="#FFFFFF">Data Preparation</font>]] | ||
| + | |||
| + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#002060; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[YunnaWei_OverviewExploration| <font color="#FFFFFF">Overview Exploration</font>]] | ||
| + | |||
| + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#002060; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[YunnaWei_PatternDetection| <font color="#FFFFFF">Pattern Detectoin</font>]] | ||
| + | |||
| + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#002060; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[YunnaWei_InteractiveVisualization| <font color="#FFFFFF">Interactive_Visualization</font>]] | ||
| + | |||
| + | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#002060; text-align:center;" width="16.6%" | | ||
| + | ; | ||
| + | [[YunnaWei_Comments| <font color="#FFFFFF">Comments</font>]] | ||
| + | |||
| + | | | ||
| + | |} | ||
| + | <!--MAIN HEADER --> | ||
| + | |||
| + | |||
= Data Preparation = | = Data Preparation = | ||
<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 45: | ||
===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 54: | ||
</tr> | </tr> | ||
</table> | </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> | ||
| + | </tr> | ||
| + | </table> | ||
Latest revision as of 11:13, 12 July 2017
Yunna Wei - ISSS608 Visual Analytics and Applications_Assignment1
|
|
|
|
|
|
|
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
|
 |
