Difference between revisions of "ISSS608 2017-18 T3 Assign Lu Yanzhang Data Preparation Methodology"
Jump to navigation
Jump to search
| Line 46: | Line 46: | ||
==Join operation among diverse tables in JMP== | ==Join operation among diverse tables in JMP== | ||
| + | |||
| + | Join the tables where the source or target is “suspicious” and select out the suspicious transactions for the further visualizations in Tableau and social network analytics in Gephi | ||
Revision as of 14:24, 10 July 2018
VAST Challenge 2018 MC3:
Who hurts the brid?
|
|
|
|
|
Tools
The following tools have been used in this assignment
1. Python - Timestamp transformation and new data source generation.
The following packages are used in this assignment: pandas, numpy, glob, datetime.
2. JMP Pro - Data preparation
3. Tableau - Visualization
4. Gephi - Social network modeling and visualization
Timestamp Transformation in Python
The raw timestamp format is the second record from '2015-05-11 14:00:00'.
For further use of timestamp data, the format needs to be transformed to YYYY/MM//DD rather than raw second format.
Join operation among diverse tables in JMP
Join the tables where the source or target is “suspicious” and select out the suspicious transactions for the further visualizations in Tableau and social network analytics in Gephi
