In python Note that it is possible to have someone write in the samename for multiple different offices, so you do need to becareful to only count occurrences of the name present inthe column representing the office you're counting votesfor.You are permitted to import the csv module, but this isnot required.Hints:Be careful when the request is for the last columnin the file - if you're splitting by comma, then thatcolumn will contain the '
' character, and thisshouldn't be included in the candidate names, orin the name of the office.You can assume for the sake of simplicity that nocandidate or office will contain a comma in thename.Disclaimer: The data in the CSV files was randomlygenerated from all names available on the ballot for agiven district according tohttps://myballotmn.sos.state.mn.us/ (along with a fewfictional characters to simulate write-ins). Don't take anygiven candidate randomly getting more "votes" thananother as an endorsement.Examples (assumes that you have the sample files fromhw09files.zip downloaded to the same directory thatyou're running Python in): count_votes('district_0z.csv', 'CountySheriff'){'Shallan Davar': 1, 'Liz Lemon': 3, 'RonSwanson': 1} count_votes('district_4b.csv','Mayor'){'Shelly Carlson': 7, 'Donna Meagle': 2,'Kevin Nese Shores': 5} count_votes('district_60b.csv','County Commissioner District 4'){'Angela Conley': 50, 'Monkey D. Luffy':1, 'Jobu Tupaki': 2, 'Leslie Knope': 1} Minnesota is holding elections on the day that thisassignment is due! We can help them count results bywriting a program. Assume that each district copilesvotes into a CSV file, where each row contains onecitizen's ballot data, and each column represents adifferent office up for election. The first row is headerdata indicating what office each column represents.MayorJobu TupakiEvelyn WangTrevor BelmontLeslie KnopeApril Ludgate●●County SheriffShallan DavarLiz LemonLiz LemonLiz LemonRon SwansonFor example, the CSV file above would represent adistrict with three offices up for election, and five citizenswho voted.GovernorBuffy SummersLeslie KnopeGordon Freemanand so on...Monkey D. LuffyBuffy SummersThe first voted for Jobu Tupaki for Mayor, ShallanDavar for Sheriff, and Buffy Summers forGovernor.The second voted for Evelyn Wang for Mayor, LizLemon for Sheriff, and Leslie Knope forGovernor.We're going to be creating a dictionary representing thevote counts for a specific office. For example, in thespreadsheet above, if I wanted a dictionary of vote countsfor the office of County Sheriff, the result would be:{'Shallan Davar': 1, 'Liz Lemon': 3, 'RonSwanson': 1}Whereas the vote counts for Governor would be:{'Buffy Summers': 2, 'Leslie Knope': 1,'Gordon Freeman': 1,'Monkey D. Luffy': 1}Write a function that count_votes (district,office) that takes in two strings as parameters.●district should be the name of a file containingall voting data for a given district, in the formatspecified above. You can assume that said fileactually exists (no need for a try-except block).• office should be the name of one of the columntitles present in the CSV file. You can assumethat the office passed in will match one of thecolumns in the CSV file.The function should return a dictionary in which eachkey is a name present in the column corresponding to thegiven office, and the value represents how many timesthat name occurs within the column.

Question

In python Note that it is possible to have someone write in the samename for multiple different offices, so you do need to becareful to only count occurrences of the name present inthe column representing the office you're counting votesfor.You are permitted to import the csv module, but this isnot required.Hints:Be careful when the request is for the last columnin the file - if you're splitting by comma, then thatcolumn will contain the '
' character, and thisshouldn't be included in the candidate names, orin the name of the office.You can assume for the sake of simplicity that nocandidate or office will contain a comma in thename.Disclaimer: The data in the CSV files was randomlygenerated from all names available on the ballot for agiven district according tohttps://myballotmn.sos.state.mn.us/ (along with a fewfictional characters to simulate write-ins). Don't take anygiven candidate randomly getting more &#34;votes&#34; thananother as an endorsement.Examples (assumes that you have the sample files fromhw09files.zip downloaded to the same directory thatyou're running Python in):>>> count_votes('district_0z.csv', 'CountySheriff'){'Shallan Davar': 1, 'Liz Lemon': 3, 'RonSwanson': 1}>>> count_votes('district_4b.csv','Mayor'){'Shelly Carlson': 7, 'Donna Meagle': 2,'Kevin Nese Shores': 5}>>> count_votes('district_60b.csv','County Commissioner District 4'){'Angela Conley': 50, 'Monkey D. Luffy':1, 'Jobu Tupaki': 2, 'Leslie Knope': 1} Minnesota is holding elections on the day that thisassignment is due! We can help them count results bywriting a program. Assume that each district copilesvotes into a CSV file, where each row contains onecitizen's ballot data, and each column represents adifferent office up for election. The first row is headerdata indicating what office each column represents.MayorJobu TupakiEvelyn WangTrevor BelmontLeslie KnopeApril Ludgate●●County SheriffShallan DavarLiz LemonLiz LemonLiz LemonRon SwansonFor example, the CSV file above would represent adistrict with three offices up for election, and five citizenswho voted.GovernorBuffy SummersLeslie KnopeGordon Freemanand so on...Monkey D. LuffyBuffy SummersThe first voted for Jobu Tupaki for Mayor, ShallanDavar for Sheriff, and Buffy Summers forGovernor.The second voted for Evelyn Wang for Mayor, LizLemon for Sheriff, and Leslie Knope forGovernor.We're going to be creating a dictionary representing thevote counts for a specific office. For example, in thespreadsheet above, if I wanted a dictionary of vote countsfor the office of County Sheriff, the result would be:{'Shallan Davar': 1, 'Liz Lemon': 3, 'RonSwanson': 1}Whereas the vote counts for Governor would be:{'Buffy Summers': 2, 'Leslie Knope': 1,'Gordon Freeman': 1,'Monkey D. Luffy': 1}Write a function that count_votes (district,office) that takes in two strings as parameters.●district should be the name of a file containingall voting data for a given district, in the formatspecified above. You can assume that said fileactually exists (no need for a try-except block).• office should be the name of one of the columntitles present in the CSV file. You can assumethat the office passed in will match one of thecolumns in the CSV file.The function should return a dictionary in which eachkey is a name present in the column corresponding to thegiven office, and the value represents how many timesthat name occurs within the column.

Accepted Answer

Step 1 : STARTStep 2 : import packagesStep 3 : implement the function count_votesStep 4 : input the…