Please answer in python 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. 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 '\n' 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}

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

Minnesota is holding elections on the day that this assignment is due! We can help them count results by writing a program. Assume that each district copiles votes into a CSV file, where each row contains one citizen's ballot data, and each column represents a different office up for election. The first row is header data indicating what office each column represents.

Minnesota is holding elections on the day that this assignment is due! We can help them count results by writing a program. Assume that each district copiles votes into a CSV file, where each row contains one citizen's ballot data, and each column represents a different office up for election. The first row is header data indicating what office each column represents.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Create a php file for this task. Depending on whether "Top Scorers" or "Leaders" has been clicked, you need to display the top 10 teams sorted by their total scores or total points earned. You have to read the whole CSV file when calculating total scores and total points. Top Scorers Display a table with two columns: Team and Scores. The team that has the highest number of scores is displayed first. You have to display the top 10 teams only. Note: in the CSV file, for the first row, you will see something like Arsenal FC,4-3,Leicester City FC that means for this particular match, Arsenal FC scored 4 and Leicester City FC scored 3. This rule applies to all other rows as well. For this "Top Scorers" display, you need to calculate the total score of every team and then display the top 10 teams. Leaders Display a table with two columns: Team and Points. The team that has the highest number of points is displayed first. You have to display the top 10 teams only. Note: in the CSV file, for…
Create a data file with 1000 lines. Each line in the file consists of a faculty first name, last name, rank, and salary. Faculty’s first name and last name for the ith line are FirstNamei and LastNamei. The rank is randomly generated as assistant, associate, and full. The salary is randomly generated as a number with two digits after the decimal point. The salary for assistant professor should be in the range from 50,000 to 80,000, for associate professor from 60,000 to 110,000, and for full professor from 75,000 to 130,000. Save the file in salary.txt. Here are some sample data:FirstName1 LastName1 assistant 60055.95FirstName2 LastName2 associate 81112.45……FirstName1000 LastName1000 full 92255.21 I'm using Python.
Create a data file with 1,000 lines. Each line in the fileconsists of a faculty member’s first name, last name, rank, and salary. Thefaculty member’s first name and last name for the ith line are FirstNamei andLastNamei. The rank is randomly generated as assistant, associate, and full.The salary is randomly generated as a number with two digits after the decimalpoint. The salary for an assistant professor should be in the range from 50,000to 80,000, for associate professor from 60,000 to 110,000, and for full professorfrom 75,000 to 130,000. Save the file in Salary.txt. Here are some sample data:FirstName1 LastName1 assistant 60055.95FirstName2 LastName2 associate 81112.45. . .FirstName1000 LastName1000 full 92255.21
Using Pandas library in python - Calculate student grades project Pandas is a data analysis library built in Python. Pandas can be used in a Python script, a Jupyter Notebook, or even as part of a web application. In this pandas project, you’re going to create a Python script that loads grade data of 5 to 10 students (a .csv file) and calculates their letter grades in the course. The CSV file contains 5 column students' names, score in-class participation (5% of final grade), score in assignments (20% of final grade), score in discussions (20% of final grade), score in the mid term (20% of final grade), score in final (25% of final grade). Create the .csv file as part of the project submission Program Output This will happen when the program runs Enter the CSV file Student 1 named Brian Tomas has a letter grade of B+ Student 2 named Tom Blank has a letter grade of C Student 3 named Margo True has a letter grade of A Student 4 named David Atkin has a letter grade of B+ Student 5 named…
A bucket list is a collection of goals, dreams, and aspirations that you would like to accomplish within your lifetime. The purpose of this assignment is to develop a program that allows the user to manage their personal bucket list and save it to an XML file bucketlist.xml. For full credit, run the program and create a file with at least three entry elements. Submit a document containing a copy of the source file, a screenshot of the program in action, and the contents of the XML file. File Structure Below is the basic structure (i.e. schema) for the XML file. You may add additional elements. <bucketList> <entry> <rank></rank> <description></description> <status></status> </entry> </bucketList> Note: Before running the program, manually create an XML input file with at least one entry element that contains values in each child element. GUI Requirements At a minimum, your GUI must meet the below requirements. No minimize…
A Stationery supplier “Adwaat Al Maktabiyah” needs a program to display sales as per regions and add the sales to the file called sales.txt. The files Personal Details.txt and Sales.txt have been provided. You may download and use them in your program. They are as shown below: PersonalDetails.txt Id First name Last Name Region E111 Alvin Jones East C121 Blake Kivell Central C253 Edda Jardine Central Sales.txt Rep_Id OrderDate Region Item Units UnitCost E111 1/6/2020 East Pencil 95 1.99 C121 1/23/2020 Central Binder 50 19.99 C253 2/9/2020 Central Pencil 36 4.99 Note: - Use structures in the coding and declare structure array as public as shown below. The question 7 doesn’t need arrays. Structure personaldetails Dim rid As String ' Employee id Dim fn As String 'First name Dim ln As String 'Last name Dim rn As String ' Region he belongs to End Structure Structure Regionalsales Dim id As String 'employee id Dim od As Date 'Order Date Dim region As String…
In Python Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents…
There is a csv file called Air_Quality.csv. It has 12 columns and 17,000 rows. One column titled 'Name' which has a various emissions listed in it. Another column titled 'Geo Place Name' has a list of cities. Write a code (in the most basic Python) which finds the two emissions called PM2.5-Attributable Respiratory Hospitalizations (Adults 20 Yrs and Older) and PM2.5-Attributable Respiratory Hospitalizations (Adults 40 Yrs and Older)within the column and prints out which city has the respiratory hospitalizations for both 20 years and older and 40 years and older based on a column called 'Data Value' Below is a picture of a small chunk of the csv file.
The delivery drones have a internal reporting and logging system thatrecords events and issues during flights. These logfiles contain the last 1000events/messages as well as their status codes.The Logfile FormatBy default, the logfiles are all called ‘logfile.txt’. Each logfile is exactly 1000 lineslong.Each entry in the file consists of 4 fields:1. a line number (starting at 0)2. a POSIX timestamp3. a message/event type4. an event descriptionEach field (line number, timestamp etc.) is separated by a space, except for thedescription which ends with a full stop.Log events come in three different types: NOTIFY, WARNING, and ERROR. Task 1: Display Because the logfiles are so big, we would only like to display a certain number oflines at a time. We prompt the user to choose start and end line numbers andprint all the lines from start to end (inclusive).The input constraints are as follows: 0 start end 999You can safely assume that the inputs will fall within that…
For items 1–3, use the IN300_Dataset1.csv file. Write a Python program that reads the CSV file into a Panda dataframe. Using that dataframe, print the row, source IP, and destination IP as a table. Write a Java program that reads the CSV file into an ArrayList. Convert the ArrayList to a string array and print the row, source IP, and destination IP on the same line using a loop. Write an R program that reads the CVS file using the read.csv data type. Print the row, source IP and destination IP of each line.
A temperature file consists of five records, each containing a temperature in degrees Fahrenheit. A program is to be written that will read the input temperature, convert it from degrees Fahrenheit to degrees Celsius and print both temperatures in two columns on a report. Column headings, which read ‘Degrees F’ and ‘Degrees C’, are to be printed at the top of the page. What ist he best solution algorithm to successfully implement the above question?
Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of movies.csv…