Difference between revisions of "ISSS608 2017-18 T3 Assign Hasanli Orkhan Methodology"
Jump to navigation
Jump to search
Orkhanh.2017 (talk | contribs) |
Orkhanh.2017 (talk | contribs) |
||
Line 30: | Line 30: | ||
[[Image:DataPrep2.png|200px]] | [[Image:DataPrep2.png|200px]] | ||
[[Image:DataPrep3.png|200px]] | [[Image:DataPrep3.png|200px]] | ||
+ | <br><br> | ||
+ | Same formulas were applied for creating similar columns for other datasets. Consequently, we check for duplicates in the data, duplicates from Calls, Purchases data set were removed. |
Revision as of 19:46, 7 July 2018
|
|
|
|
Data Preparation
In all the data sets provided in this mini case, we need to create a new column for timestamp. I have used SAS JMP to create a new column by starting from May 11, 2015 14:00. By taking the seconds value of 5/11/2015 and 14:00, we can add up by given seconds value with created new columns values to get the actual date and time.
Same formulas were applied for creating similar columns for other datasets. Consequently, we check for duplicates in the data, duplicates from Calls, Purchases data set were removed.