you' still have to select the cells for each of the , -plus counties even if it takes just few seconds to calculate county' population by handthis would take hours to do for the whole spreadsheet in this projectyou'll write script that can read from the census spreadsheet file and calculate statistics for each county in matter of seconds this is what your program does reads the data from the excel spreadsheet counts the number of census tracts in each county counts the total population of each county prints the results this means your code will need to do the following open and read the cells of an excel document with the openpyxl module calculate all the tract and population data and store it in data structure write the data structure to text file with the py extension using the pprint module step read the spreadsheet data there is just one sheet in the censuspopdata xlsx spreadsheetnamed 'population by census tract'and each row holds the data for single census tract the columns are the tract number ( )the state abbreviation ( )the county name ( )and the population of the tract (dopen new file editor tab and enter the following code save the file as readcensusexcel py #python readcensusexcel py tabulates population and number of census tracts for each county import openpyxlpprint print('opening workbook 'wb openpyxl load_workbook('censuspopdata xlsx'sheet wb['population by census tract'countydata {todofill in countydata with each county' population and tracts print('reading rows 'for row in range( sheet max_row )each row in the spreadsheet has data for one census tract state sheet['bstr(row)value county sheet['cstr(row)value pop sheet['dstr(row)value todoopen new text file and write the contents of countydata to it working with excel spreadsheets