ANLY482 AY2017-18T2 Group08 : Project Overview / Methodology
| Description | Methodology |
Data
Data Sample
oBike provided us with a sample data in the form of a csv file titled ‘2018 01 02 oBike LTA ticket cases.csv’. This file contains information on illegal parking. Put simply, when authorities make a complaint to oBike, the relevant details are recorded in a spreadsheet document. As of now, the dataset includes illegal parking cases from mid-November 2017 to early January 2018. Our team is currently in the midst of requesting for the entire data set in order to perform more in-depth exploratory data analysis. Refer to Figure 1 below for a screenshot of the first ten records in the sample.
Metadata
Please refer to Table 2 below for a more detailed description of the data provided. Data provided by the client as of now includes illegal parking cases from mid-November 2017 to early January 2018. According to oBike, on average, it incurs approximately 300 tickets per weekday. Data is only available from 0700 hours to 1900 hours on weekdays. Additional data including historical travel routes of the bicycles will also be given at a later date.
Note:
(i) Data Type’ has been standardised based on SAS definitions
(ii) ‘Length’ represents the maximum length of each data type
| Name | Data Type | Length | Description |
|---|---|---|---|
| Month | Date | 3 | Month that illegal parking took place. Sample data set contains the months ‘Nov’, ‘Dec’, ‘Jan’ |
| Date | Date | 9 | Date that illegal parking occurred. Format is DD-MMM-YY e.g. ‘10-Nov-17’ |
| Authority | Character | 6 | The regulatory authority that picked up on the illegal parking and issued the fines. Authorities include ‘NPARKS’, ‘LTA’ (Land & Transport Authority), ‘TC’ (Town Council) and ‘OTHERS’. |
| Code | Character | 10 | Represents a case number and is a unique identifier |
| Location | Character | 250 | Description of where the illegal parking has occurred |
| Reported Time | Numeric | 4 | Time that the illegal parking was reported. Represented in 24-hour military time |
| Completed | Numeric | 4 | Time that oBike has responded to the illegal parking claims. Also represented in 24-hour military time |
| Due Time | Numeric | 4 | Time that the illegally-parked bicycles have to be cleared out before the fines become due. It is usually 4 hours from the reported time. Also represented in 24-hour military time |
| Duration | Character | 2 | The amount of time oBike took to respond to the illegal parking claims. ‘<4’ implies less than 4 hours while ‘4>’ implies more than 4 hours. |
| # of Bikes | Numeric | 2 | Number of bicycles included in each ticket issued. |
| Arrange To | Character | 6 | Person/Organisation in-charge of responding to the illegal parking claims |
| Status | Character | 9 | Status of the response to illegal parking. Either ‘Ignore’, ‘Arranging’ or ‘Completed’. |
| Remarks | Character | 108 | Additional comments regarding each case |
Tools Used
In_progress
Methodology
Discovery
In_progress
