ISSS608 2017-18 T3 Assign Lu Yanzhang Data Preparation Methodology
Revision as of 14:19, 10 July 2018 by Yanzhang.lu.2017 (talk | contribs)
|
|
|
|
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
1. To process the audio files, following R packages are loaded in this assignment: soundgen, tuneR, seewave