Difference between revisions of "ISSS608 2017-18 T3 Assign LUO Haoran Data Preparation"
Jump to navigation
Jump to search
Line 33: | Line 33: | ||
[[File:1. add column name.jpg|750px]] | [[File:1. add column name.jpg|750px]] | ||
*Applied the same command to 9 event data tables to add column names. | *Applied the same command to 9 event data tables to add column names. | ||
− | *Corresponding Column Name: Source, Etype, | + | *Corresponding Column Name: Source, Etype, Destination, TimeStamp |
<br> | <br> | ||
Revision as of 22:26, 7 July 2018
|
|
|
|
Raw Data Overview
Data Aggregation
- Applied the same command to 9 event data tables to add column names.
- Corresponding Column Name: Source, Etype, Destination, TimeStamp
2. Convert TimeInterval to TimeStamp
- Changed TimeInterval in original data tables into TimeStamp in format of dd/mm/yyyy hh:mm:ss.
- Initial time is 11/05/2015 14:00:00.
- Saved new data tables with TimeStamp to the path.