Difference between revisions of "ISSS608 2017-18 T3 Assign Vigneshwar Ramachandran Vadivel Approach"
Jump to navigation
Jump to search
| Line 28: | Line 28: | ||
[[IISSS608_2017-18_T3_Assign_Vigneshwar Ramachandran Vadivel-_Data_Cleaning|<font color="#3c3c3c"><strong>Data Cleaning</strong></font>]] | [[IISSS608_2017-18_T3_Assign_Vigneshwar Ramachandran Vadivel-_Data_Cleaning|<font color="#3c3c3c"><strong>Data Cleaning</strong></font>]] | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
|} | |} | ||
</center> | </center> | ||
Revision as of 12:03, 3 July 2018
Data Set
The Kasios Insider has provided communication data across the company, includes call records, emails, purchases, and meetings. The data is limited to only the source, the recipient and the time of the transaction and don’t includes the content of the communication.
All of the provided data files have the same format.
The data are provided in comma-separated format with four columns:
- Source (company ID# for the person who initiated the communication)
- Etype (number designating type of connection)
- 0 is for calls
- 1 is for emails
- 2 is for purchases
- 3 is for meetings
- Destination (company ID# for the person who receives communication)
- Time stamp – Unix epoch format starts at May 11, 2015 at 14:00
Tools Used
- Tableau Prep - Data cleaning and generation of nodes and edges
- Gephi - Network analysis, using communication data
- Tableau - Preliminary data visualizations
- Excel and Python - Initial data exploration and data cleaning
