Difference between revisions of "ANLY482 AY2017-18T2 Group08 : Project Overview / Data"
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{|style="padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top"| | {|style="padding: 5px 0 0 0;" width="100%" cellspacing="0" cellpadding="0" valign="top"| | ||
− | | style="background-color:# | + | | style="background-color:#FCB706; text-align:center;" width="14%" | |
− | [[ANLY482 AY2017-18T2 Group08 | + | [[ANLY482 AY2017-18T2 Group08 | <font color="#000000" size=2><b>Homepage</b></font>]] |
− | | style="background-color:# | + | | style="background-color:#FCB706; text-align:center;" width="14%" | |
− | [[ANLY482 AY2017-18T2 Group08 : Our Team | <font color="# | + | [[ANLY482 AY2017-18T2 Group08 : Our Team | <font color="#000000" size=2><b>Our Team</b></font>]] |
| style="background-color:#FDD46A; text-align:center;" width="14%" | | | style="background-color:#FDD46A; text-align:center;" width="14%" | | ||
− | [[ANLY482 AY2017-18T2 Group08 : Project Overview | <font color="# | + | [[ANLY482 AY2017-18T2 Group08 : Project Overview | <font color="#000000" size=2><b>Project Overview</b></font>]] |
− | | style="background-color:# | + | | style="background-color:#FCB706; text-align:center;" width="14%" | |
− | [[ANLY482 AY2017-18T2 Group08 : Project Findings | <font color="# | + | [[ANLY482 AY2017-18T2 Group08 : Project Findings | <font color="#000000" size=2><b>Project Findings</b></font>]] |
− | | style="background-color:# | + | | style="background-color:#FCB706; text-align:center;" width="14%" | |
− | [[ANLY482 AY2017-18T2 Group08 : Project Management | <font color="# | + | [[ANLY482 AY2017-18T2 Group08 : Project Management | <font color="#000000" size=2><b>Project Management</b></font>]] |
− | | style="background-color:# | + | | style="background-color:#FCB706; text-align:center;" width="14%" | |
− | [[ANLY482 AY2017-18T2 Group08 : Documentation | <font color="# | + | [[ANLY482 AY2017-18T2 Group08 : Documentation | <font color="#000000" size=2><b>Documentation</b></font>]] |
− | | style="background-color:# | + | | 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>]] |
|} | |} | ||
{| width="100%" cellspacing="0" cellpadding="0" valign="top" | | {| width="100%" cellspacing="0" cellpadding="0" valign="top" | | ||
− | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: none; width:33.3%" | [[ANLY482 AY2017-18T2 Group08 : Project Overview | <font color="# | + | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: none; width:33.3%" | [[ANLY482 AY2017-18T2 Group08 : Project Overview | <font color="#FCB706 ">Description</font>]] |
− | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: #404040; width:33.3%" | [[ANLY482 AY2017-18T2 Group08 : Project Overview / Data | <font color="#ffffff"> | + | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: #404040; width:33.3%" | [[ANLY482 AY2017-18T2 Group08 : Project Overview / Data | <font color="#ffffff">Data</font>]] |
− | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: | + | | style="padding: 0.25em; font-size: 90%; border-top: 1px solid #cccccc; border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; border-bottom: 1px solid #cccccc; text-align:center; background-color: none; width:33.3%" | [[ANLY482 AY2017-18T2 Group08 : Project Overview / Methodology | <font color="#FCB706">Methodology</font>]] |
|} | |} | ||
− | |||
− | |||
− | ==<div style="background: #404040; padding: 15px; font-weight: bold; line-height: 0.3em; text-indent: | + | ==<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>== |
− | 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 | + | '''<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. | ||
+ | <br>[[Image:ANLY482_AY2017-18_T2_Group_2_Data_Sample.png|center]] | ||
+ | |||
+ | |||
+ | '''<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 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> | ||
(i) Data Type’ has been standardised based on SAS definitions<br> | (i) Data Type’ has been standardised based on SAS definitions<br> | ||
− | (ii) ‘Length’ represents the maximum length of each data type | + | (ii) ‘Length’ represents the maximum length of each data type<br> |
− | |||
{| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | {| class="wikitable" style="text-align: center; background: white; margin: 0px auto; width:80%" | ||
Line 73: | 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 83: | 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 |