-
Notifications
You must be signed in to change notification settings - Fork 0
/
best_bowler.py
30 lines (30 loc) · 1.1 KB
/
best_bowler.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
try:
import pandas as pd
except ImportError:
print('Pandas Library not Installed ! Install pandas and try again')
def ball():
delivery=pd.read_csv('deliveries.csv')
x=delivery['bowler'].value_counts()>200
y=x[x].index.tolist()
mask=delivery['bowler'].isin(y)
new_delivery=delivery[mask]
mask=new_delivery['over']>15
mew_delivery=new_delivery[mask]
out=['hit wicket', 'caught and bowled', 'caught', 'lbw', 'stumped', 'bowled']
print('''Menu:
1)Best Bowler (Wicket Taker)
2)Best Bowler (Best Economy)''')
ch=int(input("Enter Choice:"))
if(ch==1):
mew_delivery=mew_delivery[mew_delivery['dismissal_kind'].isin(out)]
a=mew_delivery.groupby('bowler')['dismissal_kind'].count()
b=mew_delivery.groupby('bowler')['ball'].count()/6
c=a/b
print(c.sort_values(ascending=False).head())
elif(ch==2):
a=mew_delivery.groupby('bowler')['total_runs'].sum()
b=mew_delivery.groupby('bowler')['ball'].count()/6
c=a/b
print(c.sort_values().head())
else:
print("Invalid Input!!")