Difference between revisions of "ISSS608 2017-18 T3 Assign Jyoti Bukkapatil Data Preparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
Line 3: Line 3:
 
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.
 
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.
  
−
</big>
+
 
−
 
 
{| class="wikitable"
 
{| class="wikitable"
 
|-
 
|-
−
! Index !! Data !!! File Name !!!! Number of Records
+
! Index !! Data !! File Name !! Number of Records
 
|-
 
|-
−
| '''''1''''' || Call records for whole company starting from 11 May 2015 14:00:00 hrs |||calls.csv|||| 10606835
+
|1|| Call records for the whole company company starting from 11 May 2015 14:00:00 hrs ||calls.csv || 10606835
−
 
 
|-
 
|-
−
| '''''AllBirdsv4.csv''''' ||  
+
|2|| Email records for the whole company starting from 11 May 2015 14:00:00 hrs ||email.csv||  14550085
−
* Metadata file for the sound files
+
|-
−
* Fields contained are ->
+
|3|| Meetings records for whole company starting from 11 May 2015 14:00:00 hrs ||meeting.csv|| 127351
−
** File ID - An index to the file name in ALL BIRDS sound file collection
+
|-
−
** Vocalization_type: Kind of bird sound. Values are call or song or some other particular sound
+
|4|| Purchases records for whole company starting from 11 May 2015 14:00:00 hrs ||purchaces.csv||  762200
−
** Quality: Measure of the quality of the bird sound. Values are A, B, C, D, E, No Score
+
|-
−
** Time & Date: When the sound was captured
+
|5||Company employee ID and Name list ||CompanyIndex.csv||  642631
−
** X & Y Coordinates: Values ranging from 0 to 199
+
|-
−
 
+
|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
 
|-
 
|-
−
| '''''Lekagul Roadways 2018 Map''''' ||  
+
|8||Suspicious meeting records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs ||Suspicious_purchases.csv|| 5
−
* '''200 X 200-pixel map of the Preserve'''
 
−
* The coordinates from AllBirdsv4 considered from bottom left to top right (0,0) to (199,199)
 
−
 
 
 
|-
 
|-
−
| '''''Test Birds from Kasios''''' ||  
+
|9||Suspicious purchases records of suspecious group in company ,starting from 11 May 2015 14:00:00 hrs ||Suspicious_meetings.csv|| 1
−
* Bird sounds Kasios claims as Pipit
 
−
* Captured over past couple of months
 
−
 
 
 
|-
 
|-
−
| '''''Test Bird Location''''' ||  
+
|10||Suspecious 7 purchases records||Other_suspicious_purchases.csv || 7
−
* X & Y Coordinates: Location of the test bird sound recordings
 
 
|-
 
|-
 
|}
 
|}
−
<br/>
 
−
Table 1
 

Revision as of 18:11, 7 July 2018

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
Retrieved from ‘https://wiki.smu.edu.sg/1718t3isss608/index.php?title=ISSS608_2017-18_T3_Assign_Jyoti_Bukkapatil_Data_Preparation&oldid=4163’