-
Notifications
You must be signed in to change notification settings - Fork 0
/
main_code.py
135 lines (107 loc) · 3.69 KB
/
main_code.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
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Thu Oct 31 23:15:56 2019
@author: abhishek
"""
f=open('sachin_test','r') #for importing the file containing data of test matches of sachin
sachin=f.readlines()
f2=open('sachinodi.csv','r') #for imorting the file containing data of ODI matches of sachin
sachinodi=f2.readlines()
#deciding column indexes
fields=sachin[0].split(',')
index_runs=fields.index('Runs') #use this to get the index of your desired column then make the function and use this variable
index_year=fields.index('Start Date')
************************************************************************************************************************
def average(l,index_runs,index_year): #for cal calculating the average runs per year for sachin_test
year=[]
del l[0]
l1=[]
y=[]
rows=len(l)
starting_year=0
for i in range(0,25):
su=0
n=0
for j in range(starting_year,rows):
l1=l[j].split(',')
y=l1[index_year].split(' ')
year.append(y[2])
t=year[0]
if(year[n]!=t):
break
if(l1[index_runs]!='-'): #only this part is the logic of average rest is for reading the vaules form the file
su=su+int(l1[index_runs]) #use this code just change the logic and indexes according to the desired columns
#and need
else:
su=su+0
n=n+1
starting_year=starting_year+n
l1.clear()
year.clear()
y.clear()
if(n!=0):
avg=su/n
print('average in year,',t,' = ',avg)
**************************************************************************************************
def runsum(l,index_runs,index_year): #for calculating the sum of runs made by the player in a year (question 8) @not yet plotted@
year=[]
del l[0]
l1=[]
y=[]
rows=len(l)
starting_year=0
for i in range(0,25):
su=0
n=0
for j in range(starting_year,rows):
l1=l[j].split(',')
y=l1[index_year].split(' ')
year.append(y[2])
t=year[0]
if(year[n]!=t):
break
if(l1[index_runs]!='-'):
su=su+int(l1[index_runs])
else:
su=su+0
n=n+1
starting_year=starting_year+n
l1.clear()
year.clear()
y.clear()
print('sum in year,',t,' = ',su)
*************************************************************************************************************************
def yearhighest(l,index_runs,index_year): #for calculating the highest and second highest runs made by the player in a year @not yet plotted@
year=[]
del l[0]
l1=[]
y=[]
rows=len(l)
starting_year=0
run_L=[]
for i in range(0,25):
run_L.clear()
n=0
for j in range(starting_year,rows):
l1=l[j].split(',')
y=l1[index_year].split(' ')
year.append(y[2])
t=year[0]
if(year[n]!=t):
break
if(l1[index_runs]!='-'):
run_L.append(int(l1[index_runs]))
else:
run_L.append(0)
n=n+1
run_L.sort()
Hrun=run_L[-1]
H2run=run_L[-2]
starting_year=starting_year+n
l1.clear()
year.clear()
y.clear()
print('higighest in year,',t,' = ',Hrun)
print('second highest in year,',t,' = ',H2run)
yearhighest(sachin,index_runs,index_year)