Difference between revisions of "ISSS608 2017-18 T3 Assign Vigneshwar Ramachandran Vadivel Approach"
Jump to navigation
Jump to search
(18 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | + | {{Template:MC3 Header}} | |
<!------- Main Navigation Bar----> | <!------- Main Navigation Bar----> | ||
<center> | <center> | ||
Line 23: | Line 23: | ||
{| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"| | {| style="background-color:#ffffff ; margin: 3px 10px 3px 10px;" width="80%"| | ||
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #f5f5f5; background-color: #fff" width="150px" | | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border-top:solid #f5f5f5; background-color: #fff" width="150px" | | ||
− | [[ISSS608_2017-18_T3_Assign_Vigneshwar Ramachandran Vadivel_Approach|<font color="#3c3c3c"><strong> | + | [[ISSS608_2017-18_T3_Assign_Vigneshwar Ramachandran Vadivel_Approach|<font color="#3c3c3c"><strong>About Dataset</strong></font>]] |
| style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="150px" | | | style="font-family:Open Sans, Arial, sans-serif; font-size:15px; text-align: center; border:solid 1px #f5f5f5; background-color: #f5f5f5" width="150px" | | ||
[[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> | ||
<!------- End of Secondary Navigation Bar----> | <!------- End of Secondary Navigation Bar----> | ||
− | =Data Set= | + | =<div style="font-family: Calibri;">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. | + | <div style="font-family: Calibri;">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. | + | All of the provided data files have the same format. |
− | + | [[File:A1_MC3_Data_Table.PNG|350px|centre|frameless|link=ISSS608_2017-18_T3_Assign_Vigneshwar Ramachandran Vadivel | |
+ | ]] | ||
+ | The data are provided in comma-separated format with four columns: | ||
<ul><li>Source (company ID# for the person who initiated the communication)</li> | <ul><li>Source (company ID# for the person who initiated the communication)</li> | ||
<li>Etype (number designating type of connection)</li> | <li>Etype (number designating type of connection)</li> | ||
+ | <ul> | ||
+ | <li>0 is for calls</li> | ||
+ | <li>1 is for emails</li> | ||
+ | <li>2 is for purchases</li> | ||
+ | <li>3 is for meetings</li> | ||
+ | </ul> | ||
<li>Destination (company ID# for the person who receives communication)</li> | <li>Destination (company ID# for the person who receives communication)</li> | ||
<li>Time stamp – Unix epoch format starts at May 11, 2015 at 14:00</li></ul> | <li>Time stamp – Unix epoch format starts at May 11, 2015 at 14:00</li></ul> | ||
− | + | </div><br> | |
− | =Tools Used= | + | =<div style="font-family: Calibri;">Tools Used= |
− | + | <div style="font-family: Calibri;"> | |
− | <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> | ||
Line 55: | Line 58: | ||
<li>Tableau - Preliminary data visualizations </li> | <li>Tableau - Preliminary data visualizations </li> | ||
− | <li>Excel and Python - Initial data exploration and data cleaning </li></ul> | + | <li>Excel and Python - Initial data exploration and data cleaning </li></ul></div> |
Latest revision as of 12:14, 8 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