Difference between revisions of "AY1516 T2 Team CommuteThere Project Data Preparation"
Jump to navigation
Jump to search
| Line 61: | Line 61: | ||
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em; text-indent: 10px; font-size:17px; font-family: Helvetica; border-left:8px solid #0091b3"><font color= #000000><strong>Anomalies and Data Cleaning</strong></font></div>== | ==<div style="background: #ffffff; padding: 17px; line-height: 0.1em; text-indent: 10px; font-size:17px; font-family: Helvetica; border-left:8px solid #0091b3"><font color= #000000><strong>Anomalies and Data Cleaning</strong></font></div>== | ||
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left"> | <div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Arial, sans-serif; border-radius: 7px; text-align:left"> | ||
| + | == Bus_service _mapping == | ||
| + | |||
| + | == Location_gis_mapping == | ||
| + | |||
| + | |||
| + | == Location_mapping == | ||
| + | |||
| + | |||
| + | == Ride_data_20120109_20120115 == | ||
</div> | </div> | ||
Revision as of 00:24, 17 April 2016
Contents
Main Data Sets
| Name of Data | Nature of Data | Number of Records (after cleaning) |
|---|---|---|
| bus_service_mapping | The actual bus service numbers are provided alongside with the bus service ids together with the date of entry of data into the database. The more recent the data depicts a more updated record. | 335 |
| location_gis_mapping | Coordinates of bus stops in WGS84 coordinate system are provided with the location_id of each bus stops and the date of entry when the data is entered into the database. The more recent the data depicts a more updated record. | 4903 |
| location _mapping | Names of each MRT stations and bus stops are provided together with the location_id. Date of entry of data when entered into the database is provided. The more recent the data depicts a more updated record. | 5070 |
| ride_data_20120109_20120115 | Ez-link transactions of commuters of all types of commuters category from 9 Jan 2012 to 15 Jan 2012. Each transactions displays the tap-in and top-out of ez-link card. | Millions |
