Difference between revisions of "Project Timeline"
Jump to navigation
Jump to search
Line 19: | Line 19: | ||
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F5F6CE; text-align:center;" width="16.66%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#F5F6CE; text-align:center;" width="16.66%" | | ||
; | ; | ||
− | [[Project Timeline| <font color="#1C1C1C"> | + | [[Project Timeline| <font color="#1C1C1C">Data Preparation</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="16.66%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="16.66%" | |
Revision as of 14:56, 7 August 2017
Discovering traffic patterns by using network graph visualisations
|
|
|
|
|
|
Data Preparation
The flow chart below illustrates how the various R packages used in building our application interplay with one another.
- The raw data is first split into nodes and edges on excel
- Data cleaning is then done on both files using the package, tidyverse. The edges have the column "cartype" recoded and the timestamp formatted by the package, lubridate which allows us to filter out the hour component of the timestamp.
- The edges are also aggregated into another separate variable which will be used for the main visualization to shorten the loading time.
- On the other hand, the nodes have their coordinates added which is made possible by a software called QGIS.
- The previous step is necessary so that the coordinates of each gate can be plotted onto R with the module, ggnetwork.
- Gate categories were then added to classify the 40 nodes.
- The steps above summarise the basic steps taken in data preparation. Using the variables created above, the basic graph can then be plotted as an object with the package, igraph.
- The package, ggraph then serves as a wrapper for our igraph object, enabling various aesthetics options such as layout, facet, colors and tooltips etc.
- An additional data table is created as well with the package, DT to visualise our raw data so that users can access them easily via our application.
- Lastly, the entire network is made interactive via shiny.