Project Timeline

From Visual Analytics and Applications
Jump to navigation Jump to search

Discovering traffic patterns by using network graph visualisations

Introduction

About

Project Proposal

Data Preparation

App & Deliverables

Poster

 

Data Preparation

A complete step by step guide of how to prepare the nodes and edges table used for this visualisation is available through this markdown document accessed from here.

The flow chart below illustrates how the various R packages used in building our application interplay with one another.

Flow Chart G1.jpg


  1. The raw data is first split into nodes and edges on excel
  2. 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.
  3. The edges are also aggregated into another separate variable which will be used for the main visualization to shorten the loading time.
  4. On the other hand, the nodes have their coordinates added which is made possible by a software called QGIS.
  5. The previous step is necessary so that the coordinates of each gate can be plotted onto R with the module, ggnetwork.
  6. Gate categories were then added to classify the 40 nodes.
  7. 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.
  8. The package, ggraph then serves as a wrapper for our igraph object, enabling various aesthetics options such as layout, facet, colors and tooltips etc.
  9. 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.
  10. Lastly, the entire network is made interactive via shiny.