Difference between revisions of "ANLY482 AY2017-18T2 Group08 : Project Overview / Data"
(One intermediate revision by the same user not shown) | |||
Line 13: | Line 13: | ||
[[ANLY482 AY2017-18T2 Group08 : Documentation | <font color="#000000" size=2><b>Documentation</b></font>]] | [[ANLY482 AY2017-18T2 Group08 : Documentation | <font color="#000000" size=2><b>Documentation</b></font>]] | ||
| style="background-color:#FCB706; text-align:center;" width="15%" | | | style="background-color:#FCB706; text-align:center;" width="15%" | | ||
− | [[ANLY482 AY2017-18 Term 2 | + | [[ANLY482 AY2017-18 Term 2 | <font color="#262626" size=2><b>Other AY2017-18 T2 Projects</b></font>]] |
|} | |} | ||
Line 26: | Line 26: | ||
==<div style="background: #404040; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 0px; font-size: 16px"><font color=#ffffff >5.0 Data</font></div>== | ==<div style="background: #404040; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: 0px; font-size: 16px"><font color=#ffffff >5.0 Data</font></div>== | ||
'''<big><font color="#fcb706">5.1 Data Sample</font></big><br> | '''<big><font color="#fcb706">5.1 Data Sample</font></big><br> | ||
− | + | ABC bike-sharing company provided us with a sample data in the form of a csv file. The file contains information on illegal parking. Put simply, when authorities make a complaint to ABC bike-sharing company, 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. | Refer to Figure 1 below for a screenshot of the first ten records in the sample. | ||
Line 33: | Line 33: | ||
'''<big><font color="#fcb706">5.2 Metadata</font></big><br> | '''<big><font color="#fcb706">5.2 Metadata</font></big><br> | ||
− | 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 | + | 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 ABC bike-sharing company, 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: <br> | Note: <br> | ||
Line 78: | Line 78: | ||
|Numeric | |Numeric | ||
|4 | |4 | ||
− | |Time that | + | |Time that ABC bike-sharing company has responded to the illegal parking claims. Also represented in 24-hour military time |
|- | |- | ||
|'''Due Time''' | |'''Due Time''' | ||
Line 88: | Line 88: | ||
|Character | |Character | ||
|2 | |2 | ||
− | |The amount of time | + | |The amount of time ABC bike-sharing company took to respond to the illegal parking claims.<br> ‘<4’ implies less than 4 hours while ‘4>’ implies more than 4 hours. |
|- | |- | ||
|'''# of Bikes''' | |'''# of Bikes''' |
Latest revision as of 01:57, 16 April 2018
Description | Data | Methodology |
5.0 Data
5.1 Data Sample
ABC bike-sharing company provided us with a sample data in the form of a csv file. The file contains information on illegal parking. Put simply, when authorities make a complaint to ABC bike-sharing company, 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.
5.2 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 ABC bike-sharing company, 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 ABC bike-sharing company 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 ABC bike-sharing company 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 |