9/23/24, 5:34 PM A21126511178_Sports.
ipynb - Colab
import pandas as pd
data=pd.read_csv('Sportdata.csv')
data.head(5)
data.describe()
data.shape
(7494, 13)
Country played maximum number of matches
var1=data['Team 1'].value_counts()
var2=data['Team 2'].value_counts()
var1+var2
https://colab.research.google.com/drive/1nr9BuUf24BeNVina_PgS63vEofAcOqiw#scrollTo=vMjKik3Dw12u&printMode=true 1/4
9/23/24, 5:34 PM A21126511178_Sports.ipynb - Colab
count
Team 1
India 1760
Australia 1718
Pakistan 1708
Sri Lanka 1532
West Indies 1462
New Zealand 1372
England 1328
South Africa 1122
Zimbabwe 948
Bangladesh 656
Kenya 298
Ireland 226
Scotland 174
Afghanistan 162
Canada 150
Netherlands 144
Bermuda 72
U.A.E. 70
Hong Kong 36
P.N.G. 20
Namibia 16
https://colab.research.google.com/drive/1nr9BuUf24BeNVina_PgS63vEofAcOqiw#scrollTo=vMjKik3Dw12u&printMode=true 2/4
9/23/24, 5:34 PM A21126511178_Sports.ipynb - Colab
East Africa 8
U.S.A. 6
dtype: int64
Top 3 winners
winner=data['Winner'].value_counts()
print(winner[:3])
Winner
Australia 1104
India 950
Pakistan 932
Name: count, dtype: int64
country that played most matches in home ground
filter = (data['Team 1']== data.Host_Country ) | (data['Team 2']==data.Host_Country)
home_ground=data[filter].Host_Country.value_counts()
print(home_ground.index.tolist()[0])
Australia
Performance of SriLanka
srilanka=data[(data['Team 1']=="Sri Lanka") | (data['Team 2']=="Sri Lanka")]
srilanka.Winner.value_counts().plot(kind='pie')
https://colab.research.google.com/drive/1nr9BuUf24BeNVina_PgS63vEofAcOqiw#scrollTo=vMjKik3Dw12u&printMode=true 3/4
9/23/24, 5:34 PM A21126511178_Sports.ipynb - Colab
<Axes: ylabel='count'>
Team played Most in Foreign Countries
f1=data['Team 1'] != data.Host_Country
f2=data['Team 2'] != data.Host_Country
df1=data[f1]['Team 1'].value_counts()
df2=data[f2]['Team 2'].value_counts()
df1.add(df2).index.tolist()[0]
'Pakistan'
https://colab.research.google.com/drive/1nr9BuUf24BeNVina_PgS63vEofAcOqiw#scrollTo=vMjKik3Dw12u&printMode=true 4/4
