ISSS608 2017-18 T3 Assign LUO Haoran Data Preparation

VAST Challenge 2018 MC3:
Catch the Unsub – Who hurts Eurasian Pipit?

Overview

Data Preparation

Methodology

Insights

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.