Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- def Calculate(year1, year2, allData, response):
- # Main logic
- Increased = 0
- Decreased = 0
- KeptSame = 0
- TotalPlayers = 0
- for data in allData.iterrows():
- TotalPlayers = TotalPlayers + 1
- # Read columns per player
- playerId = data[1][0]
- if(year1 == 2015):
- playerYear1Overall = data[1][1]
- if(year1 == 2016):
- playerYear1Overall = data[1][2]
- if(year1 == 2017):
- playerYear1Overall = data[1][3]
- if(year1 == 2018):
- playerYear1Overall = data[1][4]
- if(year1 == 2019):
- playerYear1Overall = data[1][5]
- if(year2 == 2016):
- playerYear2Overall = data[1][2]
- if(year2 == 2017):
- playerYear2Overall = data[1][3]
- if(year2 == 2018):
- playerYear2Overall = data[1][4]
- if(year2 == 2019):
- playerYear2Overall = data[1][5]
- if(year2 == 2020):
- playerYear2Overall = data[1][6]
- if math.isnan(playerYear1Overall):
- playerYear1Overall = 0
- if math.isnan(playerYear2Overall):
- playerYear2Overall = 0
- # Calculate counts
- diff = playerYear2Overall - playerYear1Overall
- if int(diff) > 0:
- Increased = Increased + 1
- if diff < 0:
- Decreased = Decreased + 1
- if diff == 0:
- KeptSame = KeptSame + 1
- # Calculate percentages
- PercentageIncreased = Increased / float(TotalPlayers) * 100
- PercentageDecreased = Decreased / float(TotalPlayers) * 100
- PercentageKeptSame = KeptSame / float(TotalPlayers) * 100
- # Create dictionary for year data
- yearData = {}
- yearData['Increased'] = PercentageIncreased
- yearData['Decreased'] = PercentageDecreased
- yearData['KeptSame'] = PercentageKeptSame
- # Prepare response of the function
- response[year2] = yearData
- responseData = {}
- # Call each year combination
- Calculate(2015, 2016, merge5, responseData)
- Calculate(2016, 2017, merge5, responseData)
- Calculate(2017, 2018, merge5, responseData)
- Calculate(2018, 2019, merge5, responseData)
- Calculate(2019, 2020, merge5, responseData)
- # Initialize variables
- totalIncreased = 0
- totalDecreased = 0
- totalKeptSame = 0
- # Extract data from response dictionary
- for year in responseData.keys():
- totalIncreased = totalIncreased + responseData[year]['Increased']
- totalDecreased = totalDecreased + responseData[year]['Decreased']
- totalKeptSame = totalKeptSame + responseData[year]['KeptSame']
- # Initialize variables
- averageIncreased = 0
- averageDecreased = 0
- averageKeptSame = 0
- # Calculate averages
- averageIncreased = totalIncreased / float(5)
- averageDecreased = totalDecreased / float(5)
- averageKeptSame = totalKeptSame / float(5)
- print "Increased: " + str(averageIncreased)
- print "Decreased: " + str(averageDecreased)
- print "Kept Same: " + str(averageKeptSame)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement