Calculating baseball statistics in a file 5 points The Lahman Baseball Database is a comprehensive database of Major Leaguebaseball statistics. The journalist Sean Lahman provides all of this data freely to the public. We will make use of some of his data inthis assignment. If you would like to learn more about the database, you can visit his website. We provide you with a CSV filenamed batting.csv that contains the annual batting performance data for all Major League Baseball players dating back to the year1871. The first row in the file is a header indicating what data is stored in each column of the file. For example, column 12 is labeled"HR" and contains the number of home runs the player hit that year. Each of the next 99,846 lines contains a comma separated listof the data for that player and year. For example, the fifth line in the file indicates that a player with the ID allisdo01 hit 2 home runsin 1871. You should download batting.csv and place it in the same directory as your Python code. Your job will be to write a Pythonprogram that finds the player ID of the player with the highest total career RBIS of all time. But be careful: your program shouldwork with any similarly formatted CSV file! Data Input: Opening the file First, you will need to read in the data file. You can do thisby opening the file using the open function and iterating through each line (remember that you can use either read or readlines ; Istrongly urge the latter of these). To parse the data contained in each line, you will need to use the split method. We are interestedin two columns, 'playerID' and 'RBI' (Your program should skip the header in the file and completely ignore any lines where the RBIcolumn does not contain a digit.) You should create an accumulator dictionary called career_rbis that maps each player ID string toan integer representing the total number of RBIS for that player. As you iterate through the file, you should update the career_rbisdictionary. Duplicate entries should be summed.Data Processing: Finding the most RBIS After reading in the data and generating the "career_rbis" dictionary, you should nextiterate through the dictionary to find the player with the most career RBIS (thus summing duplicate entries). You will need twoaccumulator variables to track both the most RBIS you've seen so far AND the player having that many RBIS. Store an integerrepresenting the highest number of RBIS in a variable named max_rbis and the corresponding player id string in a variable namedmax_player. DO NOT try to write your code here. Debugging it here will be very difficult. You should write and test your code on anEWS computer or your own computer. Using files and directories When you submit code here, you should use open('batting.csv)with no directory path. On your own machine things may behave differently. Briefly, the best thing to do is to figure out wherePython is running and move your file batting.csv there. Otherwise you can try to find out where your file is located and refer to itdirectly using the code shared in lecture. You can also use the smaller batting_test.csv to test your code. Files: • batting.csv •batting_test.csvFiles: • batting.csv • batting_test.csv Your submission should include the following variables defined correctly: • career_rbismax_rbis max_playerStarter code (click to view) career_rbis = () # Open the file. Call it batting_file. ??? # Read the data from the file using a for loop. forline in batting_file.??: line = line.strip) # remove whitespace from the line values = ?? # split the line by commas" if values[ 0] =='playerID': continue # skip the header line batter_id = ??? # get the batter_id rbis = ??? # get the RBIS # ignore non-digit RBIS ??? #check if batter_id is in career_rbis if batter_id not in career_rbis: # add it ??? else: # add the RBIS career_rbis[ batter_id] = ?? #Find the player with the maximum RBIS. This will probably take # several lines of code and some serious thought on your part. ???

Question

Calculating baseball statistics in a file 5 points The Lahman Baseball Database is a comprehensive database of Major Leaguebaseball statistics. The journalist Sean Lahman provides all of this data freely to the public. We will make use of some of his data inthis assignment. If you would like to learn more about the database, you can visit his website. We provide you with a CSV filenamed batting.csv that contains the annual batting performance data for all Major League Baseball players dating back to the year1871. The first row in the file is a header indicating what data is stored in each column of the file. For example, column 12 is labeled&#34;HR&#34; and contains the number of home runs the player hit that year. Each of the next 99,846 lines contains a comma separated listof the data for that player and year. For example, the fifth line in the file indicates that a player with the ID allisdo01 hit 2 home runsin 1871. You should download batting.csv and place it in the same directory as your Python code. Your job will be to write a Pythonprogram that finds the player ID of the player with the highest total career RBIS of all time. But be careful: your program shouldwork with any similarly formatted CSV file! Data Input: Opening the file First, you will need to read in the data file. You can do thisby opening the file using the open function and iterating through each line (remember that you can use either read or readlines ; Istrongly urge the latter of these). To parse the data contained in each line, you will need to use the split method. We are interestedin two columns, 'playerID' and 'RBI' (Your program should skip the header in the file and completely ignore any lines where the RBIcolumn does not contain a digit.) You should create an accumulator dictionary called career_rbis that maps each player ID string toan integer representing the total number of RBIS for that player. As you iterate through the file, you should update the career_rbisdictionary. Duplicate entries should be summed.Data Processing: Finding the most RBIS After reading in the data and generating the &#34;career_rbis&#34; dictionary, you should nextiterate through the dictionary to find the player with the most career RBIS (thus summing duplicate entries). You will need twoaccumulator variables to track both the most RBIS you've seen so far AND the player having that many RBIS. Store an integerrepresenting the highest number of RBIS in a variable named max_rbis and the corresponding player id string in a variable namedmax_player. DO NOT try to write your code here. Debugging it here will be very difficult. You should write and test your code on anEWS computer or your own computer. Using files and directories When you submit code here, you should use open('batting.csv)with no directory path. On your own machine things may behave differently. Briefly, the best thing to do is to figure out wherePython is running and move your file batting.csv there. Otherwise you can try to find out where your file is located and refer to itdirectly using the code shared in lecture. You can also use the smaller batting_test.csv to test your code. Files: • batting.csv •batting_test.csvFiles: • batting.csv • batting_test.csv Your submission should include the following variables defined correctly: • career_rbismax_rbis max_playerStarter code (click to view) career_rbis = () # Open the file. Call it batting_file. ??? # Read the data from the file using a for loop. forline in batting_file.??: line = line.strip) # remove whitespace from the line values = ?? # split the line by commas&#34; if values[ 0] =='playerID': continue # skip the header line batter_id = ??? # get the batter_id rbis = ??? # get the RBIS # ignore non-digit RBIS ??? #check if batter_id is in career_rbis if batter_id not in career_rbis: # add it ??? else: # add the RBIS career_rbis[ batter_id] = ?? #Find the player with the maximum RBIS. This will probably take # several lines of code and some serious thought on your part. ???

Accepted Answer

Answer:-