Question: Use only python for following Questions. 1. Read the Montreal Canadiens data from below table into a Pandas DataFrame. 2. Calculate the total goals for

 Use only python for following Questions. 1. Read the Montreal Canadiens

data from below table into a Pandas DataFrame. 2. Calculate the total

Use only python for following Questions. 1. Read the Montreal Canadiens data from below table into a Pandas DataFrame. 2. Calculate the total goals for all players combined and output to the console. 3. Calculate the mean +/- for the team and output to the console. 4. Calculate the mean for the pp (penalty minutes) for the team and output to the console. 5. Generate an array of shooting percentages for all players on the team and output the array to the console. 6. Create an array of the average of points per game for each player and output to the console. glossary labels Ice Time GP Games Played Scoring G -- Goals A Assists PTS Points Plus/Minus +/- Plus/Minus PIM Penalties in Minutes Goals EV PP SH GW Even Strength Goals Power Play Goals Short-Handed Goals Game-Winning Goals Assists EV Even Strength Assists PP Power Play Assists SH Short-Handed Assists Shots on Goal S -- Shots on Goal SS Shooting Percentage Age GP G +/- PIM EV PP SH GW S 50 32 34 wa 19 o 0 13 2. 16 m 45 10 11 18 10 14 16 3 19 19 18 6 29 11 15 5 11 0 0 0 a 12 14 5 9 17 26 8 142 1 2 0 0 1 0 3 1. Pos 29 RW 29 C 30 LW 24 C 28 W 22 RW 36 D 23 C 28 C 28 D 26 LW 22 LW 32 D 27 RW 26 D 27 C 24 LW 27 D 22 D 20 RW 20 C 23 D 21 d 30 C 1 Player 2 Bernie Geoffrion 3 Jean Beliveau 4 Dickie Moore 5 Henri Richard 6 Marcel Bonin Bill Hicke 8 Doug Harvey 9 Ralph Backstrom 10 Don Marshall 11 Jean-Guy Talbot 12 Jean-Guy Gendron 13 Gilles Tremblay 14 Tom Johnson* 15 Claude Provost 16 Albert Langlois 17 Phil Goyette 18 Andre Pronovost 19 Bob Turner 20 J.C. Tremblay 21 Bobby Rousseau 22 Cliff Pennington 23 Jean Gauthier 24 Wayne Connelly 25 Glen Skov 26 5 2 17 2 0 64 69 57 70 65 70 58 69 70 70 44 45 70 49 61 62 21 60 30 15 4 4 3 3 6 0 3. 0 0 0 1 3 0 51 4 54 32 316 324 188 274 124 151 63 152 127 80 75 75 83 131 57 89 39 17 47 34 7 3 8 0 -4 6. 0 7 1 7 1 4 12 11 1 7 1 0 1 0 0 0 0 do N 0 0 1 0 5 -4 16 mo 1 1 1 0 0 0 0 1 0 0 0 4 ON 0 0 0 0 0 0 0 00 0 0 0 0 0 8 o o 3 1 0 0 o 0 O O O o 0 0 Use only python for following Questions. 1. Read the Montreal Canadiens data from below table into a Pandas DataFrame. 2. Calculate the total goals for all players combined and output to the console. 3. Calculate the mean +/- for the team and output to the console. 4. Calculate the mean for the pp (penalty minutes) for the team and output to the console. 5. Generate an array of shooting percentages for all players on the team and output the array to the console. 6. Create an array of the average of points per game for each player and output to the console. glossary labels Ice Time GP Games Played Scoring G -- Goals A Assists PTS Points Plus/Minus +/- Plus/Minus PIM Penalties in Minutes Goals EV PP SH GW Even Strength Goals Power Play Goals Short-Handed Goals Game-Winning Goals Assists EV Even Strength Assists PP Power Play Assists SH Short-Handed Assists Shots on Goal S -- Shots on Goal SS Shooting Percentage Age GP G +/- PIM EV PP SH GW S 50 32 34 wa 19 o 0 13 2. 16 m 45 10 11 18 10 14 16 3 19 19 18 6 29 11 15 5 11 0 0 0 a 12 14 5 9 17 26 8 142 1 2 0 0 1 0 3 1. Pos 29 RW 29 C 30 LW 24 C 28 W 22 RW 36 D 23 C 28 C 28 D 26 LW 22 LW 32 D 27 RW 26 D 27 C 24 LW 27 D 22 D 20 RW 20 C 23 D 21 d 30 C 1 Player 2 Bernie Geoffrion 3 Jean Beliveau 4 Dickie Moore 5 Henri Richard 6 Marcel Bonin Bill Hicke 8 Doug Harvey 9 Ralph Backstrom 10 Don Marshall 11 Jean-Guy Talbot 12 Jean-Guy Gendron 13 Gilles Tremblay 14 Tom Johnson* 15 Claude Provost 16 Albert Langlois 17 Phil Goyette 18 Andre Pronovost 19 Bob Turner 20 J.C. Tremblay 21 Bobby Rousseau 22 Cliff Pennington 23 Jean Gauthier 24 Wayne Connelly 25 Glen Skov 26 5 2 17 2 0 64 69 57 70 65 70 58 69 70 70 44 45 70 49 61 62 21 60 30 15 4 4 3 3 6 0 3. 0 0 0 1 3 0 51 4 54 32 316 324 188 274 124 151 63 152 127 80 75 75 83 131 57 89 39 17 47 34 7 3 8 0 -4 6. 0 7 1 7 1 4 12 11 1 7 1 0 1 0 0 0 0 do N 0 0 1 0 5 -4 16 mo 1 1 1 0 0 0 0 1 0 0 0 4 ON 0 0 0 0 0 0 0 00 0 0 0 0 0 8 o o 3 1 0 0 o 0 O O O o 0 0

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!