{ "cells": [ { "cell_type": "code", "execution_count": 70, "metadata": {}, "outputs": [ { "data": { "text/html": [ " \n", " " ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import pandas as pd\n", "import numpy as np\n", "import cufflinks as cf\n", "cf.set_config_file(world_readable=True,offline=True)" ] }, { "cell_type": "code", "execution_count": 71, "metadata": {}, "outputs": [], "source": [ "df = pd.read_csv(\"Sam BloodLinks.csv\")" ] }, { "cell_type": "code", "execution_count": 72, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact NumberE-Mailc1c2c3c4c5
0Vijay Mehta32A+Begumpet HYDERABAD98485845292vijaymehta@gmail.comNaNNaNNaNNaNNaN
1Arindam Deka25A+Kondapur HYDERABAD8125298304darindam231@gmail.comNaNNaNNaNNaNNaN
2alluri babul reddy27A+plot no 96/b HYDERABAD9642244070Areddysanthosh333@gmail.comNaNNaNNaNNaNNaN
3Kiran Swamy .A34A+hyderabad HYDERABAD9963339200NaNNaNNaNNaNNaN
4a prasad26A+prem nagar,khairathabad. HYDERABAD9032032310prasad.available@yahoo.inNaNNaNNaNNaNNaN
5Abdul Rahman25A+Santosh nagar HYDERABAD9642692545arkhan093@gmail.comNaNNaNNaNNaNNaN
6Abhilash reddy24A+Gandhinagar HYDERABAD8801770077NaNNaNNaNNaNNaN
7ABHIJIT JEETU21A+Hyderabad Central University HYDERABAD9966362080abhijit18061991@yahoo.comNaNNaNNaNNaNNaN
8abhinay barla21A+1-1-304, road no 6, balaji colony mohan nagar ...8125950302abhinaybarla52@gmail.comNaNNaNNaNNaNNaN
9abhishek bhoreddy28A+H: 1-53, flat no 208, sai residency,Madinaguda...9885902222abhishek.bhoreddy@gmail.comNaNNaNNaNNaNNaN
10Achutha Prasad24A+No 16, 3rd floor, Rahul colony, Tolichowki. HY...9342757176achutha.prasad70@outlook.comNaNNaNNaNNaNNaN
11A CHANDRA OBULA REDD26A+hydrabad HYDERABAD9550481780NaNNaNNaNNaNNaN
12rajesh kumar28A+2-21, ram nagar. hyderabad HYDERABAD7075009449rajeshkumar.maya@gmail.comNaNNaNNaNNaNNaN
13Aditi Ainapure22A+Nehru Gunj Kalaburagi, Karnataka HYDERABAD9113946610ainapureaditi@gmail.comNaNNaNNaNNaNNaN
14raj agarwal41A+sanathnagar HYDERABAD9494394592dishapharma.hyd@gmail.comNaNNaNNaNNaNNaN
15agarwal rajesh41A+sanathnagar HYDERABAD9494394592NaNNaNNaNNaNNaN
16Veljala Agnivesh0A+24 1 jnnurm colony peerancheruvu HYDERABAD9573344319agnivesh55@gmail.comNaNNaNNaNNaNNaN
17Ajay Chenigunta25A+09642549475 HYDERABAD9642549475ajay.chenigunta@gmail.comNaNNaNNaNNaNNaN
18sri ranjitha kulakarni30A+Flat No.401, ranjita residency,kphb HYDERABAD9848022338ranjitha.sri@gmail.comNaNNaNNaNNaNNaN
19Ravikiran Akella30A+Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY...9000277678ravikiran.akela@gmail.comNaNNaNNaNNaNNaN
20Akhil Kumar20A+Sathish Nagar colony near bustand nalgonda HYD...9182538554Akhilrock108@gmail.comNaNNaNNaNNaNNaN
21Akhil20A+Nagole HYDERABAD9618106017NaNNaNNaNNaNNaN
22Akhilesh25A+3-4-369/4/b, krishna nagar, bholakpur HYDERABAD8686299309NaNNaNNaNNaNNaN
23ganesh yyadav23A+kukatpally HYDERABAD7702120996NaNNaNNaNNaNNaN
24akram khan30A+srt 68 HYDERABAD9963110557akramkhhan111@gmail.comNaNNaNNaNNaNNaN
25Alekhya Pinnamaneni21A+7-1-282/E, Balkampet, S R Nagar, hyderabad HYD...9550411659NaNNaNNaNNaNNaN
26alizeh shirazi25A+sara homes, upperpally, hyderabad HYDERABAD8686386991NaNNaNNaNNaNNaN
27Prabhu26A+LIngampalli HYDERABAD9900222349NaNNaNNaNNaNNaN
28R S Narayana Galidevara27A+Balaji hills, Nijampet, Hyderabad HYDERABAD1847808911amar.galidevara@gmail.comNaNNaNNaNNaNNaN
29Srinidhi Krishnamachary37A+Flat No 201, Plot No 333-335, Sri Sai Hanuma R...9989967895amazingsrinidhi@gmail.comNaNNaNNaNNaNNaN
....................................
3908N.venkat Rao23O-No SECUNDERABAD7285910430neelirotuvenky333@gmail.comNaNNaNNaNNaNNaN
3909Nagendra Reddy26O-H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec...8143382248Nagreddy.1992@gmail.comNaNNaNNaNNaNNaN
3910naveen kumar yamsani29O-04023392745 SECUNDERABAD9885344462y_naveen_81@yahoo.comNaNNaNNaNNaNNaN
3911neelima lakshmi21O-secunderabad SECUNDERABAD9394309995neelima.lakshmi545@gmail.comNaNNaNNaNNaNNaN
3912niwaniv niwaniv0O-SECUNDERABADfihaham@mailsdfsdf.comNaNNaNNaNNaNNaN
3913Praful Yadav28O-sainkpuri SECUNDERABAD8686021042praful.yadav86@yahoo.comNaNNaNNaNNaNNaN
3914pasp naidu35O-as rao nagar SECUNDERABAD9701171118paspnaidu@aol.comNaNNaNNaNNaNNaN
3915punit pushkar25O-501, sree ram charan towers, old bowenpally SE...8464038825punitpushkar.k@gmail.comNaNNaNNaNNaNNaN
3916raghuram vangala30O-ammerpeta SECUNDERABAD9642752360bharat.vangala@gmail.comNaNNaNNaNNaNNaN
3917Rajasekhar kola33O-neredmet SECUNDERABAD9989837871raja.kola@Invesco.comNaNNaNNaNNaNNaN
3918KAMANCHI RAM MOHAN BABU37O-c/o sbh msme moulali branch, nfc road moulali,...9010406089kamanchi.babu@sbhyd.co.inNaNNaNNaNNaNNaN
3919Chandra Shekar Reddy Bannur36O-BEGUMPET SECUNDERABAD9052893393reddybcs@yahoo.comNaNNaNNaNNaNNaN
3920Pinks Pinks27O-Secunderabad SECUNDERABAD8885001333NaNNaNNaNNaNNaN
3921RichardMn RichardMn0O-SECUNDERABADsylmenipin1990@sorimail.comNaNNaNNaNNaNNaN
3922Sadan Reddy S21O-secunderabad SECUNDERABAD9505010085s.sadanreddy57@gmail.comNaNNaNNaNNaNNaN
3923GUTTAPATI SESHAGIRI ACHARYULU39O-FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD9848410346guttapati2001@yahoo.comNaNNaNNaNNaNNaN
3924sadiq mohammad25O-tarnaka,secundrabad. SECUNDERABAD9849405373sheik.sadiq6@gmail.comNaNNaNNaNNaNNaN
3925Subrahmanya Sarma M38O-6-1-132/136,Padmarao nagar SECUNDERABAD9000675611sharma.medavarapu@gmail.comNaNNaNNaNNaNNaN
3926Somil Jain23O-ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD7987276603Sjbdarocker@gmail.comNaNNaNNaNNaNNaN
3927SREENIVAS YADAV23O-09885632631 SECUNDERABAD9885632631YADAV.SREENIVAS609@GMAIL.COMNaNNaNNaNNaNNaN
3928Suchan Golla21O-7-741/4,subhash nagar,Hyderabad SECUNDERABAD9701816008NaNNaNNaNNaNNaN
3929Sunil Stephen34O-Secunderabad SECUNDERABAD9502114280sunil.stephen@hotmail.comNaNNaNNaNNaNNaN
3930Surya Yadav24O-Malkajgiri SECUNDERABAD8186815844rasalasurya5844@gmail.comNaNNaNNaNNaNNaN
3931Thailandi-Mycle Thailandi-Mycle0O-SECUNDERABADuser1@bazatver.ruNaNNaNNaNNaNNaN
3932ThomasDuh ThomasDuh0O-SECUNDERABADsilvermanjoseph@mail.ruNaNNaNNaNNaNNaN
3933tiffanyxu1 tiffanyxu10O-SECUNDERABADor16@keely.johanna.chicagoimap.topNaNNaNNaNNaNNaN
3934vamshidhar reddy28O-malkajgiri SECUNDERABAD7799452981vamshi131286@Gmail.comNaNNaNNaNNaNNaN
3935vinith reddy20O-b.s nagar, malajgiri,secunderabad SECUNDERABAD7075008899vinithcvsr@gmail.comNaNNaNNaNNaNNaN
3936Shaik Zaheer24O-12-1-505, st.no 11 tarnaka. SECUNDERABAD9916411004zaheerdz@gmail.comKNaNNaNNaNNaNNaN
3937MYLSAMY35A1B+3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD9700618565k.myilswamy@gmail.comNaNNaNNaNNaNNaN
\n", "

3938 rows × 11 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Vijay Mehta 32 A+ \n", "1 Arindam Deka 25 A+ \n", "2 alluri babul reddy 27 A+ \n", "3 Kiran Swamy .A 34 A+ \n", "4 a prasad 26 A+ \n", "5 Abdul Rahman 25 A+ \n", "6 Abhilash reddy 24 A+ \n", "7 ABHIJIT JEETU 21 A+ \n", "8 abhinay barla 21 A+ \n", "9 abhishek bhoreddy 28 A+ \n", "10 Achutha Prasad 24 A+ \n", "11 A CHANDRA OBULA REDD 26 A+ \n", "12 rajesh kumar 28 A+ \n", "13 Aditi Ainapure 22 A+ \n", "14 raj agarwal 41 A+ \n", "15 agarwal rajesh 41 A+ \n", "16 Veljala Agnivesh 0 A+ \n", "17 Ajay Chenigunta 25 A+ \n", "18 sri ranjitha kulakarni 30 A+ \n", "19 Ravikiran Akella 30 A+ \n", "20 Akhil Kumar 20 A+ \n", "21 Akhil 20 A+ \n", "22 Akhilesh 25 A+ \n", "23 ganesh yyadav 23 A+ \n", "24 akram khan 30 A+ \n", "25 Alekhya Pinnamaneni 21 A+ \n", "26 alizeh shirazi 25 A+ \n", "27 Prabhu 26 A+ \n", "28 R S Narayana Galidevara 27 A+ \n", "29 Srinidhi Krishnamachary 37 A+ \n", "... ... .. ... \n", "3908 N.venkat Rao 23 O- \n", "3909 Nagendra Reddy 26 O- \n", "3910 naveen kumar yamsani 29 O- \n", "3911 neelima lakshmi 21 O- \n", "3912 niwaniv niwaniv 0 O- \n", "3913 Praful Yadav 28 O- \n", "3914 pasp naidu 35 O- \n", "3915 punit pushkar 25 O- \n", "3916 raghuram vangala 30 O- \n", "3917 Rajasekhar kola 33 O- \n", "3918 KAMANCHI RAM MOHAN BABU 37 O- \n", "3919 Chandra Shekar Reddy Bannur 36 O- \n", "3920 Pinks Pinks 27 O- \n", "3921 RichardMn RichardMn 0 O- \n", "3922 Sadan Reddy S 21 O- \n", "3923 GUTTAPATI SESHAGIRI ACHARYULU 39 O- \n", "3924 sadiq mohammad 25 O- \n", "3925 Subrahmanya Sarma M 38 O- \n", "3926 Somil Jain 23 O- \n", "3927 SREENIVAS YADAV 23 O- \n", "3928 Suchan Golla 21 O- \n", "3929 Sunil Stephen 34 O- \n", "3930 Surya Yadav 24 O- \n", "3931 Thailandi-Mycle Thailandi-Mycle 0 O- \n", "3932 ThomasDuh ThomasDuh 0 O- \n", "3933 tiffanyxu1 tiffanyxu1 0 O- \n", "3934 vamshidhar reddy 28 O- \n", "3935 vinith reddy 20 O- \n", "3936 Shaik Zaheer 24 O- \n", "3937 MYLSAMY 35 A1B+ \n", "\n", " Address Contact Number \\\n", "0 Begumpet HYDERABAD 9848584529 \n", "1 Kondapur HYDERABAD 8125298304 \n", "2 plot no 96/b HYDERABAD 9642244070 \n", "3 hyderabad HYDERABAD 9963339200 \n", "4 prem nagar,khairathabad. HYDERABAD 9032032310 \n", "5 Santosh nagar HYDERABAD 9642692545 \n", "6 Gandhinagar HYDERABAD 8801770077 \n", "7 Hyderabad Central University HYDERABAD 9966362080 \n", "8 1-1-304, road no 6, balaji colony mohan nagar ... 8125950302 \n", "9 H: 1-53, flat no 208, sai residency,Madinaguda... 9885902222 \n", "10 No 16, 3rd floor, Rahul colony, Tolichowki. HY... 9342757176 \n", "11 hydrabad HYDERABAD 9550481780 \n", "12 2-21, ram nagar. hyderabad HYDERABAD 7075009449 \n", "13 Nehru Gunj Kalaburagi, Karnataka HYDERABAD 9113946610 \n", "14 sanathnagar HYDERABAD 9494394592 \n", "15 sanathnagar HYDERABAD 9494394592 \n", "16 24 1 jnnurm colony peerancheruvu HYDERABAD 9573344319 \n", "17 09642549475 HYDERABAD 9642549475 \n", "18 Flat No.401, ranjita residency,kphb HYDERABAD 9848022338 \n", "19 Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY... 9000277678 \n", "20 Sathish Nagar colony near bustand nalgonda HYD... 9182538554 \n", "21 Nagole HYDERABAD 9618106017 \n", "22 3-4-369/4/b, krishna nagar, bholakpur HYDERABAD 8686299309 \n", "23 kukatpally HYDERABAD 7702120996 \n", "24 srt 68 HYDERABAD 9963110557 \n", "25 7-1-282/E, Balkampet, S R Nagar, hyderabad HYD... 9550411659 \n", "26 sara homes, upperpally, hyderabad HYDERABAD 8686386991 \n", "27 LIngampalli HYDERABAD 9900222349 \n", "28 Balaji hills, Nijampet, Hyderabad HYDERABAD 1847808911 \n", "29 Flat No 201, Plot No 333-335, Sri Sai Hanuma R... 9989967895 \n", "... ... ... \n", "3908 No SECUNDERABAD 7285910430 \n", "3909 H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec... 8143382248 \n", "3910 04023392745 SECUNDERABAD 9885344462 \n", "3911 secunderabad SECUNDERABAD 9394309995 \n", "3912 SECUNDERABAD \n", "3913 sainkpuri SECUNDERABAD 8686021042 \n", "3914 as rao nagar SECUNDERABAD 9701171118 \n", "3915 501, sree ram charan towers, old bowenpally SE... 8464038825 \n", "3916 ammerpeta SECUNDERABAD 9642752360 \n", "3917 neredmet SECUNDERABAD 9989837871 \n", "3918 c/o sbh msme moulali branch, nfc road moulali,... 9010406089 \n", "3919 BEGUMPET SECUNDERABAD 9052893393 \n", "3920 Secunderabad SECUNDERABAD 8885001333 \n", "3921 SECUNDERABAD \n", "3922 secunderabad SECUNDERABAD 9505010085 \n", "3923 FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD 9848410346 \n", "3924 tarnaka,secundrabad. SECUNDERABAD 9849405373 \n", "3925 6-1-132/136,Padmarao nagar SECUNDERABAD 9000675611 \n", "3926 ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD 7987276603 \n", "3927 09885632631 SECUNDERABAD 9885632631 \n", "3928 7-741/4,subhash nagar,Hyderabad SECUNDERABAD 9701816008 \n", "3929 Secunderabad SECUNDERABAD 9502114280 \n", "3930 Malkajgiri SECUNDERABAD 8186815844 \n", "3931 SECUNDERABAD \n", "3932 SECUNDERABAD \n", "3933 SECUNDERABAD \n", "3934 malkajgiri SECUNDERABAD 7799452981 \n", "3935 b.s nagar, malajgiri,secunderabad SECUNDERABAD 7075008899 \n", "3936 12-1-505, st.no 11 tarnaka. SECUNDERABAD 9916411004 \n", "3937 3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD 9700618565 \n", "\n", " E-Mail c1 c2 c3 c4 c5 \n", "0 2vijaymehta@gmail.com NaN NaN NaN NaN NaN \n", "1 darindam231@gmail.com NaN NaN NaN NaN NaN \n", "2 Areddysanthosh333@gmail.com NaN NaN NaN NaN NaN \n", "3 NaN NaN NaN NaN NaN \n", "4 prasad.available@yahoo.in NaN NaN NaN NaN NaN \n", "5 arkhan093@gmail.com NaN NaN NaN NaN NaN \n", "6 NaN NaN NaN NaN NaN \n", "7 abhijit18061991@yahoo.com NaN NaN NaN NaN NaN \n", "8 abhinaybarla52@gmail.com NaN NaN NaN NaN NaN \n", "9 abhishek.bhoreddy@gmail.com NaN NaN NaN NaN NaN \n", "10 achutha.prasad70@outlook.com NaN NaN NaN NaN NaN \n", "11 NaN NaN NaN NaN NaN \n", "12 rajeshkumar.maya@gmail.com NaN NaN NaN NaN NaN \n", "13 ainapureaditi@gmail.com NaN NaN NaN NaN NaN \n", "14 dishapharma.hyd@gmail.com NaN NaN NaN NaN NaN \n", "15 NaN NaN NaN NaN NaN \n", "16 agnivesh55@gmail.com NaN NaN NaN NaN NaN \n", "17 ajay.chenigunta@gmail.com NaN NaN NaN NaN NaN \n", "18 ranjitha.sri@gmail.com NaN NaN NaN NaN NaN \n", "19 ravikiran.akela@gmail.com NaN NaN NaN NaN NaN \n", "20 Akhilrock108@gmail.com NaN NaN NaN NaN NaN \n", "21 NaN NaN NaN NaN NaN \n", "22 NaN NaN NaN NaN NaN \n", "23 NaN NaN NaN NaN NaN \n", "24 akramkhhan111@gmail.com NaN NaN NaN NaN NaN \n", "25 NaN NaN NaN NaN NaN \n", "26 NaN NaN NaN NaN NaN \n", "27 NaN NaN NaN NaN NaN \n", "28 amar.galidevara@gmail.com NaN NaN NaN NaN NaN \n", "29 amazingsrinidhi@gmail.com NaN NaN NaN NaN NaN \n", "... ... .. ... ... .. ... \n", "3908 neelirotuvenky333@gmail.com NaN NaN NaN NaN NaN \n", "3909 Nagreddy.1992@gmail.com NaN NaN NaN NaN NaN \n", "3910 y_naveen_81@yahoo.com NaN NaN NaN NaN NaN \n", "3911 neelima.lakshmi545@gmail.com NaN NaN NaN NaN NaN \n", "3912 fihaham@mailsdfsdf.com NaN NaN NaN NaN NaN \n", "3913 praful.yadav86@yahoo.com NaN NaN NaN NaN NaN \n", "3914 paspnaidu@aol.com NaN NaN NaN NaN NaN \n", "3915 punitpushkar.k@gmail.com NaN NaN NaN NaN NaN \n", "3916 bharat.vangala@gmail.com NaN NaN NaN NaN NaN \n", "3917 raja.kola@Invesco.com NaN NaN NaN NaN NaN \n", "3918 kamanchi.babu@sbhyd.co.in NaN NaN NaN NaN NaN \n", "3919 reddybcs@yahoo.com NaN NaN NaN NaN NaN \n", "3920 NaN NaN NaN NaN NaN \n", "3921 sylmenipin1990@sorimail.com NaN NaN NaN NaN NaN \n", "3922 s.sadanreddy57@gmail.com NaN NaN NaN NaN NaN \n", "3923 guttapati2001@yahoo.com NaN NaN NaN NaN NaN \n", "3924 sheik.sadiq6@gmail.com NaN NaN NaN NaN NaN \n", "3925 sharma.medavarapu@gmail.com NaN NaN NaN NaN NaN \n", "3926 Sjbdarocker@gmail.com NaN NaN NaN NaN NaN \n", "3927 YADAV.SREENIVAS609@GMAIL.COM NaN NaN NaN NaN NaN \n", "3928 NaN NaN NaN NaN NaN \n", "3929 sunil.stephen@hotmail.com NaN NaN NaN NaN NaN \n", "3930 rasalasurya5844@gmail.com NaN NaN NaN NaN NaN \n", "3931 user1@bazatver.ru NaN NaN NaN NaN NaN \n", "3932 silvermanjoseph@mail.ru NaN NaN NaN NaN NaN \n", "3933 or16@keely.johanna.chicagoimap.top NaN NaN NaN NaN NaN \n", "3934 vamshi131286@Gmail.com NaN NaN NaN NaN NaN \n", "3935 vinithcvsr@gmail.com NaN NaN NaN NaN NaN \n", "3936 zaheerdz@gmail.comK NaN NaN NaN NaN NaN \n", "3937 k.myilswamy@gmail.com NaN NaN NaN NaN NaN \n", "\n", "[3938 rows x 11 columns]" ] }, "execution_count": 72, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.columns=('Name','Age','Blood Group','Address','Contact Number','E-Mail','c1','c2','c3','c4','c5')\n", "df" ] }, { "cell_type": "code", "execution_count": 73, "metadata": {}, "outputs": [], "source": [ "df2 = pd.read_csv(\"BLOOD.csv\")\n", "df2.columns=[\"Name\",'Age','Blood Group','Contact Number','Address']\n", "columnsTitles=['Name','Age',\"Blood Group\",\"Address\",\"Contact Number\"]\n", "df2=df2.reindex(columns=columnsTitles)\n", "\n", "df3 = pd.read_csv(\"bloood.csv\")\n", "df3.columns=[\"Name\",'Age','Blood Group','Contact Number','Address']\n", "columnsTitles=['Name','Age',\"Blood Group\",\"Address\",\"Contact Number\"]\n", "df3=df3.reindex(columns=columnsTitles)\n", "\n", "df4 = pd.read_csv(\"Blood(1).csv\")\n", "df4.columns=[\"Name\",'Contact Number','Age','Blood Group','Address']\n", "columnsTitles=['Name','Age',\"Blood Group\",\"Address\",\"Contact Number\"]\n", "df4=df4.reindex(columns=columnsTitles)\n", "\n", "kf = pd.read_csv(\"Kblood.csv\")\n", "kf.columns=['Name','Age','Blood Group','Address','Contact Number','E-mail','c1','c2','c3','c4','c5']\n" ] }, { "cell_type": "code", "execution_count": 74, "metadata": {}, "outputs": [], "source": [ "del df['c1']\n", "del df['c2']\n", "del df['c3']\n", "del df['c4']\n", "del df['c5']\n", "\n", "del kf['c1']\n", "del kf['c2']\n", "del kf['c3']\n", "del kf['c4']\n", "del kf['c5']\n", "del kf['E-mail']" ] }, { "cell_type": "code", "execution_count": 75, "metadata": {}, "outputs": [ { "data": { "text/plain": [ "(3938, 6)" ] }, "execution_count": 75, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.shape\n" ] }, { "cell_type": "code", "execution_count": 76, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Bheemrao Gajjela25.0A+Bellampalli Dist: ADILABAD9032369640
1chunarkar rajkumar21.0A+2-108/2/a near AMS school asifabad Dist: ADILABAD9642898908
2Pallikonda Dayakar30.0A+00000000 Dist: ADILABAD9703133426
3Koli Praneeth Kumar32.0A+Hno 5-667 INDIRANAGAR MANCHERIAL 504208 Dist: ...9908923700
4SUNITHA JHANSI28.0A+BELLAMPALLI ADILABAD DIST Dist: ADILABAD9177215594
5ArchiesAF ArchiesAF0.0A-Dist: ADILABAD
6darji mayuri21.0A-dariapur Dist: ADILABAD9374597307
7iqofasuy iqofasuy0.0A-Dist: ADILABAD
8Rajeshwar Rao Sangviker48.0A-H.No.15/B, A.P.H.B.COLONY,NIRMAL Dist: ADILABAD9000002112
9Steklobanki-biark Steklobanki-biark0.0A-Dist: ADILABAD
10upoyigi upoyigi0.0A-Dist: ADILABAD
11urehomxdawogu urehomxdawogu0.0A-Dist: ADILABAD
12Zorupn Zorupn0.0A-Dist: ADILABAD
15BANDU PATIL29.0AB+dharbaji ginning factry bhainsa Dist: ADILABAD8978327272
16ugly lallu24.0AB+mandamaeri Dist: ADILABAD8309791152
17ekjaudu ekjaudu0.0AB+Dist: ADILABAD
18HiltonGeoro HiltonGeoro0.0AB+Dist: ADILABAD
19inapugefugij inapugefugij0.0AB+Dist: ADILABAD
20Kellyrek Kellyrek0.0AB+Dist: ADILABAD
21Pradeep Lallu19.0AB+Mandamarri Q.No 525 Station Road Dist: ADILABAD9949167108
22Markemorn Markemorn0.0AB+Dist: ADILABAD
23SandraRib SandraRib0.0AB+Dist: ADILABAD
24sanjay alluri29.0AB+7-7-44/13 Dist: ADILABAD9491345760
25arpinteyroggf carpinteyroggf0.0B+Dist: ADILABAD
26Chakradhar Tiruttullai20.0B+Reddy Colony Dist: ADILABAD8341614229
27Chakradhar Tiruttullai21.0B+Reddy Colony, Mancherial Dist: ADILABAD8341614229
28FernayzGah FernayzGah0.0B+Dist: ADILABAD
29lotsandTrvag lotsandTrvag0.0B+Dist: ADILABAD
30manasa sunke21.0B+ccc naspur mancherial adilabad Dist: ADILABAD7893406162
31ohecagegivifu ohecagegivifu0.0B+Dist: ADILABAD
..................
1150Pothu Chandrashekar38.0A+H.no. 11-18-563, socity colony, kasibugga, war...9866162552
1151Rajesh Kankala29.0A+#17-7-171/a,orus,kareemabad warangal Dist: WAR...8618401683
1152tandoori saikiran22.0A+warangal Dist: WARANGAL9490790279
1153Mohammed sharukh24.0A+#1-5-135 jubilee market kazipet Dist: WARANGAL8790348034
1154Upender Rachakonda29.0A+thorrur. Dist: WARANGAL9963256976
1155jukeshwar goud25.0A-2-9-171,vikasnagar,hanamkonda,warangal Dist: W...9959025014
1156Abhilash Uppala20.0B+18-69/a,cherial,warangal Dist: WARANGAL8143806704
1157ADHI s30.0B+kukatpally Dist: WARANGAL7386635333
1158AllenAroub AllenAroub0.0B+Dist: WARANGAL
1159chaitanyakumar Thota35.0B+Madikonda Dist: WARANGAL9989126555
1160eweteop eweteop0.0B+Dist: WARANGAL
1161Gyan Deep24.0B+9-1-188/S/303, Kakatiya Towers Dist: WARANGAL9000364073
1162VENKATA HARI KRISHNA KANNURI21.0B+5-12-47,opposite hanumantemple,kuc road,hanamk...9700750915
1163AQEEB SHOYAB PASHA MOHAMMAD22.0B+h.no:5-47/3, sai ganesh colony kashibugga wara...9666359357
1164Pradyumna Bhasyakarla21.0B+H.no 16-3-528/A,ekashila nagar,warangal Dist: ...8686733639
1165raja siraboina22.0B+east fort Dist: WARANGAL9177972080
1166Rajnikanth Soorineni32.0B+Choutapally, Parvathagiri, warangal Dist: WARA...9989770324
1167rakesh banoth26.0B+revenue colony Dist: WARANGAL9299652313
1168Shameem Shaik28.0B+kazipet Dist: WARANGAL9866921283
1169SravanKumar Bayagani25.0B+36-9-43 WARANGAL Dist: WARANGAL9533557520
1170Karnataka Sravankumar26.0B+SP office Warangal Dist: WARANGAL9177825383
1171sunil poshala25.0B+chintal basti,khairatabad Dist: WARANGAL9390102285
1172P RAJU28.0O+HYD Dist: WARANGAL8179204343
1173prelizna prelizna0.0O+Dist: WARANGAL
1174SexcamsChic SexcamsChic0.0O+Dist: WARANGAL
1175venkata ramana dodda22.0O+plot no:326 krishna colony bhupalpally waranga...9948657545
1176vijay Kumar25.0O+46-1-269,enumamula , hanamkonda Warangal Dist:...9100256983
1177Thumma Vijaya anand reddy21.0O+Jangaon Dist: WARANGAL7673971823
1178ravula vinayreddy24.0O-5-5-18;kesamudram warangal Dist: WARANGAL9848633766
1179prashanth reddy21.0O-hanamkonda warangaL Dist: WARANGAL8500499112
\n", "

1178 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Bheemrao Gajjela 25.0 A+ \n", "1 chunarkar rajkumar 21.0 A+ \n", "2 Pallikonda Dayakar 30.0 A+ \n", "3 Koli Praneeth Kumar 32.0 A+ \n", "4 SUNITHA JHANSI 28.0 A+ \n", "5 ArchiesAF ArchiesAF 0.0 A- \n", "6 darji mayuri 21.0 A- \n", "7 iqofasuy iqofasuy 0.0 A- \n", "8 Rajeshwar Rao Sangviker 48.0 A- \n", "9 Steklobanki-biark Steklobanki-biark 0.0 A- \n", "10 upoyigi upoyigi 0.0 A- \n", "11 urehomxdawogu urehomxdawogu 0.0 A- \n", "12 Zorupn Zorupn 0.0 A- \n", "15 BANDU PATIL 29.0 AB+ \n", "16 ugly lallu 24.0 AB+ \n", "17 ekjaudu ekjaudu 0.0 AB+ \n", "18 HiltonGeoro HiltonGeoro 0.0 AB+ \n", "19 inapugefugij inapugefugij 0.0 AB+ \n", "20 Kellyrek Kellyrek 0.0 AB+ \n", "21 Pradeep Lallu 19.0 AB+ \n", "22 Markemorn Markemorn 0.0 AB+ \n", "23 SandraRib SandraRib 0.0 AB+ \n", "24 sanjay alluri 29.0 AB+ \n", "25 arpinteyroggf carpinteyroggf 0.0 B+ \n", "26 Chakradhar Tiruttullai 20.0 B+ \n", "27 Chakradhar Tiruttullai 21.0 B+ \n", "28 FernayzGah FernayzGah 0.0 B+ \n", "29 lotsandTrvag lotsandTrvag 0.0 B+ \n", "30 manasa sunke 21.0 B+ \n", "31 ohecagegivifu ohecagegivifu 0.0 B+ \n", "... ... ... ... \n", "1150 Pothu Chandrashekar 38.0 A+ \n", "1151 Rajesh Kankala 29.0 A+ \n", "1152 tandoori saikiran 22.0 A+ \n", "1153 Mohammed sharukh 24.0 A+ \n", "1154 Upender Rachakonda 29.0 A+ \n", "1155 jukeshwar goud 25.0 A- \n", "1156 Abhilash Uppala 20.0 B+ \n", "1157 ADHI s 30.0 B+ \n", "1158 AllenAroub AllenAroub 0.0 B+ \n", "1159 chaitanyakumar Thota 35.0 B+ \n", "1160 eweteop eweteop 0.0 B+ \n", "1161 Gyan Deep 24.0 B+ \n", "1162 VENKATA HARI KRISHNA KANNURI 21.0 B+ \n", "1163 AQEEB SHOYAB PASHA MOHAMMAD 22.0 B+ \n", "1164 Pradyumna Bhasyakarla 21.0 B+ \n", "1165 raja siraboina 22.0 B+ \n", "1166 Rajnikanth Soorineni 32.0 B+ \n", "1167 rakesh banoth 26.0 B+ \n", "1168 Shameem Shaik 28.0 B+ \n", "1169 SravanKumar Bayagani 25.0 B+ \n", "1170 Karnataka Sravankumar 26.0 B+ \n", "1171 sunil poshala 25.0 B+ \n", "1172 P RAJU 28.0 O+ \n", "1173 prelizna prelizna 0.0 O+ \n", "1174 SexcamsChic SexcamsChic 0.0 O+ \n", "1175 venkata ramana dodda 22.0 O+ \n", "1176 vijay Kumar 25.0 O+ \n", "1177 Thumma Vijaya anand reddy 21.0 O+ \n", "1178 ravula vinayreddy 24.0 O- \n", "1179 prashanth reddy 21.0 O- \n", "\n", " Address Contact Number \n", "0 Bellampalli Dist: ADILABAD 9032369640 \n", "1 2-108/2/a near AMS school asifabad Dist: ADILABAD 9642898908 \n", "2 00000000 Dist: ADILABAD 9703133426 \n", "3 Hno 5-667 INDIRANAGAR MANCHERIAL 504208 Dist: ... 9908923700 \n", "4 BELLAMPALLI ADILABAD DIST Dist: ADILABAD 9177215594 \n", "5 Dist: ADILABAD \n", "6 dariapur Dist: ADILABAD 9374597307 \n", "7 Dist: ADILABAD \n", "8 H.No.15/B, A.P.H.B.COLONY,NIRMAL Dist: ADILABAD 9000002112 \n", "9 Dist: ADILABAD \n", "10 Dist: ADILABAD \n", "11 Dist: ADILABAD \n", "12 Dist: ADILABAD \n", "15 dharbaji ginning factry bhainsa Dist: ADILABAD 8978327272 \n", "16 mandamaeri Dist: ADILABAD 8309791152 \n", "17 Dist: ADILABAD \n", "18 Dist: ADILABAD \n", "19 Dist: ADILABAD \n", "20 Dist: ADILABAD \n", "21 Mandamarri Q.No 525 Station Road Dist: ADILABAD 9949167108 \n", "22 Dist: ADILABAD \n", "23 Dist: ADILABAD \n", "24 7-7-44/13 Dist: ADILABAD 9491345760 \n", "25 Dist: ADILABAD \n", "26 Reddy Colony Dist: ADILABAD 8341614229 \n", "27 Reddy Colony, Mancherial Dist: ADILABAD 8341614229 \n", "28 Dist: ADILABAD \n", "29 Dist: ADILABAD \n", "30 ccc naspur mancherial adilabad Dist: ADILABAD 7893406162 \n", "31 Dist: ADILABAD \n", "... ... ... \n", "1150 H.no. 11-18-563, socity colony, kasibugga, war... 9866162552 \n", "1151 #17-7-171/a,orus,kareemabad warangal Dist: WAR... 8618401683 \n", "1152 warangal Dist: WARANGAL 9490790279 \n", "1153 #1-5-135 jubilee market kazipet Dist: WARANGAL 8790348034 \n", "1154 thorrur. Dist: WARANGAL 9963256976 \n", "1155 2-9-171,vikasnagar,hanamkonda,warangal Dist: W... 9959025014 \n", "1156 18-69/a,cherial,warangal Dist: WARANGAL 8143806704 \n", "1157 kukatpally Dist: WARANGAL 7386635333 \n", "1158 Dist: WARANGAL \n", "1159 Madikonda Dist: WARANGAL 9989126555 \n", "1160 Dist: WARANGAL \n", "1161 9-1-188/S/303, Kakatiya Towers Dist: WARANGAL 9000364073 \n", "1162 5-12-47,opposite hanumantemple,kuc road,hanamk... 9700750915 \n", "1163 h.no:5-47/3, sai ganesh colony kashibugga wara... 9666359357 \n", "1164 H.no 16-3-528/A,ekashila nagar,warangal Dist: ... 8686733639 \n", "1165 east fort Dist: WARANGAL 9177972080 \n", "1166 Choutapally, Parvathagiri, warangal Dist: WARA... 9989770324 \n", "1167 revenue colony Dist: WARANGAL 9299652313 \n", "1168 kazipet Dist: WARANGAL 9866921283 \n", "1169 36-9-43 WARANGAL Dist: WARANGAL 9533557520 \n", "1170 SP office Warangal Dist: WARANGAL 9177825383 \n", "1171 chintal basti,khairatabad Dist: WARANGAL 9390102285 \n", "1172 HYD Dist: WARANGAL 8179204343 \n", "1173 Dist: WARANGAL \n", "1174 Dist: WARANGAL \n", "1175 plot no:326 krishna colony bhupalpally waranga... 9948657545 \n", "1176 46-1-269,enumamula , hanamkonda Warangal Dist:... 9100256983 \n", "1177 Jangaon Dist: WARANGAL 7673971823 \n", "1178 5-5-18;kesamudram warangal Dist: WARANGAL 9848633766 \n", "1179 hanamkonda warangaL Dist: WARANGAL 8500499112 \n", "\n", "[1178 rows x 5 columns]" ] }, "execution_count": 76, "metadata": {}, "output_type": "execute_result" } ], "source": [ "kf.replace('', np.nan, inplace=True)\n", "kf.dropna(inplace = True)\n", "kf" ] }, { "cell_type": "code", "execution_count": 77, "metadata": {}, "outputs": [], "source": [ "kf.Age = kf.Age.astype('int64') " ] }, { "cell_type": "code", "execution_count": 78, "metadata": {}, "outputs": [], "source": [ "kf = kf[kf.Age != 0]" ] }, { "cell_type": "code", "execution_count": 79, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Bheemrao Gajjela25A+Bellampalli Dist: ADILABAD9032369640
1chunarkar rajkumar21A+2-108/2/a near AMS school asifabad Dist: ADILABAD9642898908
2Pallikonda Dayakar30A+00000000 Dist: ADILABAD9703133426
3Koli Praneeth Kumar32A+Hno 5-667 INDIRANAGAR MANCHERIAL 504208 Dist: ...9908923700
4SUNITHA JHANSI28A+BELLAMPALLI ADILABAD DIST Dist: ADILABAD9177215594
6darji mayuri21A-dariapur Dist: ADILABAD9374597307
8Rajeshwar Rao Sangviker48A-H.No.15/B, A.P.H.B.COLONY,NIRMAL Dist: ADILABAD9000002112
15BANDU PATIL29AB+dharbaji ginning factry bhainsa Dist: ADILABAD8978327272
16ugly lallu24AB+mandamaeri Dist: ADILABAD8309791152
21Pradeep Lallu19AB+Mandamarri Q.No 525 Station Road Dist: ADILABAD9949167108
24sanjay alluri29AB+7-7-44/13 Dist: ADILABAD9491345760
26Chakradhar Tiruttullai20B+Reddy Colony Dist: ADILABAD8341614229
27Chakradhar Tiruttullai21B+Reddy Colony, Mancherial Dist: ADILABAD8341614229
30manasa sunke21B+ccc naspur mancherial adilabad Dist: ADILABAD7893406162
32prakash kota31B+adilabad Dist: ADILABAD9866581110
35ayan ahmed31B+4.3.58/34d bhainsa Dist: ADILABAD9848523920
36Sunayana22B+Q.No:587,GoletiTownShip,Rebbena,Komarm bheem D...7382345727
38Chakradhar Tiruttullai20B+Reddy Colony Dist: ADILABAD8341614229
43Yashwanth S27B+Kannalabasthi,bellampalli,Mancherial,Telangana...9700772734
44sharath chandra21O+H.no:15-195 near water tank old mancherial,mnc...8885243414
45nimmarajula sravan kumar22O+h.no:15-285 old mancherial,mancherial,adilabad...8143612858
46Nikhil Kumar Sustarwar24O+H.No 5-1-16, Brahmanwada, Adilabad Dist: ADILABAD9032693093
47kothuru Maheshwar27O-vanasthalipuram hyd Dist: ADILABAD9912348179
48nagaraju earla25O-rkp, mancherial Dist: ADILABAD9989616107
51Bhukya Thirupathi Nayak22O-University of Hyderabad Dist: ADILABAD9440587441
52prasanna kumar dasari19A+guntakal Dist: ANANTAPUR9494009020
53nagendra babu25A+dharmavaram Dist: ANANTAPUR9642336393
54balam vishwanath27A+navodaya ortho care,hindupur Dist: ANANTAPUR9676066876
55Ram charan24AB+Tadiparthi Dist: ANANTAPUR9989846564
56Tallapalli Anjanesh Reddy25B+6-5-220, Ram nagar, Anantapur Dist: ANANTAPUR9966118633
..................
1146NAVEEN KUMAR24O+Datti rajeru, Vizianagaram Dist: VIZIANAGARAM9676279814
1147Pothu Chandrashekar38A+H.no. 11-18-563, socity colony, kasibugga, war...9866162552
1148kushal kumar durgam23A+himayatnagar,hyd Dist: WARANGAL9700733556
1149MURALI DHAR DALIA34A+8-4-49,sri krishna colony Dist: WARANGAL7013805966
1150Pothu Chandrashekar38A+H.no. 11-18-563, socity colony, kasibugga, war...9866162552
1151Rajesh Kankala29A+#17-7-171/a,orus,kareemabad warangal Dist: WAR...8618401683
1152tandoori saikiran22A+warangal Dist: WARANGAL9490790279
1153Mohammed sharukh24A+#1-5-135 jubilee market kazipet Dist: WARANGAL8790348034
1154Upender Rachakonda29A+thorrur. Dist: WARANGAL9963256976
1155jukeshwar goud25A-2-9-171,vikasnagar,hanamkonda,warangal Dist: W...9959025014
1156Abhilash Uppala20B+18-69/a,cherial,warangal Dist: WARANGAL8143806704
1157ADHI s30B+kukatpally Dist: WARANGAL7386635333
1159chaitanyakumar Thota35B+Madikonda Dist: WARANGAL9989126555
1161Gyan Deep24B+9-1-188/S/303, Kakatiya Towers Dist: WARANGAL9000364073
1162VENKATA HARI KRISHNA KANNURI21B+5-12-47,opposite hanumantemple,kuc road,hanamk...9700750915
1163AQEEB SHOYAB PASHA MOHAMMAD22B+h.no:5-47/3, sai ganesh colony kashibugga wara...9666359357
1164Pradyumna Bhasyakarla21B+H.no 16-3-528/A,ekashila nagar,warangal Dist: ...8686733639
1165raja siraboina22B+east fort Dist: WARANGAL9177972080
1166Rajnikanth Soorineni32B+Choutapally, Parvathagiri, warangal Dist: WARA...9989770324
1167rakesh banoth26B+revenue colony Dist: WARANGAL9299652313
1168Shameem Shaik28B+kazipet Dist: WARANGAL9866921283
1169SravanKumar Bayagani25B+36-9-43 WARANGAL Dist: WARANGAL9533557520
1170Karnataka Sravankumar26B+SP office Warangal Dist: WARANGAL9177825383
1171sunil poshala25B+chintal basti,khairatabad Dist: WARANGAL9390102285
1172P RAJU28O+HYD Dist: WARANGAL8179204343
1175venkata ramana dodda22O+plot no:326 krishna colony bhupalpally waranga...9948657545
1176vijay Kumar25O+46-1-269,enumamula , hanamkonda Warangal Dist:...9100256983
1177Thumma Vijaya anand reddy21O+Jangaon Dist: WARANGAL7673971823
1178ravula vinayreddy24O-5-5-18;kesamudram warangal Dist: WARANGAL9848633766
1179prashanth reddy21O-hanamkonda warangaL Dist: WARANGAL8500499112
\n", "

924 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Bheemrao Gajjela 25 A+ \n", "1 chunarkar rajkumar 21 A+ \n", "2 Pallikonda Dayakar 30 A+ \n", "3 Koli Praneeth Kumar 32 A+ \n", "4 SUNITHA JHANSI 28 A+ \n", "6 darji mayuri 21 A- \n", "8 Rajeshwar Rao Sangviker 48 A- \n", "15 BANDU PATIL 29 AB+ \n", "16 ugly lallu 24 AB+ \n", "21 Pradeep Lallu 19 AB+ \n", "24 sanjay alluri 29 AB+ \n", "26 Chakradhar Tiruttullai 20 B+ \n", "27 Chakradhar Tiruttullai 21 B+ \n", "30 manasa sunke 21 B+ \n", "32 prakash kota 31 B+ \n", "35 ayan ahmed 31 B+ \n", "36 Sunayana 22 B+ \n", "38 Chakradhar Tiruttullai 20 B+ \n", "43 Yashwanth S 27 B+ \n", "44 sharath chandra 21 O+ \n", "45 nimmarajula sravan kumar 22 O+ \n", "46 Nikhil Kumar Sustarwar 24 O+ \n", "47 kothuru Maheshwar 27 O- \n", "48 nagaraju earla 25 O- \n", "51 Bhukya Thirupathi Nayak 22 O- \n", "52 prasanna kumar dasari 19 A+ \n", "53 nagendra babu 25 A+ \n", "54 balam vishwanath 27 A+ \n", "55 Ram charan 24 AB+ \n", "56 Tallapalli Anjanesh Reddy 25 B+ \n", "... ... ... ... \n", "1146 NAVEEN KUMAR 24 O+ \n", "1147 Pothu Chandrashekar 38 A+ \n", "1148 kushal kumar durgam 23 A+ \n", "1149 MURALI DHAR DALIA 34 A+ \n", "1150 Pothu Chandrashekar 38 A+ \n", "1151 Rajesh Kankala 29 A+ \n", "1152 tandoori saikiran 22 A+ \n", "1153 Mohammed sharukh 24 A+ \n", "1154 Upender Rachakonda 29 A+ \n", "1155 jukeshwar goud 25 A- \n", "1156 Abhilash Uppala 20 B+ \n", "1157 ADHI s 30 B+ \n", "1159 chaitanyakumar Thota 35 B+ \n", "1161 Gyan Deep 24 B+ \n", "1162 VENKATA HARI KRISHNA KANNURI 21 B+ \n", "1163 AQEEB SHOYAB PASHA MOHAMMAD 22 B+ \n", "1164 Pradyumna Bhasyakarla 21 B+ \n", "1165 raja siraboina 22 B+ \n", "1166 Rajnikanth Soorineni 32 B+ \n", "1167 rakesh banoth 26 B+ \n", "1168 Shameem Shaik 28 B+ \n", "1169 SravanKumar Bayagani 25 B+ \n", "1170 Karnataka Sravankumar 26 B+ \n", "1171 sunil poshala 25 B+ \n", "1172 P RAJU 28 O+ \n", "1175 venkata ramana dodda 22 O+ \n", "1176 vijay Kumar 25 O+ \n", "1177 Thumma Vijaya anand reddy 21 O+ \n", "1178 ravula vinayreddy 24 O- \n", "1179 prashanth reddy 21 O- \n", "\n", " Address Contact Number \n", "0 Bellampalli Dist: ADILABAD 9032369640 \n", "1 2-108/2/a near AMS school asifabad Dist: ADILABAD 9642898908 \n", "2 00000000 Dist: ADILABAD 9703133426 \n", "3 Hno 5-667 INDIRANAGAR MANCHERIAL 504208 Dist: ... 9908923700 \n", "4 BELLAMPALLI ADILABAD DIST Dist: ADILABAD 9177215594 \n", "6 dariapur Dist: ADILABAD 9374597307 \n", "8 H.No.15/B, A.P.H.B.COLONY,NIRMAL Dist: ADILABAD 9000002112 \n", "15 dharbaji ginning factry bhainsa Dist: ADILABAD 8978327272 \n", "16 mandamaeri Dist: ADILABAD 8309791152 \n", "21 Mandamarri Q.No 525 Station Road Dist: ADILABAD 9949167108 \n", "24 7-7-44/13 Dist: ADILABAD 9491345760 \n", "26 Reddy Colony Dist: ADILABAD 8341614229 \n", "27 Reddy Colony, Mancherial Dist: ADILABAD 8341614229 \n", "30 ccc naspur mancherial adilabad Dist: ADILABAD 7893406162 \n", "32 adilabad Dist: ADILABAD 9866581110 \n", "35 4.3.58/34d bhainsa Dist: ADILABAD 9848523920 \n", "36 Q.No:587,GoletiTownShip,Rebbena,Komarm bheem D... 7382345727 \n", "38 Reddy Colony Dist: ADILABAD 8341614229 \n", "43 Kannalabasthi,bellampalli,Mancherial,Telangana... 9700772734 \n", "44 H.no:15-195 near water tank old mancherial,mnc... 8885243414 \n", "45 h.no:15-285 old mancherial,mancherial,adilabad... 8143612858 \n", "46 H.No 5-1-16, Brahmanwada, Adilabad Dist: ADILABAD 9032693093 \n", "47 vanasthalipuram hyd Dist: ADILABAD 9912348179 \n", "48 rkp, mancherial Dist: ADILABAD 9989616107 \n", "51 University of Hyderabad Dist: ADILABAD 9440587441 \n", "52 guntakal Dist: ANANTAPUR 9494009020 \n", "53 dharmavaram Dist: ANANTAPUR 9642336393 \n", "54 navodaya ortho care,hindupur Dist: ANANTAPUR 9676066876 \n", "55 Tadiparthi Dist: ANANTAPUR 9989846564 \n", "56 6-5-220, Ram nagar, Anantapur Dist: ANANTAPUR 9966118633 \n", "... ... ... \n", "1146 Datti rajeru, Vizianagaram Dist: VIZIANAGARAM 9676279814 \n", "1147 H.no. 11-18-563, socity colony, kasibugga, war... 9866162552 \n", "1148 himayatnagar,hyd Dist: WARANGAL 9700733556 \n", "1149 8-4-49,sri krishna colony Dist: WARANGAL 7013805966 \n", "1150 H.no. 11-18-563, socity colony, kasibugga, war... 9866162552 \n", "1151 #17-7-171/a,orus,kareemabad warangal Dist: WAR... 8618401683 \n", "1152 warangal Dist: WARANGAL 9490790279 \n", "1153 #1-5-135 jubilee market kazipet Dist: WARANGAL 8790348034 \n", "1154 thorrur. Dist: WARANGAL 9963256976 \n", "1155 2-9-171,vikasnagar,hanamkonda,warangal Dist: W... 9959025014 \n", "1156 18-69/a,cherial,warangal Dist: WARANGAL 8143806704 \n", "1157 kukatpally Dist: WARANGAL 7386635333 \n", "1159 Madikonda Dist: WARANGAL 9989126555 \n", "1161 9-1-188/S/303, Kakatiya Towers Dist: WARANGAL 9000364073 \n", "1162 5-12-47,opposite hanumantemple,kuc road,hanamk... 9700750915 \n", "1163 h.no:5-47/3, sai ganesh colony kashibugga wara... 9666359357 \n", "1164 H.no 16-3-528/A,ekashila nagar,warangal Dist: ... 8686733639 \n", "1165 east fort Dist: WARANGAL 9177972080 \n", "1166 Choutapally, Parvathagiri, warangal Dist: WARA... 9989770324 \n", "1167 revenue colony Dist: WARANGAL 9299652313 \n", "1168 kazipet Dist: WARANGAL 9866921283 \n", "1169 36-9-43 WARANGAL Dist: WARANGAL 9533557520 \n", "1170 SP office Warangal Dist: WARANGAL 9177825383 \n", "1171 chintal basti,khairatabad Dist: WARANGAL 9390102285 \n", "1172 HYD Dist: WARANGAL 8179204343 \n", "1175 plot no:326 krishna colony bhupalpally waranga... 9948657545 \n", "1176 46-1-269,enumamula , hanamkonda Warangal Dist:... 9100256983 \n", "1177 Jangaon Dist: WARANGAL 7673971823 \n", "1178 5-5-18;kesamudram warangal Dist: WARANGAL 9848633766 \n", "1179 hanamkonda warangaL Dist: WARANGAL 8500499112 \n", "\n", "[924 rows x 5 columns]" ] }, "execution_count": 79, "metadata": {}, "output_type": "execute_result" } ], "source": [ "kf" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 80, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeAddressContact NumberE-Mail
Blood Group
A+997997997997987
A-145145145145140
A1+55555
A1B+33332
A2+11111
AB+435435435435427
AB-6363636363
Anuj Kherde01111
B+12791279127912791266
B-169169169169169
O+528528528528524
O-297297297297296
\n", "
" ], "text/plain": [ " Name Age Address Contact Number E-Mail\n", "Blood Group \n", "A+ 997 997 997 997 987\n", "A- 145 145 145 145 140\n", "A1+ 5 5 5 5 5\n", "A1B+ 3 3 3 3 2\n", "A2+ 1 1 1 1 1\n", "AB+ 435 435 435 435 427\n", "AB- 63 63 63 63 63\n", "Anuj Kherde 0 1 1 1 1\n", "B+ 1279 1279 1279 1279 1266\n", "B- 169 169 169 169 169\n", "O+ 528 528 528 528 524\n", "O- 297 297 297 297 296" ] }, "execution_count": 80, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df.groupby(\"Blood Group\").count()" ] }, { "cell_type": "code", "execution_count": 81, "metadata": {}, "outputs": [], "source": [ "del df['E-Mail']" ] }, { "cell_type": "code", "execution_count": 82, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Vijay Mehta32A+Begumpet HYDERABAD9848584529
1Arindam Deka25A+Kondapur HYDERABAD8125298304
2alluri babul reddy27A+plot no 96/b HYDERABAD9642244070
3Kiran Swamy .A34A+hyderabad HYDERABAD9963339200
4a prasad26A+prem nagar,khairathabad. HYDERABAD9032032310
5Abdul Rahman25A+Santosh nagar HYDERABAD9642692545
6Abhilash reddy24A+Gandhinagar HYDERABAD8801770077
7ABHIJIT JEETU21A+Hyderabad Central University HYDERABAD9966362080
8abhinay barla21A+1-1-304, road no 6, balaji colony mohan nagar ...8125950302
9abhishek bhoreddy28A+H: 1-53, flat no 208, sai residency,Madinaguda...9885902222
10Achutha Prasad24A+No 16, 3rd floor, Rahul colony, Tolichowki. HY...9342757176
11A CHANDRA OBULA REDD26A+hydrabad HYDERABAD9550481780
12rajesh kumar28A+2-21, ram nagar. hyderabad HYDERABAD7075009449
13Aditi Ainapure22A+Nehru Gunj Kalaburagi, Karnataka HYDERABAD9113946610
14raj agarwal41A+sanathnagar HYDERABAD9494394592
15agarwal rajesh41A+sanathnagar HYDERABAD9494394592
16Veljala Agnivesh0A+24 1 jnnurm colony peerancheruvu HYDERABAD9573344319
17Ajay Chenigunta25A+09642549475 HYDERABAD9642549475
18sri ranjitha kulakarni30A+Flat No.401, ranjita residency,kphb HYDERABAD9848022338
19Ravikiran Akella30A+Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY...9000277678
20Akhil Kumar20A+Sathish Nagar colony near bustand nalgonda HYD...9182538554
21Akhil20A+Nagole HYDERABAD9618106017
22Akhilesh25A+3-4-369/4/b, krishna nagar, bholakpur HYDERABAD8686299309
23ganesh yyadav23A+kukatpally HYDERABAD7702120996
24akram khan30A+srt 68 HYDERABAD9963110557
25Alekhya Pinnamaneni21A+7-1-282/E, Balkampet, S R Nagar, hyderabad HYD...9550411659
26alizeh shirazi25A+sara homes, upperpally, hyderabad HYDERABAD8686386991
27Prabhu26A+LIngampalli HYDERABAD9900222349
28R S Narayana Galidevara27A+Balaji hills, Nijampet, Hyderabad HYDERABAD1847808911
29Srinidhi Krishnamachary37A+Flat No 201, Plot No 333-335, Sri Sai Hanuma R...9989967895
..................
3908N.venkat Rao23O-No SECUNDERABAD7285910430
3909Nagendra Reddy26O-H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec...8143382248
3910naveen kumar yamsani29O-04023392745 SECUNDERABAD9885344462
3911neelima lakshmi21O-secunderabad SECUNDERABAD9394309995
3912niwaniv niwaniv0O-SECUNDERABAD
3913Praful Yadav28O-sainkpuri SECUNDERABAD8686021042
3914pasp naidu35O-as rao nagar SECUNDERABAD9701171118
3915punit pushkar25O-501, sree ram charan towers, old bowenpally SE...8464038825
3916raghuram vangala30O-ammerpeta SECUNDERABAD9642752360
3917Rajasekhar kola33O-neredmet SECUNDERABAD9989837871
3918KAMANCHI RAM MOHAN BABU37O-c/o sbh msme moulali branch, nfc road moulali,...9010406089
3919Chandra Shekar Reddy Bannur36O-BEGUMPET SECUNDERABAD9052893393
3920Pinks Pinks27O-Secunderabad SECUNDERABAD8885001333
3921RichardMn RichardMn0O-SECUNDERABAD
3922Sadan Reddy S21O-secunderabad SECUNDERABAD9505010085
3923GUTTAPATI SESHAGIRI ACHARYULU39O-FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD9848410346
3924sadiq mohammad25O-tarnaka,secundrabad. SECUNDERABAD9849405373
3925Subrahmanya Sarma M38O-6-1-132/136,Padmarao nagar SECUNDERABAD9000675611
3926Somil Jain23O-ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD7987276603
3927SREENIVAS YADAV23O-09885632631 SECUNDERABAD9885632631
3928Suchan Golla21O-7-741/4,subhash nagar,Hyderabad SECUNDERABAD9701816008
3929Sunil Stephen34O-Secunderabad SECUNDERABAD9502114280
3930Surya Yadav24O-Malkajgiri SECUNDERABAD8186815844
3931Thailandi-Mycle Thailandi-Mycle0O-SECUNDERABAD
3932ThomasDuh ThomasDuh0O-SECUNDERABAD
3933tiffanyxu1 tiffanyxu10O-SECUNDERABAD
3934vamshidhar reddy28O-malkajgiri SECUNDERABAD7799452981
3935vinith reddy20O-b.s nagar, malajgiri,secunderabad SECUNDERABAD7075008899
3936Shaik Zaheer24O-12-1-505, st.no 11 tarnaka. SECUNDERABAD9916411004
3937MYLSAMY35A1B+3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD9700618565
\n", "

3938 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Vijay Mehta 32 A+ \n", "1 Arindam Deka 25 A+ \n", "2 alluri babul reddy 27 A+ \n", "3 Kiran Swamy .A 34 A+ \n", "4 a prasad 26 A+ \n", "5 Abdul Rahman 25 A+ \n", "6 Abhilash reddy 24 A+ \n", "7 ABHIJIT JEETU 21 A+ \n", "8 abhinay barla 21 A+ \n", "9 abhishek bhoreddy 28 A+ \n", "10 Achutha Prasad 24 A+ \n", "11 A CHANDRA OBULA REDD 26 A+ \n", "12 rajesh kumar 28 A+ \n", "13 Aditi Ainapure 22 A+ \n", "14 raj agarwal 41 A+ \n", "15 agarwal rajesh 41 A+ \n", "16 Veljala Agnivesh 0 A+ \n", "17 Ajay Chenigunta 25 A+ \n", "18 sri ranjitha kulakarni 30 A+ \n", "19 Ravikiran Akella 30 A+ \n", "20 Akhil Kumar 20 A+ \n", "21 Akhil 20 A+ \n", "22 Akhilesh 25 A+ \n", "23 ganesh yyadav 23 A+ \n", "24 akram khan 30 A+ \n", "25 Alekhya Pinnamaneni 21 A+ \n", "26 alizeh shirazi 25 A+ \n", "27 Prabhu 26 A+ \n", "28 R S Narayana Galidevara 27 A+ \n", "29 Srinidhi Krishnamachary 37 A+ \n", "... ... .. ... \n", "3908 N.venkat Rao 23 O- \n", "3909 Nagendra Reddy 26 O- \n", "3910 naveen kumar yamsani 29 O- \n", "3911 neelima lakshmi 21 O- \n", "3912 niwaniv niwaniv 0 O- \n", "3913 Praful Yadav 28 O- \n", "3914 pasp naidu 35 O- \n", "3915 punit pushkar 25 O- \n", "3916 raghuram vangala 30 O- \n", "3917 Rajasekhar kola 33 O- \n", "3918 KAMANCHI RAM MOHAN BABU 37 O- \n", "3919 Chandra Shekar Reddy Bannur 36 O- \n", "3920 Pinks Pinks 27 O- \n", "3921 RichardMn RichardMn 0 O- \n", "3922 Sadan Reddy S 21 O- \n", "3923 GUTTAPATI SESHAGIRI ACHARYULU 39 O- \n", "3924 sadiq mohammad 25 O- \n", "3925 Subrahmanya Sarma M 38 O- \n", "3926 Somil Jain 23 O- \n", "3927 SREENIVAS YADAV 23 O- \n", "3928 Suchan Golla 21 O- \n", "3929 Sunil Stephen 34 O- \n", "3930 Surya Yadav 24 O- \n", "3931 Thailandi-Mycle Thailandi-Mycle 0 O- \n", "3932 ThomasDuh ThomasDuh 0 O- \n", "3933 tiffanyxu1 tiffanyxu1 0 O- \n", "3934 vamshidhar reddy 28 O- \n", "3935 vinith reddy 20 O- \n", "3936 Shaik Zaheer 24 O- \n", "3937 MYLSAMY 35 A1B+ \n", "\n", " Address Contact Number \n", "0 Begumpet HYDERABAD 9848584529 \n", "1 Kondapur HYDERABAD 8125298304 \n", "2 plot no 96/b HYDERABAD 9642244070 \n", "3 hyderabad HYDERABAD 9963339200 \n", "4 prem nagar,khairathabad. HYDERABAD 9032032310 \n", "5 Santosh nagar HYDERABAD 9642692545 \n", "6 Gandhinagar HYDERABAD 8801770077 \n", "7 Hyderabad Central University HYDERABAD 9966362080 \n", "8 1-1-304, road no 6, balaji colony mohan nagar ... 8125950302 \n", "9 H: 1-53, flat no 208, sai residency,Madinaguda... 9885902222 \n", "10 No 16, 3rd floor, Rahul colony, Tolichowki. HY... 9342757176 \n", "11 hydrabad HYDERABAD 9550481780 \n", "12 2-21, ram nagar. hyderabad HYDERABAD 7075009449 \n", "13 Nehru Gunj Kalaburagi, Karnataka HYDERABAD 9113946610 \n", "14 sanathnagar HYDERABAD 9494394592 \n", "15 sanathnagar HYDERABAD 9494394592 \n", "16 24 1 jnnurm colony peerancheruvu HYDERABAD 9573344319 \n", "17 09642549475 HYDERABAD 9642549475 \n", "18 Flat No.401, ranjita residency,kphb HYDERABAD 9848022338 \n", "19 Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY... 9000277678 \n", "20 Sathish Nagar colony near bustand nalgonda HYD... 9182538554 \n", "21 Nagole HYDERABAD 9618106017 \n", "22 3-4-369/4/b, krishna nagar, bholakpur HYDERABAD 8686299309 \n", "23 kukatpally HYDERABAD 7702120996 \n", "24 srt 68 HYDERABAD 9963110557 \n", "25 7-1-282/E, Balkampet, S R Nagar, hyderabad HYD... 9550411659 \n", "26 sara homes, upperpally, hyderabad HYDERABAD 8686386991 \n", "27 LIngampalli HYDERABAD 9900222349 \n", "28 Balaji hills, Nijampet, Hyderabad HYDERABAD 1847808911 \n", "29 Flat No 201, Plot No 333-335, Sri Sai Hanuma R... 9989967895 \n", "... ... ... \n", "3908 No SECUNDERABAD 7285910430 \n", "3909 H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec... 8143382248 \n", "3910 04023392745 SECUNDERABAD 9885344462 \n", "3911 secunderabad SECUNDERABAD 9394309995 \n", "3912 SECUNDERABAD \n", "3913 sainkpuri SECUNDERABAD 8686021042 \n", "3914 as rao nagar SECUNDERABAD 9701171118 \n", "3915 501, sree ram charan towers, old bowenpally SE... 8464038825 \n", "3916 ammerpeta SECUNDERABAD 9642752360 \n", "3917 neredmet SECUNDERABAD 9989837871 \n", "3918 c/o sbh msme moulali branch, nfc road moulali,... 9010406089 \n", "3919 BEGUMPET SECUNDERABAD 9052893393 \n", "3920 Secunderabad SECUNDERABAD 8885001333 \n", "3921 SECUNDERABAD \n", "3922 secunderabad SECUNDERABAD 9505010085 \n", "3923 FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD 9848410346 \n", "3924 tarnaka,secundrabad. SECUNDERABAD 9849405373 \n", "3925 6-1-132/136,Padmarao nagar SECUNDERABAD 9000675611 \n", "3926 ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD 7987276603 \n", "3927 09885632631 SECUNDERABAD 9885632631 \n", "3928 7-741/4,subhash nagar,Hyderabad SECUNDERABAD 9701816008 \n", "3929 Secunderabad SECUNDERABAD 9502114280 \n", "3930 Malkajgiri SECUNDERABAD 8186815844 \n", "3931 SECUNDERABAD \n", "3932 SECUNDERABAD \n", "3933 SECUNDERABAD \n", "3934 malkajgiri SECUNDERABAD 7799452981 \n", "3935 b.s nagar, malajgiri,secunderabad SECUNDERABAD 7075008899 \n", "3936 12-1-505, st.no 11 tarnaka. SECUNDERABAD 9916411004 \n", "3937 3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD 9700618565 \n", "\n", "[3938 rows x 5 columns]" ] }, "execution_count": 82, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": 83, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Vijay Mehta32A+Begumpet HYDERABAD9848584529
1Arindam Deka25A+Kondapur HYDERABAD8125298304
2alluri babul reddy27A+plot no 96/b HYDERABAD9642244070
3Kiran Swamy .A34A+hyderabad HYDERABAD9963339200
4a prasad26A+prem nagar,khairathabad. HYDERABAD9032032310
5Abdul Rahman25A+Santosh nagar HYDERABAD9642692545
6Abhilash reddy24A+Gandhinagar HYDERABAD8801770077
7ABHIJIT JEETU21A+Hyderabad Central University HYDERABAD9966362080
8abhinay barla21A+1-1-304, road no 6, balaji colony mohan nagar ...8125950302
9abhishek bhoreddy28A+H: 1-53, flat no 208, sai residency,Madinaguda...9885902222
10Achutha Prasad24A+No 16, 3rd floor, Rahul colony, Tolichowki. HY...9342757176
11A CHANDRA OBULA REDD26A+hydrabad HYDERABAD9550481780
12rajesh kumar28A+2-21, ram nagar. hyderabad HYDERABAD7075009449
13Aditi Ainapure22A+Nehru Gunj Kalaburagi, Karnataka HYDERABAD9113946610
14raj agarwal41A+sanathnagar HYDERABAD9494394592
15agarwal rajesh41A+sanathnagar HYDERABAD9494394592
16Veljala Agnivesh0A+24 1 jnnurm colony peerancheruvu HYDERABAD9573344319
17Ajay Chenigunta25A+09642549475 HYDERABAD9642549475
18sri ranjitha kulakarni30A+Flat No.401, ranjita residency,kphb HYDERABAD9848022338
19Ravikiran Akella30A+Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY...9000277678
20Akhil Kumar20A+Sathish Nagar colony near bustand nalgonda HYD...9182538554
21Akhil20A+Nagole HYDERABAD9618106017
22Akhilesh25A+3-4-369/4/b, krishna nagar, bholakpur HYDERABAD8686299309
23ganesh yyadav23A+kukatpally HYDERABAD7702120996
24akram khan30A+srt 68 HYDERABAD9963110557
25Alekhya Pinnamaneni21A+7-1-282/E, Balkampet, S R Nagar, hyderabad HYD...9550411659
26alizeh shirazi25A+sara homes, upperpally, hyderabad HYDERABAD8686386991
27Prabhu26A+LIngampalli HYDERABAD9900222349
28R S Narayana Galidevara27A+Balaji hills, Nijampet, Hyderabad HYDERABAD1847808911
29Srinidhi Krishnamachary37A+Flat No 201, Plot No 333-335, Sri Sai Hanuma R...9989967895
..................
3908N.venkat Rao23O-No SECUNDERABAD7285910430
3909Nagendra Reddy26O-H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec...8143382248
3910naveen kumar yamsani29O-04023392745 SECUNDERABAD9885344462
3911neelima lakshmi21O-secunderabad SECUNDERABAD9394309995
3912niwaniv niwaniv0O-SECUNDERABAD
3913Praful Yadav28O-sainkpuri SECUNDERABAD8686021042
3914pasp naidu35O-as rao nagar SECUNDERABAD9701171118
3915punit pushkar25O-501, sree ram charan towers, old bowenpally SE...8464038825
3916raghuram vangala30O-ammerpeta SECUNDERABAD9642752360
3917Rajasekhar kola33O-neredmet SECUNDERABAD9989837871
3918KAMANCHI RAM MOHAN BABU37O-c/o sbh msme moulali branch, nfc road moulali,...9010406089
3919Chandra Shekar Reddy Bannur36O-BEGUMPET SECUNDERABAD9052893393
3920Pinks Pinks27O-Secunderabad SECUNDERABAD8885001333
3921RichardMn RichardMn0O-SECUNDERABAD
3922Sadan Reddy S21O-secunderabad SECUNDERABAD9505010085
3923GUTTAPATI SESHAGIRI ACHARYULU39O-FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD9848410346
3924sadiq mohammad25O-tarnaka,secundrabad. SECUNDERABAD9849405373
3925Subrahmanya Sarma M38O-6-1-132/136,Padmarao nagar SECUNDERABAD9000675611
3926Somil Jain23O-ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD7987276603
3927SREENIVAS YADAV23O-09885632631 SECUNDERABAD9885632631
3928Suchan Golla21O-7-741/4,subhash nagar,Hyderabad SECUNDERABAD9701816008
3929Sunil Stephen34O-Secunderabad SECUNDERABAD9502114280
3930Surya Yadav24O-Malkajgiri SECUNDERABAD8186815844
3931Thailandi-Mycle Thailandi-Mycle0O-SECUNDERABAD
3932ThomasDuh ThomasDuh0O-SECUNDERABAD
3933tiffanyxu1 tiffanyxu10O-SECUNDERABAD
3934vamshidhar reddy28O-malkajgiri SECUNDERABAD7799452981
3935vinith reddy20O-b.s nagar, malajgiri,secunderabad SECUNDERABAD7075008899
3936Shaik Zaheer24O-12-1-505, st.no 11 tarnaka. SECUNDERABAD9916411004
3937MYLSAMY35A1B+3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD9700618565
\n", "

3938 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Vijay Mehta 32 A+ \n", "1 Arindam Deka 25 A+ \n", "2 alluri babul reddy 27 A+ \n", "3 Kiran Swamy .A 34 A+ \n", "4 a prasad 26 A+ \n", "5 Abdul Rahman 25 A+ \n", "6 Abhilash reddy 24 A+ \n", "7 ABHIJIT JEETU 21 A+ \n", "8 abhinay barla 21 A+ \n", "9 abhishek bhoreddy 28 A+ \n", "10 Achutha Prasad 24 A+ \n", "11 A CHANDRA OBULA REDD 26 A+ \n", "12 rajesh kumar 28 A+ \n", "13 Aditi Ainapure 22 A+ \n", "14 raj agarwal 41 A+ \n", "15 agarwal rajesh 41 A+ \n", "16 Veljala Agnivesh 0 A+ \n", "17 Ajay Chenigunta 25 A+ \n", "18 sri ranjitha kulakarni 30 A+ \n", "19 Ravikiran Akella 30 A+ \n", "20 Akhil Kumar 20 A+ \n", "21 Akhil 20 A+ \n", "22 Akhilesh 25 A+ \n", "23 ganesh yyadav 23 A+ \n", "24 akram khan 30 A+ \n", "25 Alekhya Pinnamaneni 21 A+ \n", "26 alizeh shirazi 25 A+ \n", "27 Prabhu 26 A+ \n", "28 R S Narayana Galidevara 27 A+ \n", "29 Srinidhi Krishnamachary 37 A+ \n", "... ... .. ... \n", "3908 N.venkat Rao 23 O- \n", "3909 Nagendra Reddy 26 O- \n", "3910 naveen kumar yamsani 29 O- \n", "3911 neelima lakshmi 21 O- \n", "3912 niwaniv niwaniv 0 O- \n", "3913 Praful Yadav 28 O- \n", "3914 pasp naidu 35 O- \n", "3915 punit pushkar 25 O- \n", "3916 raghuram vangala 30 O- \n", "3917 Rajasekhar kola 33 O- \n", "3918 KAMANCHI RAM MOHAN BABU 37 O- \n", "3919 Chandra Shekar Reddy Bannur 36 O- \n", "3920 Pinks Pinks 27 O- \n", "3921 RichardMn RichardMn 0 O- \n", "3922 Sadan Reddy S 21 O- \n", "3923 GUTTAPATI SESHAGIRI ACHARYULU 39 O- \n", "3924 sadiq mohammad 25 O- \n", "3925 Subrahmanya Sarma M 38 O- \n", "3926 Somil Jain 23 O- \n", "3927 SREENIVAS YADAV 23 O- \n", "3928 Suchan Golla 21 O- \n", "3929 Sunil Stephen 34 O- \n", "3930 Surya Yadav 24 O- \n", "3931 Thailandi-Mycle Thailandi-Mycle 0 O- \n", "3932 ThomasDuh ThomasDuh 0 O- \n", "3933 tiffanyxu1 tiffanyxu1 0 O- \n", "3934 vamshidhar reddy 28 O- \n", "3935 vinith reddy 20 O- \n", "3936 Shaik Zaheer 24 O- \n", "3937 MYLSAMY 35 A1B+ \n", "\n", " Address Contact Number \n", "0 Begumpet HYDERABAD 9848584529 \n", "1 Kondapur HYDERABAD 8125298304 \n", "2 plot no 96/b HYDERABAD 9642244070 \n", "3 hyderabad HYDERABAD 9963339200 \n", "4 prem nagar,khairathabad. HYDERABAD 9032032310 \n", "5 Santosh nagar HYDERABAD 9642692545 \n", "6 Gandhinagar HYDERABAD 8801770077 \n", "7 Hyderabad Central University HYDERABAD 9966362080 \n", "8 1-1-304, road no 6, balaji colony mohan nagar ... 8125950302 \n", "9 H: 1-53, flat no 208, sai residency,Madinaguda... 9885902222 \n", "10 No 16, 3rd floor, Rahul colony, Tolichowki. HY... 9342757176 \n", "11 hydrabad HYDERABAD 9550481780 \n", "12 2-21, ram nagar. hyderabad HYDERABAD 7075009449 \n", "13 Nehru Gunj Kalaburagi, Karnataka HYDERABAD 9113946610 \n", "14 sanathnagar HYDERABAD 9494394592 \n", "15 sanathnagar HYDERABAD 9494394592 \n", "16 24 1 jnnurm colony peerancheruvu HYDERABAD 9573344319 \n", "17 09642549475 HYDERABAD 9642549475 \n", "18 Flat No.401, ranjita residency,kphb HYDERABAD 9848022338 \n", "19 Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY... 9000277678 \n", "20 Sathish Nagar colony near bustand nalgonda HYD... 9182538554 \n", "21 Nagole HYDERABAD 9618106017 \n", "22 3-4-369/4/b, krishna nagar, bholakpur HYDERABAD 8686299309 \n", "23 kukatpally HYDERABAD 7702120996 \n", "24 srt 68 HYDERABAD 9963110557 \n", "25 7-1-282/E, Balkampet, S R Nagar, hyderabad HYD... 9550411659 \n", "26 sara homes, upperpally, hyderabad HYDERABAD 8686386991 \n", "27 LIngampalli HYDERABAD 9900222349 \n", "28 Balaji hills, Nijampet, Hyderabad HYDERABAD 1847808911 \n", "29 Flat No 201, Plot No 333-335, Sri Sai Hanuma R... 9989967895 \n", "... ... ... \n", "3908 No SECUNDERABAD 7285910430 \n", "3909 H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec... 8143382248 \n", "3910 04023392745 SECUNDERABAD 9885344462 \n", "3911 secunderabad SECUNDERABAD 9394309995 \n", "3912 SECUNDERABAD \n", "3913 sainkpuri SECUNDERABAD 8686021042 \n", "3914 as rao nagar SECUNDERABAD 9701171118 \n", "3915 501, sree ram charan towers, old bowenpally SE... 8464038825 \n", "3916 ammerpeta SECUNDERABAD 9642752360 \n", "3917 neredmet SECUNDERABAD 9989837871 \n", "3918 c/o sbh msme moulali branch, nfc road moulali,... 9010406089 \n", "3919 BEGUMPET SECUNDERABAD 9052893393 \n", "3920 Secunderabad SECUNDERABAD 8885001333 \n", "3921 SECUNDERABAD \n", "3922 secunderabad SECUNDERABAD 9505010085 \n", "3923 FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD 9848410346 \n", "3924 tarnaka,secundrabad. SECUNDERABAD 9849405373 \n", "3925 6-1-132/136,Padmarao nagar SECUNDERABAD 9000675611 \n", "3926 ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD 7987276603 \n", "3927 09885632631 SECUNDERABAD 9885632631 \n", "3928 7-741/4,subhash nagar,Hyderabad SECUNDERABAD 9701816008 \n", "3929 Secunderabad SECUNDERABAD 9502114280 \n", "3930 Malkajgiri SECUNDERABAD 8186815844 \n", "3931 SECUNDERABAD \n", "3932 SECUNDERABAD \n", "3933 SECUNDERABAD \n", "3934 malkajgiri SECUNDERABAD 7799452981 \n", "3935 b.s nagar, malajgiri,secunderabad SECUNDERABAD 7075008899 \n", "3936 12-1-505, st.no 11 tarnaka. SECUNDERABAD 9916411004 \n", "3937 3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD 9700618565 \n", "\n", "[3938 rows x 5 columns]" ] }, "execution_count": 83, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df" ] }, { "cell_type": "code", "execution_count": 84, "metadata": {}, "outputs": [], "source": [ "#f.drop(df['Contact Number']==NaN)" ] }, { "cell_type": "code", "execution_count": 85, "metadata": {}, "outputs": [], "source": [ "df.replace('', np.nan, inplace=True)" ] }, { "cell_type": "code", "execution_count": 86, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Vijay Mehta32A+Begumpet HYDERABAD9848584529
1Arindam Deka25A+Kondapur HYDERABAD8125298304
2alluri babul reddy27A+plot no 96/b HYDERABAD9642244070
3Kiran Swamy .A34A+hyderabad HYDERABAD9963339200
4a prasad26A+prem nagar,khairathabad. HYDERABAD9032032310
5Abdul Rahman25A+Santosh nagar HYDERABAD9642692545
6Abhilash reddy24A+Gandhinagar HYDERABAD8801770077
7ABHIJIT JEETU21A+Hyderabad Central University HYDERABAD9966362080
8abhinay barla21A+1-1-304, road no 6, balaji colony mohan nagar ...8125950302
9abhishek bhoreddy28A+H: 1-53, flat no 208, sai residency,Madinaguda...9885902222
10Achutha Prasad24A+No 16, 3rd floor, Rahul colony, Tolichowki. HY...9342757176
11A CHANDRA OBULA REDD26A+hydrabad HYDERABAD9550481780
12rajesh kumar28A+2-21, ram nagar. hyderabad HYDERABAD7075009449
13Aditi Ainapure22A+Nehru Gunj Kalaburagi, Karnataka HYDERABAD9113946610
14raj agarwal41A+sanathnagar HYDERABAD9494394592
15agarwal rajesh41A+sanathnagar HYDERABAD9494394592
17Ajay Chenigunta25A+09642549475 HYDERABAD9642549475
18sri ranjitha kulakarni30A+Flat No.401, ranjita residency,kphb HYDERABAD9848022338
19Ravikiran Akella30A+Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY...9000277678
20Akhil Kumar20A+Sathish Nagar colony near bustand nalgonda HYD...9182538554
21Akhil20A+Nagole HYDERABAD9618106017
22Akhilesh25A+3-4-369/4/b, krishna nagar, bholakpur HYDERABAD8686299309
23ganesh yyadav23A+kukatpally HYDERABAD7702120996
24akram khan30A+srt 68 HYDERABAD9963110557
25Alekhya Pinnamaneni21A+7-1-282/E, Balkampet, S R Nagar, hyderabad HYD...9550411659
26alizeh shirazi25A+sara homes, upperpally, hyderabad HYDERABAD8686386991
27Prabhu26A+LIngampalli HYDERABAD9900222349
28R S Narayana Galidevara27A+Balaji hills, Nijampet, Hyderabad HYDERABAD1847808911
29Srinidhi Krishnamachary37A+Flat No 201, Plot No 333-335, Sri Sai Hanuma R...9989967895
30waqar younus22A+16-5-372, farhatnagar hyderabad HYDERABAD8121485848
..................
3903Mahesh Kandari26O-Safilguda SECUNDERABAD9959025925
3904karthik mg22O-37-74/1/a, jj nagar, neredmet x road, sainikpu...7207375179
3905mohammad fayaz24O-secunderabad SECUNDERABAD9951711762
3906monica bung22O-d.v.colony SECUNDERABAD9032811903
3907mukendra kumar19O-risala bazar SECUNDERABAD8885428730
3908N.venkat Rao23O-No SECUNDERABAD7285910430
3909Nagendra Reddy26O-H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec...8143382248
3910naveen kumar yamsani29O-04023392745 SECUNDERABAD9885344462
3911neelima lakshmi21O-secunderabad SECUNDERABAD9394309995
3913Praful Yadav28O-sainkpuri SECUNDERABAD8686021042
3914pasp naidu35O-as rao nagar SECUNDERABAD9701171118
3915punit pushkar25O-501, sree ram charan towers, old bowenpally SE...8464038825
3916raghuram vangala30O-ammerpeta SECUNDERABAD9642752360
3917Rajasekhar kola33O-neredmet SECUNDERABAD9989837871
3918KAMANCHI RAM MOHAN BABU37O-c/o sbh msme moulali branch, nfc road moulali,...9010406089
3919Chandra Shekar Reddy Bannur36O-BEGUMPET SECUNDERABAD9052893393
3920Pinks Pinks27O-Secunderabad SECUNDERABAD8885001333
3922Sadan Reddy S21O-secunderabad SECUNDERABAD9505010085
3923GUTTAPATI SESHAGIRI ACHARYULU39O-FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD9848410346
3924sadiq mohammad25O-tarnaka,secundrabad. SECUNDERABAD9849405373
3925Subrahmanya Sarma M38O-6-1-132/136,Padmarao nagar SECUNDERABAD9000675611
3926Somil Jain23O-ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD7987276603
3927SREENIVAS YADAV23O-09885632631 SECUNDERABAD9885632631
3928Suchan Golla21O-7-741/4,subhash nagar,Hyderabad SECUNDERABAD9701816008
3929Sunil Stephen34O-Secunderabad SECUNDERABAD9502114280
3930Surya Yadav24O-Malkajgiri SECUNDERABAD8186815844
3934vamshidhar reddy28O-malkajgiri SECUNDERABAD7799452981
3935vinith reddy20O-b.s nagar, malajgiri,secunderabad SECUNDERABAD7075008899
3936Shaik Zaheer24O-12-1-505, st.no 11 tarnaka. SECUNDERABAD9916411004
3937MYLSAMY35A1B+3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD9700618565
\n", "

3758 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Vijay Mehta 32 A+ \n", "1 Arindam Deka 25 A+ \n", "2 alluri babul reddy 27 A+ \n", "3 Kiran Swamy .A 34 A+ \n", "4 a prasad 26 A+ \n", "5 Abdul Rahman 25 A+ \n", "6 Abhilash reddy 24 A+ \n", "7 ABHIJIT JEETU 21 A+ \n", "8 abhinay barla 21 A+ \n", "9 abhishek bhoreddy 28 A+ \n", "10 Achutha Prasad 24 A+ \n", "11 A CHANDRA OBULA REDD 26 A+ \n", "12 rajesh kumar 28 A+ \n", "13 Aditi Ainapure 22 A+ \n", "14 raj agarwal 41 A+ \n", "15 agarwal rajesh 41 A+ \n", "17 Ajay Chenigunta 25 A+ \n", "18 sri ranjitha kulakarni 30 A+ \n", "19 Ravikiran Akella 30 A+ \n", "20 Akhil Kumar 20 A+ \n", "21 Akhil 20 A+ \n", "22 Akhilesh 25 A+ \n", "23 ganesh yyadav 23 A+ \n", "24 akram khan 30 A+ \n", "25 Alekhya Pinnamaneni 21 A+ \n", "26 alizeh shirazi 25 A+ \n", "27 Prabhu 26 A+ \n", "28 R S Narayana Galidevara 27 A+ \n", "29 Srinidhi Krishnamachary 37 A+ \n", "30 waqar younus 22 A+ \n", "... ... .. ... \n", "3903 Mahesh Kandari 26 O- \n", "3904 karthik mg 22 O- \n", "3905 mohammad fayaz 24 O- \n", "3906 monica bung 22 O- \n", "3907 mukendra kumar 19 O- \n", "3908 N.venkat Rao 23 O- \n", "3909 Nagendra Reddy 26 O- \n", "3910 naveen kumar yamsani 29 O- \n", "3911 neelima lakshmi 21 O- \n", "3913 Praful Yadav 28 O- \n", "3914 pasp naidu 35 O- \n", "3915 punit pushkar 25 O- \n", "3916 raghuram vangala 30 O- \n", "3917 Rajasekhar kola 33 O- \n", "3918 KAMANCHI RAM MOHAN BABU 37 O- \n", "3919 Chandra Shekar Reddy Bannur 36 O- \n", "3920 Pinks Pinks 27 O- \n", "3922 Sadan Reddy S 21 O- \n", "3923 GUTTAPATI SESHAGIRI ACHARYULU 39 O- \n", "3924 sadiq mohammad 25 O- \n", "3925 Subrahmanya Sarma M 38 O- \n", "3926 Somil Jain 23 O- \n", "3927 SREENIVAS YADAV 23 O- \n", "3928 Suchan Golla 21 O- \n", "3929 Sunil Stephen 34 O- \n", "3930 Surya Yadav 24 O- \n", "3934 vamshidhar reddy 28 O- \n", "3935 vinith reddy 20 O- \n", "3936 Shaik Zaheer 24 O- \n", "3937 MYLSAMY 35 A1B+ \n", "\n", " Address Contact Number \n", "0 Begumpet HYDERABAD 9848584529 \n", "1 Kondapur HYDERABAD 8125298304 \n", "2 plot no 96/b HYDERABAD 9642244070 \n", "3 hyderabad HYDERABAD 9963339200 \n", "4 prem nagar,khairathabad. HYDERABAD 9032032310 \n", "5 Santosh nagar HYDERABAD 9642692545 \n", "6 Gandhinagar HYDERABAD 8801770077 \n", "7 Hyderabad Central University HYDERABAD 9966362080 \n", "8 1-1-304, road no 6, balaji colony mohan nagar ... 8125950302 \n", "9 H: 1-53, flat no 208, sai residency,Madinaguda... 9885902222 \n", "10 No 16, 3rd floor, Rahul colony, Tolichowki. HY... 9342757176 \n", "11 hydrabad HYDERABAD 9550481780 \n", "12 2-21, ram nagar. hyderabad HYDERABAD 7075009449 \n", "13 Nehru Gunj Kalaburagi, Karnataka HYDERABAD 9113946610 \n", "14 sanathnagar HYDERABAD 9494394592 \n", "15 sanathnagar HYDERABAD 9494394592 \n", "17 09642549475 HYDERABAD 9642549475 \n", "18 Flat No.401, ranjita residency,kphb HYDERABAD 9848022338 \n", "19 Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY... 9000277678 \n", "20 Sathish Nagar colony near bustand nalgonda HYD... 9182538554 \n", "21 Nagole HYDERABAD 9618106017 \n", "22 3-4-369/4/b, krishna nagar, bholakpur HYDERABAD 8686299309 \n", "23 kukatpally HYDERABAD 7702120996 \n", "24 srt 68 HYDERABAD 9963110557 \n", "25 7-1-282/E, Balkampet, S R Nagar, hyderabad HYD... 9550411659 \n", "26 sara homes, upperpally, hyderabad HYDERABAD 8686386991 \n", "27 LIngampalli HYDERABAD 9900222349 \n", "28 Balaji hills, Nijampet, Hyderabad HYDERABAD 1847808911 \n", "29 Flat No 201, Plot No 333-335, Sri Sai Hanuma R... 9989967895 \n", "30 16-5-372, farhatnagar hyderabad HYDERABAD 8121485848 \n", "... ... ... \n", "3903 Safilguda SECUNDERABAD 9959025925 \n", "3904 37-74/1/a, jj nagar, neredmet x road, sainikpu... 7207375179 \n", "3905 secunderabad SECUNDERABAD 9951711762 \n", "3906 d.v.colony SECUNDERABAD 9032811903 \n", "3907 risala bazar SECUNDERABAD 8885428730 \n", "3908 No SECUNDERABAD 7285910430 \n", "3909 H.no.10-5-342/26,n.lallaguda, tukaramgate, Sec... 8143382248 \n", "3910 04023392745 SECUNDERABAD 9885344462 \n", "3911 secunderabad SECUNDERABAD 9394309995 \n", "3913 sainkpuri SECUNDERABAD 8686021042 \n", "3914 as rao nagar SECUNDERABAD 9701171118 \n", "3915 501, sree ram charan towers, old bowenpally SE... 8464038825 \n", "3916 ammerpeta SECUNDERABAD 9642752360 \n", "3917 neredmet SECUNDERABAD 9989837871 \n", "3918 c/o sbh msme moulali branch, nfc road moulali,... 9010406089 \n", "3919 BEGUMPET SECUNDERABAD 9052893393 \n", "3920 Secunderabad SECUNDERABAD 8885001333 \n", "3922 secunderabad SECUNDERABAD 9505010085 \n", "3923 FLAT 107,RR TOWERS,BOWENPALLY SECUNDERABAD 9848410346 \n", "3924 tarnaka,secundrabad. SECUNDERABAD 9849405373 \n", "3925 6-1-132/136,Padmarao nagar SECUNDERABAD 9000675611 \n", "3926 ROTOMAKER India Pvt Ltd, Moula Ali SECUNDERABAD 7987276603 \n", "3927 09885632631 SECUNDERABAD 9885632631 \n", "3928 7-741/4,subhash nagar,Hyderabad SECUNDERABAD 9701816008 \n", "3929 Secunderabad SECUNDERABAD 9502114280 \n", "3930 Malkajgiri SECUNDERABAD 8186815844 \n", "3934 malkajgiri SECUNDERABAD 7799452981 \n", "3935 b.s nagar, malajgiri,secunderabad SECUNDERABAD 7075008899 \n", "3936 12-1-505, st.no 11 tarnaka. SECUNDERABAD 9916411004 \n", "3937 3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD 9700618565 \n", "\n", "[3758 rows x 5 columns]" ] }, "execution_count": 86, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df = df[df.Age != '0']\n", "df" ] }, { "cell_type": "code", "execution_count": 87, "metadata": {}, "outputs": [ { "data": { "application/vnd.plotly.v1+json": { "config": { "linkText": "Export to plot.ly", "plotlyServerURL": "https://plot.ly", "showLink": true }, "data": [ { "marker": { "color": "rgba(255, 153, 51, 0.6)", "line": { "color": "rgba(255, 153, 51, 1.0)", "width": 1 } }, "name": "('Name', 'count')", "orientation": "v", "text": "", "type": "bar", "uid": "f4f822cd-9418-45fa-bbcb-02e699e33a90", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 939, 133, 5, 3, 1, 413, 57, 0, 1238, 157, 515, 281 ] }, { "marker": { "color": "rgba(55, 128, 191, 0.6)", "line": { "color": "rgba(55, 128, 191, 1.0)", "width": 1 } }, "name": "('Name', 'unique')", "orientation": "v", "text": "", "type": "bar", "uid": "475b5c6d-0195-42e3-99a0-060dbad5bea2", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 893, 128, 5, 3, 1, 355, 47, 0, 1178, 149, 498, 257 ] }, { "marker": { "color": "rgba(50, 171, 96, 0.6)", "line": { "color": "rgba(50, 171, 96, 1.0)", "width": 1 } }, "name": "('Name', 'top')", "orientation": "v", "text": "", "type": "bar", "uid": "eb7b5735-be69-42b4-b558-79b65ee13d71", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ "HemanthKumar Devaki ", "Rishitha Sanjana abbagoni ", "Himanshu Mishra ", "Indhu ", "Narasimha Raju N ", "nani mendu ", "Vijay Bhamidipati ", "", "Abhilash Reddy ", "Anil Panuganti ", "Balabhadrapatruni Sravana Kumar ", "Suchan Golla " ] }, { "marker": { "color": "rgba(128, 0, 128, 0.6)", "line": { "color": "rgba(128, 0, 128, 1.0)", "width": 1 } }, "name": "('Name', 'freq')", "orientation": "v", "text": "", "type": "bar", "uid": "4db5b585-2b1d-4458-ac27-a8693b52cd06", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 3, 3, 1, 1, 1, 5, 2, "", 4, 2, 2, 2 ] }, { "marker": { "color": "rgba(219, 64, 82, 0.6)", "line": { "color": "rgba(219, 64, 82, 1.0)", "width": 1 } }, "name": "('Age', 'count')", "orientation": "v", "text": "", "type": "bar", "uid": "dac86505-8082-4a50-b06d-7e3493ce94b9", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 939, 133, 5, 3, 1, 413, 57, 1, 1238, 157, 515, 281 ] }, { "marker": { "color": "rgba(0, 128, 128, 0.6)", "line": { "color": "rgba(0, 128, 128, 1.0)", "width": 1 } }, "name": "('Age', 'unique')", "orientation": "v", "text": "", "type": "bar", "uid": "e3071a08-239c-4bdc-b117-e19fe2f1b0cc", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 35, 28, 5, 3, 1, 34, 20, 1, 39, 28, 36, 29 ] }, { "marker": { "color": "rgba(255, 255, 51, 0.6)", "line": { "color": "rgba(255, 255, 51, 1.0)", "width": 1 } }, "name": "('Age', 'top')", "orientation": "v", "text": "", "type": "bar", "uid": "9d5c8567-ba4c-4ad8-b360-854e00295d8f", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ "24", "22", "36", "23", "30", "26", "28", " ", "24", "25", "26", "24" ] }, { "marker": { "color": "rgba(128, 128, 0, 0.6)", "line": { "color": "rgba(128, 128, 0, 1.0)", "width": 1 } }, "name": "('Age', 'freq')", "orientation": "v", "text": "", "type": "bar", "uid": "ccdfd598-1c04-4c26-8176-f0a312b5c6b7", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 90, 11, 1, 1, 1, 39, 8, 1, 122, 18, 55, 27 ] }, { "marker": { "color": "rgba(251, 128, 114, 0.6)", "line": { "color": "rgba(251, 128, 114, 1.0)", "width": 1 } }, "name": "('Address', 'count')", "orientation": "v", "text": "", "type": "bar", "uid": "949d3882-8d15-4f68-bcde-a5d12054acea", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 939, 133, 5, 3, 1, 413, 57, 1, 1238, 157, 515, 281 ] }, { "marker": { "color": "rgba(128, 177, 211, 0.6)", "line": { "color": "rgba(128, 177, 211, 1.0)", "width": 1 } }, "name": "('Address', 'unique')", "orientation": "v", "text": "", "type": "bar", "uid": "c1c83207-1d48-4012-81ab-0b1529420457", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 809, 127, 5, 3, 1, 341, 47, 1, 1055, 139, 456, 240 ] }, { "marker": { "color": "rgba(128, 177, 211, 0.6)", "line": { "color": "rgba(128, 177, 211, 0.8999999999999999)", "width": 1 } }, "name": "('Address', 'top')", "orientation": "v", "text": "", "type": "bar", "uid": "a45ed6d6-8b35-454b-9d79-ff550f50d908", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ "Hyderabad HYDERABAD", "hyderabad HYDERABAD", "sr nagar HYDERABAD", "3/2, II FLOOR PRIYA COLONY, KHARKANA SECUNDERABAD", "RajeevNagar HYDERABAD", "hyderabad HYDERABAD", "Hyderabad HYDERABAD", "26", "Hyderabad HYDERABAD", "hyderabad HYDERABAD", "Hyderabad HYDERABAD", "Hyderabad HYDERABAD" ] }, { "marker": { "color": "rgba(255, 153, 51, 0.6)", "line": { "color": "rgba(255, 153, 51, 0.8999999999999999)", "width": 1 } }, "name": "('Address', 'freq')", "orientation": "v", "text": "", "type": "bar", "uid": "44f1b954-dd75-442a-b571-55fc68757a7a", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 16, 3, 1, 1, 1, 7, 3, 1, 33, 4, 14, 7 ] }, { "marker": { "color": "rgba(55, 128, 191, 0.6)", "line": { "color": "rgba(55, 128, 191, 0.8999999999999999)", "width": 1 } }, "name": "('Contact Number', 'count')", "orientation": "v", "text": "", "type": "bar", "uid": "2d31406b-47fa-4670-bf89-dcadf2f76427", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 939, 133, 5, 3, 1, 413, 57, 1, 1238, 157, 515, 281 ] }, { "marker": { "color": "rgba(50, 171, 96, 0.6)", "line": { "color": "rgba(50, 171, 96, 0.8999999999999999)", "width": 1 } }, "name": "('Contact Number', 'unique')", "orientation": "v", "text": "", "type": "bar", "uid": "48b600e3-8c6e-4ae1-bab8-3d74f7460f5d", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 871, 128, 5, 3, 1, 346, 49, 1, 1170, 148, 495, 260 ] }, { "marker": { "color": "rgba(128, 0, 128, 0.6)", "line": { "color": "rgba(128, 0, 128, 0.8999999999999999)", "width": 1 } }, "name": "('Contact Number', 'top')", "orientation": "v", "text": "", "type": "bar", "uid": "b104c455-6199-427d-bc49-64bca1d367bf", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ "9966128121", "9063682656", "9550582900", "8686476733", "9989490225", "9949167108", "7348887772", "A-", "9581063216", "9700572270", "9701002833", "8186815844" ] }, { "marker": { "color": "rgba(219, 64, 82, 0.6)", "line": { "color": "rgba(219, 64, 82, 0.8999999999999999)", "width": 1 } }, "name": "('Contact Number', 'freq')", "orientation": "v", "text": "", "type": "bar", "uid": "ceebc1f6-8533-418a-943e-0136f6484f40", "x": [ "A+", "A-", "A1+", "A1B+", "A2+", "AB+", "AB-", "Anuj Kherde ", "B+", "B-", "O+", "O-" ], "y": [ 4, 3, 1, 1, 1, 5, 2, 1, 3, 2, 2, 2 ] } ], "layout": { "legend": { "bgcolor": "#F5F6F9", "font": { "color": "#4D5663" } }, "paper_bgcolor": "#F5F6F9", "plot_bgcolor": "#F5F6F9", "title": { "font": { "color": "#4D5663" } }, "xaxis": { "gridcolor": "#E1E5ED", "showgrid": true, "tickfont": { "color": "#4D5663" }, "title": { "font": { "color": "#4D5663" }, "text": "" }, "zerolinecolor": "#E1E5ED" }, "yaxis": { "gridcolor": "#E1E5ED", "showgrid": true, "tickfont": { "color": "#4D5663" }, "title": { "font": { "color": "#4D5663" }, "text": "" }, "zerolinecolor": "#E1E5ED" } } }, "text/html": [ "
\n", " \n", " \n", "
\n", " \n", "
" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "df.groupby(\"Blood Group\").describe().iplot(kind='bar')" ] }, { "cell_type": "code", "execution_count": 88, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
891NaNAnuj Kherde26A-
\n", "
" ], "text/plain": [ " Name Age Blood Group Address Contact Number\n", "891 NaN Anuj Kherde 26 A-" ] }, "execution_count": 88, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Blood Group']== 'Anuj Kherde ']" ] }, { "cell_type": "code", "execution_count": 89, "metadata": {}, "outputs": [], "source": [ "df = df.drop(891)" ] }, { "cell_type": "code", "execution_count": 90, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: [Name, Age, Blood Group, Address, Contact Number]\n", "Index: []" ] }, "execution_count": 90, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df[df['Blood Group']== 'Anuj Kherde ']" ] }, { "cell_type": "code", "execution_count": 91, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0ARPUTHARAJ33B-Tondiarpet - Chennai9841190592
1MUTHU VENKATESH39B-Madipakkam - Chennai9789062282
2VISHNU H NAIR23B-Ayappaka/ - Chennai9941414391
3ROHINI SEKAR23B-avadi - Chennai8754500953
4KAMAL GUPTA30B-Ayanavaram - Chennai9600168292
5VINOLA R27B-Adambakkam - Chennai9677183835
6PONPANDIAN26B-Perambur - Chennai7418545299
7CHANDRASEKARAN33B-Kottivakkam - Chennai9884656455
8JOHN25B-Manali New Town - Chennai8122739112
9DHIVAGAR26B-Inathukkanpatti - Chennai9894624535
10ARULKUMAR34B-Guindy - Chennai9962288197
11SIVA MP26B-Velachery - Chennai8220940968
12SENTHIL42B-Chennai - Chennai83447775200
13EDWIN AROKIYA RAJ30B-Maduravoyal - Chennai9500747571
14SEPTIMUS SCOTT SL26B-\"Azhakandeswarar main road Okkiyam thuraip...7598613133
15ELANG KUMARAN C52B-Kottur gardens Chennai - Chennai9840855322
16SASIREKHA29B-Chennai8056137704
17NN75B-\\tvadapalani - Chennai7865498745
18GAUTHAM30B-Shenoy Nagar - Chennai9094666645
19SURIYA KUMAR.G27B-mugappair - Chennai9940548515
20CHANDRAN30B-nanganallur - Chennai9566431538
21ROBIN RAJ23B-uthandi - Chennai9962849717
22HARI KISHEN RAJ22B-Kolapakkam - Chennai9094270280
23ABDEALI KOTHARI21B-Chennai9865472244
24GAUTHAM C26B-AADAMBAKKAM - Chennai8500479252
25JOHNDINESH.M27B-Manali new town Chennai918189864144
26CHANDRAN30B-urappakam - Chennai9566431538
27SABARISH25B-navallur - Chennai8973708402
28DILIPKUMAR NATARAJAN35B-Sholinganallur - Chennai9962297380
29SHARAFATH24B-Avvai thiru nagar - Chennai8124330859
30SARAFATH24B-Avvai thiru nagar - Chennai8124330859
31VIMAL SEKAR \\t34B-Chennai - Chennai9841449259
32SARAVANAN36B-Pammal - Chennai9488013492
33RAVISANKARAN K43B-Annanagar East - Chennai9894525323
34ASHOK31B-Thirumullaivoil - Chennai9790884490
35ASHOK31B-Thirumullaivoil - Chennai9790884490
36SATHIESH RAM29B-MMDA Colony - Chennai9791062882
37SOWMIYA25B-okkiyam thoraipakkam - Chennai9489142057
38DINESH BABU29B-tambaram - Chennai9003350015
39SURESH44B-Chennai8056128481
40SANKARA NARAYANAN34B-padi - Chennai8124580577
41MANIKANDAN33B-thirverkadu - Chennai9566222119
42DINESH KUMAR.M27B-TEYNAMPET - Chennai9841237917
\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 ARPUTHARAJ 33 B- \n", "1 MUTHU VENKATESH 39 B- \n", "2 VISHNU H NAIR 23 B- \n", "3 ROHINI SEKAR 23 B- \n", "4 KAMAL GUPTA 30 B- \n", "5 VINOLA R 27 B- \n", "6 PONPANDIAN 26 B- \n", "7 CHANDRASEKARAN 33 B- \n", "8 JOHN 25 B- \n", "9 DHIVAGAR 26 B- \n", "10 ARULKUMAR 34 B- \n", "11 SIVA MP 26 B- \n", "12 SENTHIL 42 B- \n", "13 EDWIN AROKIYA RAJ 30 B- \n", "14 SEPTIMUS SCOTT SL 26 B- \n", "15 ELANG KUMARAN C 52 B- \n", "16 SASIREKHA 29 B- \n", "17 NN 75 B- \n", "18 GAUTHAM 30 B- \n", "19 SURIYA KUMAR.G 27 B- \n", "20 CHANDRAN 30 B- \n", "21 ROBIN RAJ 23 B- \n", "22 HARI KISHEN RAJ 22 B- \n", "23 ABDEALI KOTHARI 21 B- \n", "24 GAUTHAM C 26 B- \n", "25 JOHNDINESH.M 27 B- \n", "26 CHANDRAN 30 B- \n", "27 SABARISH 25 B- \n", "28 DILIPKUMAR NATARAJAN 35 B- \n", "29 SHARAFATH 24 B- \n", "30 SARAFATH 24 B- \n", "31 VIMAL SEKAR \\t 34 B- \n", "32 SARAVANAN 36 B- \n", "33 RAVISANKARAN K 43 B- \n", "34 ASHOK 31 B- \n", "35 ASHOK 31 B- \n", "36 SATHIESH RAM 29 B- \n", "37 SOWMIYA 25 B- \n", "38 DINESH BABU 29 B- \n", "39 SURESH 44 B- \n", "40 SANKARA NARAYANAN 34 B- \n", "41 MANIKANDAN 33 B- \n", "42 DINESH KUMAR.M 27 B- \n", "\n", " Address Contact Number \n", "0 Tondiarpet - Chennai 9841190592 \n", "1 Madipakkam - Chennai 9789062282 \n", "2 Ayappaka/ - Chennai 9941414391 \n", "3 avadi - Chennai 8754500953 \n", "4 Ayanavaram - Chennai 9600168292 \n", "5 Adambakkam - Chennai 9677183835 \n", "6 Perambur - Chennai 7418545299 \n", "7 Kottivakkam - Chennai 9884656455 \n", "8 Manali New Town - Chennai 8122739112 \n", "9 Inathukkanpatti - Chennai 9894624535 \n", "10 Guindy - Chennai 9962288197 \n", "11 Velachery - Chennai 8220940968 \n", "12 Chennai - Chennai 83447775200 \n", "13 Maduravoyal - Chennai 9500747571 \n", "14 \"Azhakandeswarar main road Okkiyam thuraip... 7598613133 \n", "15 Kottur gardens Chennai - Chennai 9840855322 \n", "16 Chennai 8056137704 \n", "17 \\tvadapalani - Chennai 7865498745 \n", "18 Shenoy Nagar - Chennai 9094666645 \n", "19 mugappair - Chennai 9940548515 \n", "20 nanganallur - Chennai 9566431538 \n", "21 uthandi - Chennai 9962849717 \n", "22 Kolapakkam - Chennai 9094270280 \n", "23 Chennai 9865472244 \n", "24 AADAMBAKKAM - Chennai 8500479252 \n", "25 Manali new town Chennai 918189864144 \n", "26 urappakam - Chennai 9566431538 \n", "27 navallur - Chennai 8973708402 \n", "28 Sholinganallur - Chennai 9962297380 \n", "29 Avvai thiru nagar - Chennai 8124330859 \n", "30 Avvai thiru nagar - Chennai 8124330859 \n", "31 Chennai - Chennai 9841449259 \n", "32 Pammal - Chennai 9488013492 \n", "33 Annanagar East - Chennai 9894525323 \n", "34 Thirumullaivoil - Chennai 9790884490 \n", "35 Thirumullaivoil - Chennai 9790884490 \n", "36 MMDA Colony - Chennai 9791062882 \n", "37 okkiyam thoraipakkam - Chennai 9489142057 \n", "38 tambaram - Chennai 9003350015 \n", "39 Chennai 8056128481 \n", "40 padi - Chennai 8124580577 \n", "41 thirverkadu - Chennai 9566222119 \n", "42 TEYNAMPET - Chennai 9841237917 " ] }, "execution_count": 91, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df2" ] }, { "cell_type": "code", "execution_count": 92, "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
0Vijay Mehta32A+Begumpet HYDERABAD9848584529
1Arindam Deka25A+Kondapur HYDERABAD8125298304
2alluri babul reddy27A+plot no 96/b HYDERABAD9642244070
3Kiran Swamy .A34A+hyderabad HYDERABAD9963339200
4a prasad26A+prem nagar,khairathabad. HYDERABAD9032032310
5Abdul Rahman25A+Santosh nagar HYDERABAD9642692545
6Abhilash reddy24A+Gandhinagar HYDERABAD8801770077
7ABHIJIT JEETU21A+Hyderabad Central University HYDERABAD9966362080
8abhinay barla21A+1-1-304, road no 6, balaji colony mohan nagar ...8125950302
9abhishek bhoreddy28A+H: 1-53, flat no 208, sai residency,Madinaguda...9885902222
10Achutha Prasad24A+No 16, 3rd floor, Rahul colony, Tolichowki. HY...9342757176
11A CHANDRA OBULA REDD26A+hydrabad HYDERABAD9550481780
12rajesh kumar28A+2-21, ram nagar. hyderabad HYDERABAD7075009449
13Aditi Ainapure22A+Nehru Gunj Kalaburagi, Karnataka HYDERABAD9113946610
14raj agarwal41A+sanathnagar HYDERABAD9494394592
15agarwal rajesh41A+sanathnagar HYDERABAD9494394592
17Ajay Chenigunta25A+09642549475 HYDERABAD9642549475
18sri ranjitha kulakarni30A+Flat No.401, ranjita residency,kphb HYDERABAD9848022338
19Ravikiran Akella30A+Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY...9000277678
20Akhil Kumar20A+Sathish Nagar colony near bustand nalgonda HYD...9182538554
21Akhil20A+Nagole HYDERABAD9618106017
22Akhilesh25A+3-4-369/4/b, krishna nagar, bholakpur HYDERABAD8686299309
23ganesh yyadav23A+kukatpally HYDERABAD7702120996
24akram khan30A+srt 68 HYDERABAD9963110557
25Alekhya Pinnamaneni21A+7-1-282/E, Balkampet, S R Nagar, hyderabad HYD...9550411659
26alizeh shirazi25A+sara homes, upperpally, hyderabad HYDERABAD8686386991
27Prabhu26A+LIngampalli HYDERABAD9900222349
28R S Narayana Galidevara27A+Balaji hills, Nijampet, Hyderabad HYDERABAD1847808911
29Srinidhi Krishnamachary37A+Flat No 201, Plot No 333-335, Sri Sai Hanuma R...9989967895
30waqar younus22A+16-5-372, farhatnagar hyderabad HYDERABAD8121485848
..................
1146NAVEEN KUMAR24O+Datti rajeru, Vizianagaram Dist: VIZIANAGARAM9676279814
1147Pothu Chandrashekar38A+H.no. 11-18-563, socity colony, kasibugga, war...9866162552
1148kushal kumar durgam23A+himayatnagar,hyd Dist: WARANGAL9700733556
1149MURALI DHAR DALIA34A+8-4-49,sri krishna colony Dist: WARANGAL7013805966
1150Pothu Chandrashekar38A+H.no. 11-18-563, socity colony, kasibugga, war...9866162552
1151Rajesh Kankala29A+#17-7-171/a,orus,kareemabad warangal Dist: WAR...8618401683
1152tandoori saikiran22A+warangal Dist: WARANGAL9490790279
1153Mohammed sharukh24A+#1-5-135 jubilee market kazipet Dist: WARANGAL8790348034
1154Upender Rachakonda29A+thorrur. Dist: WARANGAL9963256976
1155jukeshwar goud25A-2-9-171,vikasnagar,hanamkonda,warangal Dist: W...9959025014
1156Abhilash Uppala20B+18-69/a,cherial,warangal Dist: WARANGAL8143806704
1157ADHI s30B+kukatpally Dist: WARANGAL7386635333
1159chaitanyakumar Thota35B+Madikonda Dist: WARANGAL9989126555
1161Gyan Deep24B+9-1-188/S/303, Kakatiya Towers Dist: WARANGAL9000364073
1162VENKATA HARI KRISHNA KANNURI21B+5-12-47,opposite hanumantemple,kuc road,hanamk...9700750915
1163AQEEB SHOYAB PASHA MOHAMMAD22B+h.no:5-47/3, sai ganesh colony kashibugga wara...9666359357
1164Pradyumna Bhasyakarla21B+H.no 16-3-528/A,ekashila nagar,warangal Dist: ...8686733639
1165raja siraboina22B+east fort Dist: WARANGAL9177972080
1166Rajnikanth Soorineni32B+Choutapally, Parvathagiri, warangal Dist: WARA...9989770324
1167rakesh banoth26B+revenue colony Dist: WARANGAL9299652313
1168Shameem Shaik28B+kazipet Dist: WARANGAL9866921283
1169SravanKumar Bayagani25B+36-9-43 WARANGAL Dist: WARANGAL9533557520
1170Karnataka Sravankumar26B+SP office Warangal Dist: WARANGAL9177825383
1171sunil poshala25B+chintal basti,khairatabad Dist: WARANGAL9390102285
1172P RAJU28O+HYD Dist: WARANGAL8179204343
1175venkata ramana dodda22O+plot no:326 krishna colony bhupalpally waranga...9948657545
1176vijay Kumar25O+46-1-269,enumamula , hanamkonda Warangal Dist:...9100256983
1177Thumma Vijaya anand reddy21O+Jangaon Dist: WARANGAL7673971823
1178ravula vinayreddy24O-5-5-18;kesamudram warangal Dist: WARANGAL9848633766
1179prashanth reddy21O-hanamkonda warangaL Dist: WARANGAL8500499112
\n", "

4834 rows × 5 columns

\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "0 Vijay Mehta 32 A+ \n", "1 Arindam Deka 25 A+ \n", "2 alluri babul reddy 27 A+ \n", "3 Kiran Swamy .A 34 A+ \n", "4 a prasad 26 A+ \n", "5 Abdul Rahman 25 A+ \n", "6 Abhilash reddy 24 A+ \n", "7 ABHIJIT JEETU 21 A+ \n", "8 abhinay barla 21 A+ \n", "9 abhishek bhoreddy 28 A+ \n", "10 Achutha Prasad 24 A+ \n", "11 A CHANDRA OBULA REDD 26 A+ \n", "12 rajesh kumar 28 A+ \n", "13 Aditi Ainapure 22 A+ \n", "14 raj agarwal 41 A+ \n", "15 agarwal rajesh 41 A+ \n", "17 Ajay Chenigunta 25 A+ \n", "18 sri ranjitha kulakarni 30 A+ \n", "19 Ravikiran Akella 30 A+ \n", "20 Akhil Kumar 20 A+ \n", "21 Akhil 20 A+ \n", "22 Akhilesh 25 A+ \n", "23 ganesh yyadav 23 A+ \n", "24 akram khan 30 A+ \n", "25 Alekhya Pinnamaneni 21 A+ \n", "26 alizeh shirazi 25 A+ \n", "27 Prabhu 26 A+ \n", "28 R S Narayana Galidevara 27 A+ \n", "29 Srinidhi Krishnamachary 37 A+ \n", "30 waqar younus 22 A+ \n", "... ... .. ... \n", "1146 NAVEEN KUMAR 24 O+ \n", "1147 Pothu Chandrashekar 38 A+ \n", "1148 kushal kumar durgam 23 A+ \n", "1149 MURALI DHAR DALIA 34 A+ \n", "1150 Pothu Chandrashekar 38 A+ \n", "1151 Rajesh Kankala 29 A+ \n", "1152 tandoori saikiran 22 A+ \n", "1153 Mohammed sharukh 24 A+ \n", "1154 Upender Rachakonda 29 A+ \n", "1155 jukeshwar goud 25 A- \n", "1156 Abhilash Uppala 20 B+ \n", "1157 ADHI s 30 B+ \n", "1159 chaitanyakumar Thota 35 B+ \n", "1161 Gyan Deep 24 B+ \n", "1162 VENKATA HARI KRISHNA KANNURI 21 B+ \n", "1163 AQEEB SHOYAB PASHA MOHAMMAD 22 B+ \n", "1164 Pradyumna Bhasyakarla 21 B+ \n", "1165 raja siraboina 22 B+ \n", "1166 Rajnikanth Soorineni 32 B+ \n", "1167 rakesh banoth 26 B+ \n", "1168 Shameem Shaik 28 B+ \n", "1169 SravanKumar Bayagani 25 B+ \n", "1170 Karnataka Sravankumar 26 B+ \n", "1171 sunil poshala 25 B+ \n", "1172 P RAJU 28 O+ \n", "1175 venkata ramana dodda 22 O+ \n", "1176 vijay Kumar 25 O+ \n", "1177 Thumma Vijaya anand reddy 21 O+ \n", "1178 ravula vinayreddy 24 O- \n", "1179 prashanth reddy 21 O- \n", "\n", " Address Contact Number \n", "0 Begumpet HYDERABAD 9848584529 \n", "1 Kondapur HYDERABAD 8125298304 \n", "2 plot no 96/b HYDERABAD 9642244070 \n", "3 hyderabad HYDERABAD 9963339200 \n", "4 prem nagar,khairathabad. HYDERABAD 9032032310 \n", "5 Santosh nagar HYDERABAD 9642692545 \n", "6 Gandhinagar HYDERABAD 8801770077 \n", "7 Hyderabad Central University HYDERABAD 9966362080 \n", "8 1-1-304, road no 6, balaji colony mohan nagar ... 8125950302 \n", "9 H: 1-53, flat no 208, sai residency,Madinaguda... 9885902222 \n", "10 No 16, 3rd floor, Rahul colony, Tolichowki. HY... 9342757176 \n", "11 hydrabad HYDERABAD 9550481780 \n", "12 2-21, ram nagar. hyderabad HYDERABAD 7075009449 \n", "13 Nehru Gunj Kalaburagi, Karnataka HYDERABAD 9113946610 \n", "14 sanathnagar HYDERABAD 9494394592 \n", "15 sanathnagar HYDERABAD 9494394592 \n", "17 09642549475 HYDERABAD 9642549475 \n", "18 Flat No.401, ranjita residency,kphb HYDERABAD 9848022338 \n", "19 Flat#302,Sri SAI APt,HIG-550,6th Phase KPHB HY... 9000277678 \n", "20 Sathish Nagar colony near bustand nalgonda HYD... 9182538554 \n", "21 Nagole HYDERABAD 9618106017 \n", "22 3-4-369/4/b, krishna nagar, bholakpur HYDERABAD 8686299309 \n", "23 kukatpally HYDERABAD 7702120996 \n", "24 srt 68 HYDERABAD 9963110557 \n", "25 7-1-282/E, Balkampet, S R Nagar, hyderabad HYD... 9550411659 \n", "26 sara homes, upperpally, hyderabad HYDERABAD 8686386991 \n", "27 LIngampalli HYDERABAD 9900222349 \n", "28 Balaji hills, Nijampet, Hyderabad HYDERABAD 1847808911 \n", "29 Flat No 201, Plot No 333-335, Sri Sai Hanuma R... 9989967895 \n", "30 16-5-372, farhatnagar hyderabad HYDERABAD 8121485848 \n", "... ... ... \n", "1146 Datti rajeru, Vizianagaram Dist: VIZIANAGARAM 9676279814 \n", "1147 H.no. 11-18-563, socity colony, kasibugga, war... 9866162552 \n", "1148 himayatnagar,hyd Dist: WARANGAL 9700733556 \n", "1149 8-4-49,sri krishna colony Dist: WARANGAL 7013805966 \n", "1150 H.no. 11-18-563, socity colony, kasibugga, war... 9866162552 \n", "1151 #17-7-171/a,orus,kareemabad warangal Dist: WAR... 8618401683 \n", "1152 warangal Dist: WARANGAL 9490790279 \n", "1153 #1-5-135 jubilee market kazipet Dist: WARANGAL 8790348034 \n", "1154 thorrur. Dist: WARANGAL 9963256976 \n", "1155 2-9-171,vikasnagar,hanamkonda,warangal Dist: W... 9959025014 \n", "1156 18-69/a,cherial,warangal Dist: WARANGAL 8143806704 \n", "1157 kukatpally Dist: WARANGAL 7386635333 \n", "1159 Madikonda Dist: WARANGAL 9989126555 \n", "1161 9-1-188/S/303, Kakatiya Towers Dist: WARANGAL 9000364073 \n", "1162 5-12-47,opposite hanumantemple,kuc road,hanamk... 9700750915 \n", "1163 h.no:5-47/3, sai ganesh colony kashibugga wara... 9666359357 \n", "1164 H.no 16-3-528/A,ekashila nagar,warangal Dist: ... 8686733639 \n", "1165 east fort Dist: WARANGAL 9177972080 \n", "1166 Choutapally, Parvathagiri, warangal Dist: WARA... 9989770324 \n", "1167 revenue colony Dist: WARANGAL 9299652313 \n", "1168 kazipet Dist: WARANGAL 9866921283 \n", "1169 36-9-43 WARANGAL Dist: WARANGAL 9533557520 \n", "1170 SP office Warangal Dist: WARANGAL 9177825383 \n", "1171 chintal basti,khairatabad Dist: WARANGAL 9390102285 \n", "1172 HYD Dist: WARANGAL 8179204343 \n", "1175 plot no:326 krishna colony bhupalpally waranga... 9948657545 \n", "1176 46-1-269,enumamula , hanamkonda Warangal Dist:... 9100256983 \n", "1177 Jangaon Dist: WARANGAL 7673971823 \n", "1178 5-5-18;kesamudram warangal Dist: WARANGAL 9848633766 \n", "1179 hanamkonda warangaL Dist: WARANGAL 8500499112 \n", "\n", "[4834 rows x 5 columns]" ] }, "execution_count": 92, "metadata": {}, "output_type": "execute_result" } ], "source": [ "DF = pd.concat([df,df2,df3,df4,kf])\n", "DF\n" ] }, { "cell_type": "code", "execution_count": 93, "metadata": {}, "outputs": [], "source": [ "\n", "DF.replace('', np.nan, inplace=True)\n", "DF.dropna(subset=['Address'], inplace=True)\n" ] }, { "cell_type": "code", "execution_count": 96, "metadata": {}, "outputs": [], "source": [ "DF = pd.concat([DF[col].astype(str).str.upper() for col in DF.columns], axis=1)" ] }, { "cell_type": "code", "execution_count": 97, "metadata": { "scrolled": true }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Enter the Required Blood Group:B+\n", "Enter Required Location:kondapur\n" ] }, { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
NameAgeBlood GroupAddressContact Number
1455ADIT54B+RAGHAVENDRA COLONY,KONDAPUR HYDERABAD9676367432
1618CHIRANJEEVI BENDALAM28B+KONDAPUR, HYDERABAD8886494333
1650DHRUV BASU33B+SHILPA PARK, KONDAPUR HYDERABAD8860521564
1816MOHANKUMAR KANAKA24B+KONDAPUR HYDERABAD9966172828
1880KRISHNA33B+KONDAPUR HYDERABAD9912419944
2040NARESH MUTHUKURU27B+BOTANICAL GARDEN ROAD, KONDAPUR HYDERABAD9966693811
2058A NIKITA23B+KONDAPUR HYDERABAD9160641671
2103NAGADATTA PAVANKUMAR25B+KONDAPUR HYDERABAD HYDERABAD7995639647
2116PIYUSH AGARWALA23B+MSR BUILDING, SRI RAM NAGAR, KONDAPUR HYDERABAD8777283234
2211RAJNISH TRIPATHI22B+1-110/A/93 GOPAL REDDY NAGAR SHILPA PARK KONDA...9014886867
2251RAVI RAO34B+303, SRI RAMACHANDRA RESIDENCY, KONDAPUR HYDER...9789925580
2381SHAURYA S27B+KONDAPUR, RAGHAVENDRA COLONY C BLOCK HYDERABAD9160257815
2461SIVAPRASAD SRINADHU25B+KONDAPUR HYDERABAD9293790317
2588SHASHIVARDHAN REDDY T29B+PLOT# 6, 1-55/4/RP/L1, RAJA PRASADAM, KONDAPUR...8886431947
\n", "
" ], "text/plain": [ " Name Age Blood Group \\\n", "1455 ADIT 54 B+ \n", "1618 CHIRANJEEVI BENDALAM 28 B+ \n", "1650 DHRUV BASU 33 B+ \n", "1816 MOHANKUMAR KANAKA 24 B+ \n", "1880 KRISHNA 33 B+ \n", "2040 NARESH MUTHUKURU 27 B+ \n", "2058 A NIKITA 23 B+ \n", "2103 NAGADATTA PAVANKUMAR 25 B+ \n", "2116 PIYUSH AGARWALA 23 B+ \n", "2211 RAJNISH TRIPATHI 22 B+ \n", "2251 RAVI RAO 34 B+ \n", "2381 SHAURYA S 27 B+ \n", "2461 SIVAPRASAD SRINADHU 25 B+ \n", "2588 SHASHIVARDHAN REDDY T 29 B+ \n", "\n", " Address Contact Number \n", "1455 RAGHAVENDRA COLONY,KONDAPUR HYDERABAD 9676367432 \n", "1618 KONDAPUR, HYDERABAD 8886494333 \n", "1650 SHILPA PARK, KONDAPUR HYDERABAD 8860521564 \n", "1816 KONDAPUR HYDERABAD 9966172828 \n", "1880 KONDAPUR HYDERABAD 9912419944 \n", "2040 BOTANICAL GARDEN ROAD, KONDAPUR HYDERABAD 9966693811 \n", "2058 KONDAPUR HYDERABAD 9160641671 \n", "2103 KONDAPUR HYDERABAD HYDERABAD 7995639647 \n", "2116 MSR BUILDING, SRI RAM NAGAR, KONDAPUR HYDERABAD 8777283234 \n", "2211 1-110/A/93 GOPAL REDDY NAGAR SHILPA PARK KONDA... 9014886867 \n", "2251 303, SRI RAMACHANDRA RESIDENCY, KONDAPUR HYDER... 9789925580 \n", "2381 KONDAPUR, RAGHAVENDRA COLONY C BLOCK HYDERABAD 9160257815 \n", "2461 KONDAPUR HYDERABAD 9293790317 \n", "2588 PLOT# 6, 1-55/4/RP/L1, RAJA PRASADAM, KONDAPUR... 8886431947 " ] }, "execution_count": 97, "metadata": {}, "output_type": "execute_result" } ], "source": [ "required = str(input(\"Enter the Required Blood Group:\"))\n", "req = DF[DF['Blood Group']==required]\n", "\n", "Location = str(input(\"Enter Required Location:\"))\n", "l = str.upper(Location)\n", "req[req['Address'].str.contains(l)]" ] }, { "cell_type": "code", "execution_count": 40, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] }, { "cell_type": "code", "execution_count": null, "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.5.3" } }, "nbformat": 4, "nbformat_minor": 2 }