Difference between revisions of "ISSS608 2017-18 T3 Assign LUO Haoran Data Preparation"
Jump to navigation
Jump to search
Line 30: | Line 30: | ||
==<div style="background: #ffffff; padding: 17px; line-height: 0.1em; text-indent: 10px; font-size:17px; font-family: Helvetica; border-left:8px solid #0091b3"><font color= #000000><strong>Data Aggregation</strong></font></div>== | ==<div style="background: #ffffff; padding: 17px; line-height: 0.1em; text-indent: 10px; font-size:17px; font-family: Helvetica; border-left:8px solid #0091b3"><font color= #000000><strong>Data Aggregation</strong></font></div>== | ||
<div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left"> | <div style="margin:0px; padding: 10px; background: #f2f4f4; font-family: Open Sans, Arial, sans-serif; border-radius: 7px; text-align:left"> | ||
− | < | + | <b>1. Add Column Name</b><br> |
− | + | [[File:1. add column name.jpg|750px]] | |
− | + | *Applied the same command to 9 event data tables to add column names. | |
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | * | ||
*Corresponding Column Name: Source, Etype, Target, TimeStamp | *Corresponding Column Name: Source, Etype, Target, TimeStamp | ||
+ | <br> | ||
− | + | <b>2. Convert TimeInterval to TimeStamp</b><br> | |
− | + | [[File:2. convert to time date.jpg|750px]] | |
− | + | *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. | *Initial time is 11/05/2015 14:00:00. | ||
+ | <br> | ||
− | + | <b>3. Save New Data Tables</b><br> | |
− | + | [[File:3. save new data table.jpg|750px]] | |
− | + | *Saved new data tables with TimeStamp to the path. | |
− | * | + | <br> |
− | |||
− | < | ||
</div> | </div> |
Revision as of 22:24, 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, Target, 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.