ISSS608 2017-18 T3 Assign Jyoti Bukkapatil Data Preparation

Data for Visualisation

Data provided by Kasios International insider has been 10 different CSV files. These are mainly different call records, email records, Meeting records and Purchase records from 11th May 2015 14:00:00 hours onwards. All files contain Source, destination, connection details and time in seconds. Below are details of different files providing The Kasios Insider.

Index	Data	File Name	Number of Records
1	Call records for the whole company company starting from 11 May 2015 14:00:00 hrs	calls.csv	10606835
2	Email records for the whole company starting from 11 May 2015 14:00:00 hrs	email.csv	14550085
3	Meetings records for whole company starting from 11 May 2015 14:00:00 hrs	meeting.csv	127351
4	Purchases records for whole company starting from 11 May 2015 14:00:00 hrs	purchaces.csv	762200
5	Company employee ID and Name list	CompanyIndex.csv	642631
6	Suspicious call records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs	Suspicious_calls.csv	70
7	Suspicious email records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs	Suspicious_emails.csv	61
8	Suspicious meeting records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs	Suspicious_purchases.csv	5
9	Suspicious purchases records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs	Suspicious_meetings.csv	1
10	Suspecious 7 purchases records	Other_suspicious_purchases.csv	7

All data files contain only four columns:

1. Source ID: Company ID of the person who has initiated connection i.e. either Called someone, sent email, invited someone for meeting or purchases something
2. Etype: Connection details i.e. 0 – Calls, 1 – Emails, 2 – Purchases and 3- Meetings
3. Target ID: Company ID of destination person for connection
4. Time Stamp: Time in Seconds starting from 11th May 2015 at 14:00