ISSS608 2016 17T1 Group1 Proposal

PROPOSAL

POSTER

APPLICATION

REPORT

Background

Singapore is a highly urbanised city state with a good network of public transport. It is important to understand how the population flows within the city state through the public transport system. The public transport planners will need to understand the characteristics of the population commuting on the public transport system, especially the public bus system. The public bus system has a greater reach to majority of the population and is more dynamic in nature as compared to the train system. By understanding the characteristics of the commuters, it will allow the planners to twist the public bus system in order to make it more efficiency and support the initiative of a car-lite society.

Challenges

An Ezlink passenger travel record over 7 days has 50 millions + rows of data and 50+ variables. The raw data was too large for visualisation tools such as Tableau and D3.JS to read and process. Even loading the data into JMP proved to be a challenge and on average it took at least 30 mins to read in the csv data and convert into JMP format. Hence the ability to visualise the raw data was very limited.

Project Objectives

The objective of the project was to prepare and manipulate the raw data into manageable data size for analysis on visualisation tools such as Tableau and D3.JS.

Motivation

With this project we hope to help the public transport planners to study the commuter's movement on the public bus system.

Visualisation Modelling

We are exploring using either D3.JS or R Shiny to create visualisation model such as the Chord Diagram or sparklines to analysis the flow pattern.