In [3]:
import pandas as pd
In [7]:
fh = open('data.csv')
data = fh.readlines()
header = data[1].split(',')
header.append('extra')
print(header)
['Date', 'Attendee Name', 'Attendee EmailId', 'Ticket Name', 'Ticket Category', 'Order Number', 'Ticket Number', 'Buyer Name', 'Buyer EmailId', 'Mobile No', 'BIB No/Seat No', '"First PyCon India"', '"Designation"', '"Experience"', '"Gender"', '"T-shirt size"', '"City"', '"Company/Organisation"', '"Country"', '"Would you like to avail Child care facility?"', 'Reference No', 'Comment\r\n', 'extra']
In [8]:
df = pd.read_csv('data.csv', names=header, engine='python')
In [10]:
df.head()
Out[10]:
Date
Attendee Name
Attendee EmailId
Ticket Name
Ticket Category
Order Number
Ticket Number
Buyer Name
Buyer EmailId
Mobile No
...
"Experience"
"Gender"
"T-shirt size"
"City"
"Company/Organisation"
"Country"
"Would you like to avail Child care facility?"
Reference No
Comment
extra
0
Attendee List Data for Late Python
None
None
None
None
None
None
None
None
None
...
None
None
None
None
None
None
None
None
None
None
1
Date
Attendee Name
Attendee EmailId
Ticket Name
Ticket Category
Order Number
Ticket Number
Buyer Name
Buyer EmailId
Mobile No
...
Experience
Gender
T-shirt size
City
Company/Organisation
Country
Would you like to avail Child care facility?
Reference No
Comment
None
2
2015-08-16
madhu
madhukumarpavuluari@gmail.com
Late Python
NaN
E5DJDDAXXXX55D0C0A2CBBED
2064
madhu
madhukumarpavuluari@gmail.com
+91 7406093239
...
NaN
NaN
3
2015-08-16
Yogesh Joshi
iyogeshjoshi@gmail.com
Late Python
NaN
E5DJDDAXXXX55D0D1ECD419A
2065
Yogesh Joshi
iyogeshjoshi@gmail.com
+91 8793651965
...
NaN
NaN
4
2015-08-17
Shoan Motwani
shoanm@gmail.com
Late Python
NaN
E5DJDDAXXXX55D12F2095DE9
2069
Shoan Motwani
shoanm@gmail.com
+91 9880265857
...
NaN
NaN
5 rows × 23 columns
In [11]:
df.tail()
Out[11]:
Date
Attendee Name
Attendee EmailId
Ticket Name
Ticket Category
Order Number
Ticket Number
Buyer Name
Buyer EmailId
Mobile No
...
"Experience"
"Gender"
"T-shirt size"
"City"
"Company/Organisation"
"Country"
"Would you like to avail Child care facility?"
Reference No
Comment
extra
1570
2015-05-07
Arthy Loganathan
aloganat@redhat.com
Early Python
NaN
E5DJDDAXXXX554B5DB140291
540441293
Arthy Loganathan
aloganat@redhat.com
9739996925
...
3-6
Female
Small -S
Bangalore
Redhat
India
No
NaN
NaN
1571
2015-05-07
Mukesh Thawani
mukesh9039@gmail.com
Early Python
NaN
E5DJDDAXXXX554B5E3AA1D35
540441294
Mukesh Thawani
mukesh9039@gmail.com
8602102044
...
0-1
Male
Large - L
Bangalore
Innoventes technologies
India
No
NaN
NaN
1572
2015-05-07
Dipanjan Sarkar
dipanzan.sarkar@gmail.com
Early Python
NaN
E5DJDDAXXXX554B6A7D09D15
540441301
Dipanjan Sarkar
dipanzan.sarkar@gmail.com
9980960048
...
1-3
Male
XL
Bangalore
Intel
India
No
NaN
NaN
1573
2015-05-07
Kaniska Padhi
email@kaniska.in
Early Python
NaN
E5DJDDAXXXX554B6ADE31B85
540441302
Kaniska Padhi
email@kaniska.in
8237136225
...
3-6
Male
Meduim - M
Pune
CDAC
India
No
NaN
NaN
1574
2015-05-07
Sathyam Vellal
sathyam.vellal@gmail.com
Early Python
NaN
E5DJDDAXXXX554B6D7F5A0E1
540441305
Sathyam Vellal
sathyam.vellal@gmail.com
8123436453
...
1-3
Male
Meduim - M
Bangalore
PayPal
India
No
NaN
NaN
5 rows × 23 columns
In [12]:
df.count()
Out[12]:
Date 1575
Attendee Name 1561
Attendee EmailId 1561
Ticket Name 1561
Ticket Category 14
Order Number 1561
Ticket Number 1561
Buyer Name 1561
Buyer EmailId 1561
Mobile No 1457
BIB No/Seat No 14
"First PyCon India" 1543
"Designation" 1561
"Experience" 1561
"Gender" 1561
"T-shirt size" 1561
"City" 1559
"Company/Organisation" 1528
"Country" 1283
"Would you like to avail Child care facility?" 1014
Reference No 265
Comment\r\n 287
extra 1034
dtype: int64
In [13]:
df[df['Date'].str.contains(r'-')]
Out[13]:
Date
Attendee Name
Attendee EmailId
Ticket Name
Ticket Category
Order Number
Ticket Number
Buyer Name
Buyer EmailId
Mobile No
...
"Experience"
"Gender"
"T-shirt size"
"City"
"Company/Organisation"
"Country"
"Would you like to avail Child care facility?"
Reference No
Comment
extra
2
2015-08-16
madhu
madhukumarpavuluari@gmail.com
Late Python
NaN
E5DJDDAXXXX55D0C0A2CBBED
2064
madhu
madhukumarpavuluari@gmail.com
+91 7406093239
...
NaN
NaN
3
2015-08-16
Yogesh Joshi
iyogeshjoshi@gmail.com
Late Python
NaN
E5DJDDAXXXX55D0D1ECD419A
2065
Yogesh Joshi
iyogeshjoshi@gmail.com
+91 8793651965
...
NaN
NaN
4
2015-08-17
Shoan Motwani
shoanm@gmail.com
Late Python
NaN
E5DJDDAXXXX55D12F2095DE9
2069
Shoan Motwani
shoanm@gmail.com
+91 9880265857
...
NaN
NaN
5
2015-08-17
Bhumil Haria
bhumilharia@gmail.com
Late Python
NaN
E5DJDDAXXXX55D193763B0BB
2076
Bhumil
bhumilharia@gmail.com
+91 9969392388
...
NaN
NaN
6
2015-08-17
Dhruv Patel
pateldhruv05@gmail.com
Late Python
NaN
E5DJDDAXXXX55D193763B0BB
2077
Bhumil
bhumilharia@gmail.com
+91 9969392388
...
NaN
NaN
7
2015-08-17
Arpit Jain
jainarpit014@yahoo.in
Late Python
NaN
E5DJDDAXXXX55D193763B0BB
2078
Bhumil
bhumilharia@gmail.com
+91 9969392388
...
NaN
NaN
8
2015-08-17
Bhuvaneshwari N
bhuvana.09cse@gmail.com
Late Python
NaN
E5DJDDAXXXX55D1D9B38078C
2082
Bhuvaneshwari N
bhuvana.09cse@gmail.com
+91 8951003449
...
NaN
NaN
9
2015-08-18
Vaidyanath Manogaran
vaidyanath.m@gmail.com
Late Python
NaN
E5DJDDAXXXX55D2BC1B8D72E
2091
Vaidyanath Manogaran
vaidyanath.m@gmail.com
+91 9483465528
...
NaN
NaN
10
2015-08-18
Sneha Bhattacharya
sneha.22.7@gmail.com
Late Python
NaN
E5DJDDAXXXX55D32AB247FD9
2099
Sneha Bhattacharya
sneha.22.7@gmail.com
+91 9547149120
...
NaN
NaN
11
2015-08-18
Sai Suman Prayaga
suman.sai14@gmail.com
Late Python
NaN
E5DJDDAXXXX55D32AB247FD9
2100
Sneha Bhattacharya
sneha.22.7@gmail.com
+91 9547149120
...
NaN
NaN
12
2015-08-18
Abraham Varricatt
abraham.varricatt@googlemail.com
Late Python
NaN
E5DJDDAXXXX55D3384CA0C02
2101
Abraham Varricatt
abraham.varricatt@googlemail.com
+91 9844495316
...
NaN
NaN
13
2015-08-19
MOHAMMED GAFFAR G
mgaffarg@gmail.com
Late Python
NaN
E5DJDDAXXXX55D454E610138
2116
MOHAMMED GAFFAR G
mgaffarg@gmail.com
+91 8861106223
...
NaN
NaN
14
2015-08-20
seenu
seenu@agiliq.com
Late Python
NaN
E5DJDDAXXXX55D4E286CA474
2122
seenu
seenu@agiliq.com
+91 9686494283
...
NaN
NaN
15
2015-08-20
Manuchandraprasad R
manu@turbolab.in
Late Python
NaN
E5DJDDAXXXX55D5E5D0B662D
2151
Manuchandraprasad R
manu@turbolab.in
+91 9995047587
...
NaN
NaN
16
2015-08-20
Shimil Rahman
shimil@inzyte.com
Late Python
NaN
E5DJDDAXXXX55D5E5D0B662D
2152
Manuchandraprasad R
manu@turbolab.in
+91 9995047587
...
NaN
NaN
17
2015-08-20
Ashwin Rajeev
ashwin@turbolab.in
Late Python
NaN
E5DJDDAXXXX55D5E5D0B662D
2153
Manuchandraprasad R
manu@turbolab.in
+91 9995047587
...
NaN
NaN
18
2015-08-20
Taranjeet Singh
reachtotj@gmail.com
Late Python
NaN
E5DJDDAXXXX55D5E8904A8C0
2156
Deshraj Yadav
deshrajdry@gmail.com
+91 9555344456
...
NaN
NaN
19
2015-08-21
Aritra Das
dodo.dodder@gmail.com
Late Python
NaN
E5DJDDAXXXX55D641335E63B
2164
Aritra Das
dodo.dodder@gmail.com
+91 8878101399
...
NaN
NaN
20
2015-08-21
Jatin Chhabriya
jatinchhabriya@yahoo.co.in
Late Python
NaN
E5DJDDAXXXX55D696EF4C726
2165
Jatin Chhabriya
jatinchhabriya@yahoo.co.in
+91 7259511125
...
NaN
NaN
21
2015-08-21
Pratheema Raman
pratheema5@gmail.com
Late Python
NaN
E5DJDDAXXXX55D6D361F162A
2171
Pratheema Raman
pratheema5@gmail.com
+7 7799958886
...
NaN
NaN
22
2015-08-21
Geethanjali Eawaran
geetha.palani99@gmail.com
Late Python
NaN
E5DJDDAXXXX55D6D361F162A
2172
Pratheema Raman
pratheema5@gmail.com
+7 7799958886
...
NaN
NaN
23
2015-08-22
Prashanth Shenoy
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2208
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
6-9
Male
Meduim - M
mangalore
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
24
2015-08-22
SAUMYA POOJARY
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2209
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Female
Small -S
MANGALORE
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
25
2015-08-22
Rahul Yadav
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2210
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
6-9
Male
Meduim - M
mangalore
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
india
No
NaN
NaN
26
2015-08-22
SUJAYA K.S.
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2211
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
1-3
Male
Meduim - M
MANGALORE
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
27
2015-08-22
karthik bhat
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2212
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Male
Small -S
mangalore
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
india
No
NaN
NaN
28
2015-08-22
PRAKASH MOHAN PRABHU
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2213
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Male
Small -S
MANGALORE
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
29
2015-08-22
SHAFUWAN B.E
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2214
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Male
Meduim - M
INDIA
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
30
2015-08-22
CHAITHRA B.S.
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2215
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Female
Meduim - M
MANGALORE
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
31
2015-08-22
PRASHANTHA AITHAL
accounts@mangaloreinfotech.in
Late Python
NaN
E5DJDDAXXXX55D8528BD5402
2216
madhav kamath
accounts@mangaloreinfotech.in
+91 8197492613
...
3-6
Male
Meduim - M
MANGALORE
MANGALORE INFOTECH SOLUTIONS PVT. LTD.
INDIA
No
NaN
NaN
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
1545
2015-05-07
Prajwal Suhas P
prajwalps97@gmail.com
Early Python
NaN
E5DJDDAXXXX554B31E9D833D
540441244
Prajwal Suhas P
prajwalps97@gmail.com
8971170621
...
6-9
Male
XL
Bangalore
Ninjaas
India
No
NaN
NaN
1546
2015-05-07
Ray CH
prajwalps97@gmail.com
Early Python
NaN
E5DJDDAXXXX554B31E9D833D
540441245
Prajwal Suhas P
prajwalps97@gmail.com
8971170621
...
6-9
Male
XL
Bangalore
Ninjaas
India
No
NaN
NaN
1547
2015-05-07
Kushal Das
kushaldas@gmail.com
Early Python
NaN
E5DJDDAXXXX554B33BAD3689
540441247
Kushal Das
kushaldas@gmail.com
8605430990
...
10-12
Male
XL
Pune
Red Hat
India
No
NaN
NaN
1548
2015-05-07
Anwesha Das
anwesha.srkr@gmail.com
Early Python
NaN
E5DJDDAXXXX554B33BAD3689
540441248
Kushal Das
kushaldas@gmail.com
8605430990
...
3-6
Female
Meduim - M
Pune
Personal
India
No
NaN
NaN
1549
2015-05-07
Chaitanya Agarwal
chaitanya.aol2011@gmail.com
Early Python
NaN
E5DJDDAXXXX554B367996FD2
540441249
Anshul Joshi
anshuljoshi.cse@gmail.com
9968112319
...
0-1
Male
Large - L
New Delhi
Xebia
India
No
NaN
Anshul requested for the transfer.
1550
2015-05-07
Shantanu Tushar
shaan7in@gmail.com
Early Python
NaN
E5DJDDAXXXX554B376D653FE
540441254
Shantanu Tushar
shaan7in@gmail.com
9972854774
...
3-6
Male
Large - L
Bangalore
Sostronk
India
No
NaN
NaN
1551
2015-05-07
Sumit Kumar Raj
sumit786raj@gmail.com
Early Python
NaN
E5DJDDAXXXX554B38CBADBB5
540441256
Sumit Raj
sumit786raj@gmail.com
9590283524
...
1-3
Male
Meduim - M
Bangalore
Yodlee Infotech
India
No
NaN
NaN
1552
2015-05-07
Arun Ghosh
arun@rawdatatech.com
Early Python
NaN
E5DJDDAXXXX554B18E602763
540441192
Chacko Cherian
chacko@rawdatatech.com
8592859274
...
6-9
Male
Meduim - M
Cochin
Rawdata Technologies
INDIA
No
NaN
NaN
1553
2015-05-07
Abdul Shukoor
abdulshukoorpk@gmail.com
Early Python
NaN
E5DJDDAXXXX554B18E602763
540441193
Chacko Cherian
chacko@rawdatatech.com
8592859274
...
0-1
Male
Large - L
Cochin
Rawdata Technologies
INDIA
No
NaN
NaN
1554
2015-05-07
Chacko Cherian
chacko@rawdatatech.com
Early Python
NaN
E5DJDDAXXXX554B18E602763
540441194
Chacko Cherian
chacko@rawdatatech.com
8592859274
...
10-12
Male
Meduim - M
Cochin
Rawdata Technologies
INDIA
No
NaN
NaN
1555
2015-05-07
Navajyoth
navajyothms1989@gmail.com
Early Python
NaN
E5DJDDAXXXX554B18E602763
540441195
Chacko Cherian
chacko@rawdatatech.com
8592859274
...
1-3
Male
Meduim - M
Cochin
Rawdatatech.com
INDIA
No
NaN
NaN
1556
2015-05-07
Sabareesh K
sabareeshk1991@gmail.com
Early Python
NaN
E5DJDDAXXXX554B18E602763
540441196
Chacko Cherian
chacko@rawdatatech.com
8592859274
...
1-3
Male
Meduim - M
Cochin
Rawdata TEchnologies
INDIA
No
NaN
NaN
1557
2015-05-07
Anil N S
anilns87@gmail.com
Early Python
NaN
E5DJDDAXXXX554B3B772D843
540441257
Anil N S
anilns87@gmail.com
+919900280773
...
1-3
Male
Large - L
Bangalore
Intel technologies-Bangalore
India
No
NaN
NaN
1558
2015-05-07
Abdul Rauf
abdulraufhaseeb@gmail.com
Early Python
NaN
E5DJDDAXXXX554B3F36EA143
540441262
Abdul Rauf
abdulraufhaseeb@gmail.com
9535495943
...
0-1
Male
Large - L
Gulbarga
CIRA
India
No
NaN
NaN
1559
2015-05-07
K A R SHYAMSUNDER
shyamkolluri89@gmail.com
Early Python
NaN
E5DJDDAXXXX554B40EEB5FF4
540441265
K A R SHYAMSUNDER
shyamkolluri89@gmail.com
9848051974
...
1-3
Male
XL
Hyderabad
D. E. Shaw India Software Pvt. Ltd.
India
No
NaN
NaN
1560
2015-05-07
Praveen Patil
praveenkumar103@gmail.com
Early Python
NaN
E5DJDDAXXXX554B3ED4A9BD6
540441261
Praveen Patil
praveenkumar103@gmail.com
9482543803
...
1-3
Male
Meduim - M
BELGAUM
G S SCIENCE COLLEGE BELGAUM
INDIA
No
NaN
NaN
1561
2015-05-07
Pratyush Mittal
pratyushmittal@gmail.com
Early Python
NaN
E5DJDDAXXXX554B4158DCD07
540441266
Pratyush Mittal
pratyushmittal@gmail.com
8960294979
...
3-6
Male
Meduim - M
Lucknow
Self
India
No
NaN
NaN
1562
2015-05-07
Cyrus Dasadia
cyrus@extremeunix.com
Early Python
NaN
E5DJDDAXXXX554B41BFC95CB
540441267
Cyrus Dasadia
cyrus@extremeunix.com
9663383021
...
15+
Male
XXL
Bangalore
None
India
No
NaN
NaN
1563
2015-05-07
Satyajeet Kanetkar
satyajeet@kanetkar.co.in
Early Python
NaN
E5DJDDAXXXX554B41EE465A9
540441268
Satyajeet Kanetkar
satyajeet@kanetkar.co.in
8983484449
...
3-6
Male
XL
Nagpur
Own
India
No
NaN
NaN
1564
2015-05-07
vishal sahasrabuddhe
vishal_vsh1@yahoo.com
Early Python
NaN
E5DJDDAXXXX554B47022B2EC
540441273
vishal sahasrabuddhe
vishal_vsh1@yahoo.com
9341042094
...
10-12
Male
Meduim - M
Bangalore
Inmobi
India
No
NaN
NaN
1565
2015-05-07
Tanay PrabhuDesai
tanayseven@ymail.com
Early Python
NaN
E5DJDDAXXXX554B46F57F10C
540441272
Tanay PrabhuDesai
tanayseven@ymail.com
8806365360
...
0-1
Male
Large - L
Margao
None
India
No
NaN
NaN
1566
2015-05-07
Balkrishnan Venkiteswaran
balkrishnan.venkiteswaran@gmail.com
Early Python
NaN
E5DJDDAXXXX554B4FCA2AF0C
540441281
Balkrishnan Venkiteswaran
balkrishnan.venkiteswaran@gmail.com
09742382692
...
6-9
Male
Large - L
BANGALORE
Self
India
No
NaN
NaN
1567
2015-05-07
Aamir Khan
syst3m.w0rm@gmail.com
Early Python
NaN
E5DJDDAXXXX554B5B445F160
540441290
Aamir Khan
syst3m.w0rm@gmail.com
7506200378
...
1-3
Male
Meduim - M
Bangalore
CoinPass
India
No
NaN
NaN
1568
2015-05-07
J. Raj Rohit
rajrohit@iitj.ac.in
Early Python
NaN
E5DJDDAXXXX554B5CFEEA58B
540441291
J. Raj Rohit
rajrohit@iitj.ac.in
7597369275
...
0-1
Male
XL
Gurgaon
Kayako
India
No
NaN
NaN
1569
2015-05-07
Apeksha Khakharia
apekhsha@gmail.com
Early Python
NaN
E5DJDDAXXXX554B5D049E5BB
540441292
Apeksha Khakharia
apekhsha@gmail.com
9591237366
...
1-3
Female
Small -S
Bangalore
RedHat
India
No
NaN
NaN
1570
2015-05-07
Arthy Loganathan
aloganat@redhat.com
Early Python
NaN
E5DJDDAXXXX554B5DB140291
540441293
Arthy Loganathan
aloganat@redhat.com
9739996925
...
3-6
Female
Small -S
Bangalore
Redhat
India
No
NaN
NaN
1571
2015-05-07
Mukesh Thawani
mukesh9039@gmail.com
Early Python
NaN
E5DJDDAXXXX554B5E3AA1D35
540441294
Mukesh Thawani
mukesh9039@gmail.com
8602102044
...
0-1
Male
Large - L
Bangalore
Innoventes technologies
India
No
NaN
NaN
1572
2015-05-07
Dipanjan Sarkar
dipanzan.sarkar@gmail.com
Early Python
NaN
E5DJDDAXXXX554B6A7D09D15
540441301
Dipanjan Sarkar
dipanzan.sarkar@gmail.com
9980960048
...
1-3
Male
XL
Bangalore
Intel
India
No
NaN
NaN
1573
2015-05-07
Kaniska Padhi
email@kaniska.in
Early Python
NaN
E5DJDDAXXXX554B6ADE31B85
540441302
Kaniska Padhi
email@kaniska.in
8237136225
...
3-6
Male
Meduim - M
Pune
CDAC
India
No
NaN
NaN
1574
2015-05-07
Sathyam Vellal
sathyam.vellal@gmail.com
Early Python
NaN
E5DJDDAXXXX554B6D7F5A0E1
540441305
Sathyam Vellal
sathyam.vellal@gmail.com
8123436453
...
1-3
Male
Meduim - M
Bangalore
PayPal
India
No
NaN
NaN
1557 rows × 23 columns
In [14]:
df.count()
Out[14]:
Date 1575
Attendee Name 1561
Attendee EmailId 1561
Ticket Name 1561
Ticket Category 14
Order Number 1561
Ticket Number 1561
Buyer Name 1561
Buyer EmailId 1561
Mobile No 1457
BIB No/Seat No 14
"First PyCon India" 1543
"Designation" 1561
"Experience" 1561
"Gender" 1561
"T-shirt size" 1561
"City" 1559
"Company/Organisation" 1528
"Country" 1283
"Would you like to avail Child care facility?" 1014
Reference No 265
Comment\r\n 287
extra 1034
dtype: int64
In [22]:
df['"Company/Organisation"'].unique()
Out[22]:
array([None, 'Company/Organisation', ' ',
'MANGALORE INFOTECH SOLUTIONS PVT. LTD.', 'Siminars', 'Appknox',
'Truebil', 'Kellton Tech', 'Knowledge Foundry', 'Riverbed',
'Riverbed Technology', 'Siminars Inc', 'Neuron', 'Startup',
'Xoanon Analytics', 'Yodlee', 'Gramener',
'Future Focus Infotech Pvt. Ltd.', 'Agiliq Info Solutions',
'bracketPy', 'Ubona technologies', 'American Express', 'Livspace',
'Flipkart', 'Texas Instruments', 'Pothi.com', 'Housing.com',
'Curofy', 'Eventifier', 'MotoGarage', 'echoVME',
'Kofax India Pvt Ltd', 'SlideRule Labs Inc.', 'Tata Elxsi',
'Mindteck', 'Lumira USA', 'Impetus', 'Freelance Tech Consultant',
'EdGE', 'Zimply', 'ONZE', 'Target', 'Microsoft India',
'D E Shaw India Software Private Limited', 'Practo Technologies',
'calm.io', 'Vishwakarma Institute of Information Technology',
'Wipro Technologies', 'Proven Logic', 'Roadrunnr',
'Tata Consultancy Services', 'Couchbase', 'Sandisk India',
'Capillary Technologies', 'IISER Kolkata', 'Xamcheck.com',
'Verifone India', 'Cryenx ', 'TARGET CORPORATION', 'McAfee',
'Mindtree', 'ZeOmega', 'CloudByte India Technologies Pvt Ltd',
'ZeOmega Infotech Pvt Ltd.', 'Intuit', 'none', 'InMobi', 'Paytm',
'C42 Engineering', 'Walmart', 'PassportParking Consulting Pvt Ltd',
'Narrativeviz', 'Thumbworks Technologies', 'Geekskool',
'Morgan Stanley', 'Zopper', 'Amazon India', 'Microsoft', 'Diffion',
'Juniper Technologies', 'Sigmoid Analytics', 'LinkedIn',
'SmartBuildings', 'WalmartLabs', 'Goibibo', 'Sriranga Technologies',
'CloudByte India Technologies Pvt Ltd.',
'Tata Consultancy Services Ltd', 'IPASS INDIA PVT LTD',
'GE India Technology Center Pvt Ltd.',
'Sell Mouse e-marketing Pvt Ltd', 'Raftaar Technologies',
'Linkedin Technology Information Pvt Ltd', 'Ericsson',
'Symphony Teleca', 'Smart ERP Solutions', 'Searce', 'JNTUK', 'tcs',
'sponsor dummy', 'goibibo.com', 'yodlee infotech', 'Red Hat inc',
'Moonshots Internet Pvt Ltd', 'GE India Technology Center Pvt Ltd',
'Bridgei2i', 'Sayone Technologies', 'Practo Technologies Pvt Ltd',
'Perfios Software Solutions Pvt. Ltd.', 'GTAC',
'Ricoh Innovations Pvt. Ltd.', 'Instamojo', 'Care24', 'Red Hat Inc',
'Flipkart ', 'HP ', 'OrangeScape Technologies Ltd.',
'Swifttote Technologies', 'IBM', 'Target Corporation India',
'Wipro Tech', 'beehyv software solutions',
'Beehyv Software Solutions Pvt. Ltd.',
'GLOBAL ANALYTICS INDIA PVT LTD', 'GlowPrime Technologies Pvt Ltd',
'Fireeye Cybersecurity Pvt. Ltd', 'Zynga', 'Akamai Technologies',
'MedIndiaTrips.com', 'D. E. Shaw India Software Pvt. Ltd.', 'sendd',
'CSIR-4PI', 'PwC', 'Cisco Systems', 'Oracle', 'Directi / Media.net',
'Directi ', 'Meddiff technologies', 'TinyOwl',
'Brillio Technologies', 'iQuanti Inc.', 'HT Media',
'Screen-Magic Mobile Pvt.Ltd', 'curofy', 'Qplaytech', 'Xlott',
'vmware', 'Vmware', 'SLK Software Services Ltd',
'Ricoh Innovations', 'Student', 'iPass India Pvt. Ltd.', 'GOIBIBO',
'Robert Bosch', '8Finatics', 'BigTapp', 'SNR Technologies',
'BIGTAPP ', 'Druva', 'Upayog Solutions', 'Tarams Technologies',
'VAST', 'PES institutions', 'Tarams', 'Idea Device',
'Google India ', 'VRUKSHAM', 'Mercedes Benz', 'Jntu-Anantapur',
'Fireeye', 'Country', 'India', nan, 'INDIA', 'india', 'USA',
'India ', 'Indiail', '7Cstudio', 'Accionlabs', 'Aruba Networks',
'Red Hat', 'Self', 'Infidez Solutions', 'Pramati Technologies',
'BA Continuum', 'Pramati', 'Manufacturing System Insights',
'QLogic India Private Limited', 'TCS', 'Oracle India Pvt Ltd',
'Surya Software Systems',
'Sriranga Digital Software technologies Private Limited',
'Swifttote Technologies (P) Ltd.', 'Indiaproperty.com', 'N',
'Red Hat India', 'MQuotient', 'gramener', 'kodeplay', 'Simform',
'self', 'Nutanix', 'CSR India', 'BMSCE', 'Intel', 'Indic Project',
'Bosch', 'Mu Sigma', 'Valeo', 'Zebra Technologies India Pvt Ltd',
'Mindfire Solutions', 'Fidelity Business Services India Pvt Ltd',
'CSC INDIA', 'Nextag', 'Symantec', 'Zeomega InfoTech Pvt Ltd',
'entri.me', 'Accenture', 'Hortonworks',
'The Institute of Mathematical Sciences', 'Global Analytics',
'Marketcalls Financial Services Pvt Ltd', 'ChurnData', 'PowerToFly',
'Mahiti Infotech', 'Wipro', 'Org', '-', 'Samsung R&D',
'EFI India Pvt Ltd', 'Informatica',
'Global Analytics India Pvt. Ltd. ', 'Zynga Games Network Pvt Ltd',
'MoveInSync', 'SKYHIGH NETWORKS', 'Amazon Development Center',
'wipro technologies', 'Independent', 'Fafadia Tech',
'Compare Munafa', 'Persistent System Limited', 'Intel Secruity',
'National College ', 'Monotype Solutions India Pvt. Ltd.',
'personal', 'Ford Technology Services India',
'Rebaca Technologies Pvt Ltd', 'Trivium eSolutions', 'Powertofly',
'RocketBox', 'Aptira', 'SignEasy', 'VMware', 'Acesoft Labs',
'Snapdeal', 'Sportskeeda', 'Zeomega Infotech Private Ltd',
'Indiaproperty Online Pvt. Ltd.', 'Unmetric Technologies Pvt. Ltd.',
'Bank Of America', '.', 'Forte Research Systems', 'SPRDH Webs Apps',
'ZeOmega Infotech Pvt Ltd', 'Persistent Systems',
'Riptide IO India Pvt Ltd', 'Knowlarity', 'Concur',
'Riverbed India Pvt Ltd', 'adnear', 'Makemytrip.com',
'Techmahindra', 'AVR Edge Networks', 'Bigbasket.com',
'bigbasket.com', 'HackerEarth', 'HP', 'Altran Techonologies',
'iDataLabs', 'iQuanti', 'Shipler', 'Scimata', 'Leaf Technologies',
'Practo', 'Hcl', 'Instahyre.com', 'Juniper Networks', 'Juniper',
'Adobe Systems India', 'None', 'Red Hat Pvt. Ltd.', 'MapleLabs',
'Knowlarity Communications', 'UST Global', 'Calsoft labs',
'DataCulture Analytics Company', 'BlueJeans', 'Huawei',
'Yos Technologies Pvt. Ltd.', 'Incognito Softworks', 'kPoint',
'ThinkLABS', 'CreativeV', 'WeavedIn', 'Gemini Solutions India',
'Sigmoid', 'ADP', 'Qlogic India Pvt Ltd', 'Grofers', 'Knowlarity ',
'Teamchat', 'Dhananjay Nene', 'VMWare', 'Synechron',
'Sahaj Software Solutions Pvt. Ltd', 'Edge Networks', 'Postman',
'Gale Partners', 'Pipal Academy', 'Power To Fly',
'Fantain Sports Pvt. Ltd.', 'Fantain Spoprts', 'ZeOmega ',
'Cisco India pvt ltd', '[24]7 Innovation Labs', 'Self Employed',
'NetApp ', 'Directi', 'Cigital Inc.', 'Cigital Inc. ', 'Nestopia',
'Zyme Solutions', 'Getlook', 'Profoundis Labs',
'Hewlett Packard Enterprise', 'Hewlett Packard', 'Analog Devices',
'Semantics3', 'Profoundis', 'Amachu', 'Schrodinger', 'WIPRO',
'JP Morgan', 'oksoft', 'Infosys Technologies Limited', 'QAD Inc.',
'Cognizant tech', 'Contify', 'scriptingschool', 'FREELANCE',
'7CStudio', 'Global Edge', 'PromptCloud', 'Swiss Re',
'InBetween IT Services', 'HP Enterprises', 'Ophio', 'Cisco',
'Orangescape Technologies', 'IITB', 'Tenreads',
'Fireeye CyberSecurity pvt. ltd.', 'TFS', 'IBM India Pvt. Ltd.',
'Groupon', 'Walmart Labs', 'Webswats', 'NetApp', 'Prolim',
'Tarams Software Technologies', 'ZeOmega Infotech Pvt Ltd ',
'Zeomega', 'Amazon', 'Red Hat Software Services', '[24]7 iLabs',
'Robosofot Technologies Pvt Ltd', 'Time Inc', 'Monsanto R&D Center',
'Nuventure', 'Recursive Labs', 'Hackerearth', 'Artiquest',
'Tarams Software Pvt Ltd', 'Inmobi', 'MakeMyTrip India Pvt Ltd.',
'Serendio', 'Mad Street Den', 'Kivy', 'Belong.co', 'Trimble',
'[24]7', 'Zilogic Systems', 'Freeth Technologies', 'Dimension Data',
'NTT DATA', 'Akamai', 'Ace Learning', 'BrowserStack',
'Mahindra Comviva', 'Tech Mahindra',
'ANVETSU TECHNOLOGIES PVT. LTD', 'Aboutfullstack', 'AMDOCS', 'Sony',
'Reliance Jio', 'willow.tv', 'musicbajao.in', 'ShieldSquare',
'neuronme', 'SpiffOut Infomedia Pvt. Ltd.', 'Mentor Graphics INC',
'Unisys', 'Infosys Limited', 'socialboard.in', 'Aider Solutions',
'Fidelity Investments', 'Zilogic Systems Pvt Ltd', 'Moonfroglabs',
'Gavika Information Technologies Pvt. Ltd.', 'StartupSanatana',
'Focus Analytics Pvt. Ltd.', 'ShareChat',
'Enfini Technology Solutions Pvt Ltd', 'Edge Networks PVT LTD',
'Computer Sciences Corporation', 'HCL Technologies', 'Bloomreach',
'Infosys', 'Centre for Human Genetics', 'CSC', 'Cubito',
'Riverbed Technologies', 'Ashoka University', 'Times Internet',
'SELF', 'Avish', 'HT Media Ltd', 'AIG', 'Infilect', 'Indee',
'**Self**', 'Suyati Technologies Private Limited', 'Tinyowl',
'Druva Data Solutions Pvt Ltd', 'Avish Web Soft', 'logicguns',
'Simplotel', 'Misys', 'Continental Automotive', 'SLS', 'other',
'CropIn Technology', 'PES', 'storewalk', 'Scroll.in', 'null',
'Mphasis', 'oracle', 'Green design labs',
'Enfini Technology Solutions Pvt. Ltd.', 'Soliton Technologies',
'Mettle Networks', 'Kuliza', 'Recursive Tech', 'Watchy',
'globalsoft', 'Aruba networks', 'Vimo', 'Helpshift',
'Clogeny Technologies', 'Consultant', 'Predikt', 'CommonCode',
'ImportPython', 'ankur.org.in', 'MakeMyTrip', 'Target Corp India',
'Opera', 'Appromote', 'intel', 'Geek', 'Logic Soft', 'redmart',
'Konotor', 'Karnataka Learning Partnership', 'Intel Security',
'RED HAT', 'Target India Corporation', 'Aerospike',
'Profoundis Inc.', 'Equal Experts', 'Xoriant', 'End Point',
'Cognizant', 'Independent Consultant', 'Lyxel Labs',
'Blue Jeans Network', 'InstaScribe', 'ethicstech', 'KPIT', 'RBEI',
'GS LAB', 'Thumbworks Technologies Pvt. Ltd.',
'SAP Labs India Pvt Ltd', 'Reliance Jio Infocomm', 'Ola Cabs',
'Jio', 'Petasense', 'Sensara', 'IIT Bombay', 'DailyRounds',
'DataCulture Analytics', 'Tinyowl Technology PVT LTD',
'ANI TECHNOLOGIES', 'Tradesoft', 'Harry Software Services',
'Fractalio Data', 'Xamcheck',
'Shreshta IT Technologies Pvt. Ltd/eth1 Network Solutions',
'Scrollback', 'Target Corp', 'ZeOmega Infotech Pvt. Ltd.',
'rupee power', 'Informant Networks', 'WalletKit',
'Vunet SystemsIndia', 'AU KBC ANNA UNIVERSITY', 'Pubnub',
'Gramener Technologies', 'On a Sabbatical', 'Ophio ', 'HasGeek',
'Impressions Services Pvt. Ltd.', 'Tracxn Technologies Pvt Ltd',
'Airwoot', 'hCare', 'lrb', 'Ninjaas', 'Personal', 'Xebia',
'Sostronk', 'Yodlee Infotech', 'Rawdata Technologies',
'Rawdatatech.com', 'Rawdata TEchnologies',
'Intel technologies-Bangalore', 'CIRA',
'G S SCIENCE COLLEGE BELGAUM', 'Own', 'CoinPass', 'Kayako',
'RedHat', 'Redhat', 'Innoventes technologies', 'CDAC', 'PayPal'], dtype=object)
In [23]:
students = df['Ticket Name']
Out[23]:
array([None, 'Ticket Name', 'Late Python', 'On-the-spot Python',
'Using devstack to contribute to OpenStack 1:00PM - 3:30PM',
'Getting Started with Ansible 9:00AM - 12:30PM',
'Building NextGen IoT solutions using Python and Cloud 4:00PM - 6:30PM',
'Student Python', 'Lets Learn Statistics! 9:00AM - 12:30PM',
'Django Projects the Right way! 9:00AM - 12:30PM',
'Python on your Mobile Phone(advanced concepts) 4:00PM - 6:30PM',
'Reasoning under uncertainty with Python 1:00PM - 3:30PM',
'Symbolic computation with Python SymPy 1:00PM - 3:30PM',
'Thinking in Functions 4:00PM - 6:30PM', 'Regular Python',
'Early Python'], dtype=object)
In [27]:
df[df['Ticket Name'] == 'Student Python'].count()
Out[27]:
Date 252
Attendee Name 252
Attendee EmailId 252
Ticket Name 252
Ticket Category 0
Order Number 252
Ticket Number 252
Buyer Name 252
Buyer EmailId 252
Mobile No 252
BIB No/Seat No 0
"First PyCon India" 234
"Designation" 252
"Experience" 252
"Gender" 252
"T-shirt size" 252
"City" 252
"Company/Organisation" 252
"Country" 0
"Would you like to avail Child care facility?" 1
Reference No 252
Comment\r\n 0
extra 0
dtype: int64
In [37]:
df.groupby(df['"City"']).count()
Out[37]:
Date
Attendee Name
Attendee EmailId
Ticket Name
Ticket Category
Order Number
Ticket Number
Buyer Name
Buyer EmailId
Mobile No
...
"Designation"
"Experience"
"Gender"
"T-shirt size"
"Company/Organisation"
"Country"
"Would you like to avail Child care facility?"
Reference No
Comment
extra
"City"
107
107
107
107
0
107
107
107
107
21
...
107
107
107
107
107
107
107
0
0
107
3DPLM Software Solutions Limited
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
0
0
3
3
Ahmedabad
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
Amazon
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
0
1
0
0
1
1
Amrita School of Engineering Bengaluru
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
1
0
0
2
2
Amrita Vishwa Vidyapeetham
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
0
0
3
3
Amrita Vishwa Vidyappetham
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
Amrita school of engineering
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
0
0
0
1
1
Anantapur
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
Arya college of engineering and IT
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
Asansol
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
0
1
1
0
0
1
BANALORE
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
BANGALORE
9
9
9
9
0
9
9
9
9
9
...
9
9
9
9
9
9
9
0
0
9
BELGAUM
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
BOM
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
Bangalore
476
476
476
476
0
476
476
476
476
466
...
476
476
476
476
475
476
469
0
14
476
Bangalore
10
10
10
10
0
10
10
10
10
10
...
10
10
10
10
10
10
10
0
0
10
Bangalore/Kerala
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
Banglore
9
9
9
9
0
9
9
9
9
9
...
9
9
9
9
9
9
9
0
0
9
Belgaum
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
2
2
0
0
2
Bengaluru
28
28
28
28
0
28
28
28
28
28
...
28
28
28
28
27
28
26
0
1
28
Bengaulru
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
3
0
0
3
Berhampur
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
0
1
1
0
0
1
Bhubaneswar
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
3
0
0
3
CHENNAI
4
4
4
4
0
4
4
4
4
4
...
4
4
4
4
4
4
3
0
0
4
Calicut
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
Care24
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
2
0
0
2
2
Chennai
62
62
62
62
0
62
62
62
62
62
...
62
62
62
62
62
62
57
0
1
62
Chitkara University
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
Cisco
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Vishwayon Software PVT LTD
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
Visible Alpha
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
0
0
3
3
Wazoku
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
Webonise Lab
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
XL - Extra Large
45
45
45
45
0
45
45
45
45
45
...
45
45
45
45
45
0
1
45
45
45
XXL
13
13
13
13
0
13
13
13
13
13
...
13
13
13
13
13
0
0
13
13
13
Xlott
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
0
0
0
2
2
ZeOmega
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
0
0
3
3
Zopper
14
14
14
14
0
14
14
14
14
14
...
14
14
14
14
12
14
0
0
14
14
Zyme Solutions
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
0
1
0
0
1
1
[24]7 Innovation Labs
6
6
6
6
0
6
6
6
6
6
...
6
6
6
6
6
6
0
0
6
6
accenture
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
bangalore
27
27
27
27
0
27
27
27
27
27
...
27
27
27
27
27
27
25
0
0
27
bangalure
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
1
1
bengaluru
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
chennai
3
3
3
3
0
3
3
3
3
3
...
3
3
3
3
3
3
3
0
0
3
curofy
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
0
0
0
0
2
2
delhi
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
0
1
hyderabad
5
5
5
5
0
5
5
5
5
5
...
5
5
5
5
5
5
5
0
0
5
iPass India Pvt. Ltd.
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
kochi
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
1
0
0
1
mangalore
4
4
4
4
0
4
4
4
4
4
...
4
4
4
4
4
4
4
0
0
4
mumbai
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
2
1
0
0
2
none
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
nutanix
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
oracle
1
1
1
1
0
1
1
1
1
1
...
1
1
1
1
1
1
0
0
1
1
sendd
6
6
6
6
0
6
6
6
6
6
...
6
6
6
6
6
6
0
0
6
6
sponsor dummy
7
7
7
7
0
7
7
7
7
0
...
7
7
7
7
7
7
0
0
0
7
student
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
1
0
0
2
2
yuya
2
2
2
2
0
2
2
2
2
2
...
2
2
2
2
2
2
0
0
2
2
196 rows × 22 columns
In [ ]:
In [ ]:
Content source: pythonhacker/inotebooks
Similar notebooks: