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
VAST Challenge 2018 MC3:
Catch the Unsub – Who hurts Eurasian Pipit?
|
|
|
|
|
Raw Data Overview
Data Aggregation
1. Add Column Name
- 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.
3. Save New Data Tables
- Saved new data tables with TimeStamp to the path.
