Difference between revisions of "ISSS608 2016-17 T3 Assign ZHOU YUHUI Data Preparation"
Jump to navigation
Jump to search
Line 35: | Line 35: | ||
1.Car ID is a one-time ID only | 1.Car ID is a one-time ID only | ||
The Car ID in this dataset is not an identifier for each car, but for each trip of one car. In other words, if the same car enters and exits the park twice, it should have 2 Car IDs. This is because I found that the last 6 digit of the Car ID are exactly same as the time of timestamp. | The Car ID in this dataset is not an identifier for each car, but for each trip of one car. In other words, if the same car enters and exits the park twice, it should have 2 Car IDs. This is because I found that the last 6 digit of the Car ID are exactly same as the time of timestamp. | ||
− | <p>[[File:Observecarid. | + | <p>[[File:Observecarid.PNG|600px|center]]</p> |
Revision as of 23:22, 16 July 2017
|
|
|
|
Data Preparation
0.Observe The Data Before starting any data preparation or data analysis, I find it necessary to closely observe the dataset itself first. Here are some points I would like to discuss after observing the data:
1.Car ID is a one-time ID only The Car ID in this dataset is not an identifier for each car, but for each trip of one car. In other words, if the same car enters and exits the park twice, it should have 2 Car IDs. This is because I found that the last 6 digit of the Car ID are exactly same as the time of timestamp.