Difference between revisions of "ISSS608 2017-18 T3 Assign Vigneshwar Ramachandran Vadivel Approach"
Jump to navigation
Jump to search
| Line 57: | Line 57: | ||
=<div style="font-family: Courier;">Tools Used= | =<div style="font-family: Courier;">Tools Used= | ||
<div style="font-family: Courier;"> | <div style="font-family: Courier;"> | ||
| − | <ul><li>Tableau Prep- Data cleaning and generation of nodes and edges </li> | + | <ul><li>Tableau Prep - Data cleaning and generation of nodes and edges </li> |
<li>Gephi - Network analysis, using communication data</li> | <li>Gephi - Network analysis, using communication data</li> | ||
Revision as of 15:38, 26 June 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
