Difference between revisions of "ISSS608 2016 17T1 Group1 Proposal"
(2 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
| style="border-bottom:4px solid #000066; border-top:4px solid #000066; background:none;" width="1%" | | | style="border-bottom:4px solid #000066; border-top:4px solid #000066; background:none;" width="1%" | | ||
| style="padding:0.4em; font-size:100%; background-color:#000066; border-bottom:4px solid #000066; border-top:4px solid #000066; text-align:center; color:#000066" width="10%" |[[ISSS608_2016_17T1_Group1_Poster|<font color="#ffffff" size=2><b>POSTER</b></font>]] | | style="padding:0.4em; font-size:100%; background-color:#000066; border-bottom:4px solid #000066; border-top:4px solid #000066; text-align:center; color:#000066" width="10%" |[[ISSS608_2016_17T1_Group1_Poster|<font color="#ffffff" size=2><b>POSTER</b></font>]] | ||
− | |||
− | |||
− | |||
| style="border-bottom:4px solid #000066; border-top:4px solid #000066; background:none;" width="1%" | | | style="border-bottom:4px solid #000066; border-top:4px solid #000066; background:none;" width="1%" | | ||
| style="padding:0.4em; font-size:90%; background-color:#000066; border-bottom:4px solid #000066; border-top:4px solid #000066; text-align:center; color:#000066" width="10%" |[[ISSS608_2016_17T1_Group1_Report|<font color="#ffffff" size=2><b>REPORT</b></font>]] | | style="padding:0.4em; font-size:90%; background-color:#000066; border-bottom:4px solid #000066; border-top:4px solid #000066; text-align:center; color:#000066" width="10%" |[[ISSS608_2016_17T1_Group1_Report|<font color="#ffffff" size=2><b>REPORT</b></font>]] | ||
|} | |} | ||
− | + | ||
− | + | ||
− | + | ||
− | = | + | =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. | 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. |
+ | |||
+ | |||
+ | =Data Sources= |
Latest revision as of 22:26, 28 November 2016
PROPOSAL | POSTER | REPORT |
Contents
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.