ANLY482 AY2017-18T2 Group08 : Project Overview / Methodology

From Analytics Practicum
Jump to navigation Jump to search

Homepage

Our Team

Project Overview

Project Findings

Project Management

Documentation

ANLY482 AY2017-18 T2 Projects

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