Python program named "YourMuseumID_Exhibits.py" focusing on museum exhibit data: You have a list of dictionaries representing exhibits in a museum. Each dictionary contains the exhibit name, the number of artifacts on display, and the historical era it covers. Perform the following tasks: (a) Calculate and display the total number of artifacts on display for all exhibits in the museum. (b) Identify and display the exhibit with the highest number of artifacts on display. (c) Implement a function that takes a user-input exhibit name and searches for it in the list. If found, display the number of artifacts on display and the historical era it covers; if not found, print a message indicating that the exhibit is not in the museum. (d) Implement a sorting algorithm of your choice to sort the exhibits based on the number of artifacts on display in descending order and display the sorted list. Make sure to incorporate functions for each task and display the results in the main

Python program named "YourMuseumID_Exhibits.py" focusing on museum exhibit data: You have a list of dictionaries representing exhibits in a museum. Each dictionary contains the exhibit name, the number of artifacts on display, and the historical era it covers. Perform the following tasks: (a) Calculate and display the total number of artifacts on display for all exhibits in the museum. (b) Identify and display the exhibit with the highest number of artifacts on display. (c) Implement a function that takes a user-input exhibit name and searches for it in the list. If found, display the number of artifacts on display and the historical era it covers; if not found, print a message indicating that the exhibit is not in the museum. (d) Implement a sorting algorithm of your choice to sort the exhibits based on the number of artifacts on display in descending order and display the sorted list. Make sure to incorporate functions for each task and display the results in the main

Programming with Microsoft Visual Basic 2017

8th Edition

ISBN:9781337102124

Author:Diane Zak

Publisher:Diane Zak

Chapter8: Arrays

Section: Chapter Questions

Problem 22E

See similar textbooks

Similar questions

Data structures unique_values(a_dict:dict)-> dict This function will receive a single dictionary parameter known as a_dict. a_dict will contain a single letter as a string and numbers as values. This function is supposed to search a_dict to find all values that appear only once in the a_dict. The function will create another dictionary named to_ret. For all values that appear once in a_dict the function will add the value as a key in to_ret and set the value of the key to the key of the value in a_dict (swap the key-value pairs, since a_dict contains letters to numbers, to_ret will contain Numbers to Letters). Finally, the function should return to_ret. Example: a_dict: {'X': 2, 'Y': 5, 'N': 2, 'L': 2, 'W': 1, 'G': 0, 'R': 1} Expected: {5: 'Y', 0: 'G'} a_dict: {'Z': 3, 'P': 3, 'E': 2, 'G': 0, 'T': 5, 'L': 1, 'Q': 0} to_ret: {2: 'E', 5: 'T', 1: 'L'} a_dict: {'E': 3, 'X': 3} to_ret: {} a_dict: {'G': 3, 'D': 3, 'C': 4, 'Q': 1, 'H': 1, 'M': 2, 'Z': 1, 'W': 3} to_ret: {4: 'C', 2: 'M'}…
keys = ['name', 'last', 'job_title', 'email']Faculty2 = Faculty = dict.fromkeys(keys)print(Faculty2) Use the dictionaries that you created for faculty members. Be sure that all the dictionaries have the same keys: name, last name, etc. If there are keys or values missing, add them. If you do not have the value, you can use 'n/a' or 'TBD'. Make a list of the dictionaries. Loop the list to print all the information available to each faculty member. In Python lang please.
PYTHON CODE Using Artists.csv (link below), write a query that returns all lines that are female artists only, with begin date greater than 1950 but no greater than 2000 Write a query that will return all lines of British Male artists, who's first names starts with the letter ‘A’ and has an end date earlier than 1990 Write a query that will write to a file all lines that have Japanese Artists who’s difference of end date and begin date exceeds 100 years. I.e. if artist begins in 1900 and ends in 2005, then they would be included in the output (2005-1900 = 105 years) Write a query that will write and find to a file the artist who’s been at the Museum the longest (the widest gap between Begin Date and End Date) Artists.csv: https://media.githubusercontent.com/media/MuseumofModernArt/collection/master/Artists.csv
Computer Science please please any help ASAP Query #5: Code a query that will make use of SQL Server intrinsic functions and reference the Instructors table. Must have alias names for each column. First column: Display the instructors name as first name initial followed by a period and space and then last name such as B. Brown Second column: Display the year only for the hire date. Third column: Difference in months between today’s date and the hire date. Last column: Display the string literal ‘Full-time instructor’ if an instructor has a Status of F or return the string literal of ‘Adjunct instructor’ if they have a status of P. You can use the Case function or the IIF function.
calculate_new_balance Given a starting balance (a number), and a list of transaction tuples, calculate the final balance for an account. Transaction tuples are of the shape ("description", amount, "withdrawal") , or ("description", amount, "deposit"). The last entry in the tuple will be either "withdrawal" or "deposit". Every withdrawal decreases the balance of the account by the specified amount, and every deposit increases the balance. The return value is the new account balance, as a number. (which could be negative) Sample calls should look like: >>> calculate_new_balance(100, [("payday", 20, "deposit"), ("new shoes", 50, "withdrawal"), ("illicit winnings", 200, "deposit")])270>>> calculate_new_balance(100, [])100
Population Database You will find a program named CreateCityDB.java in Starting Out with Java: Early Objects (6th Edition) Chapter 15 Source Code. Compile and run the program (SEE BELOW). The program will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: Column Name Data Type CityName CHAR (50) Primary Key Population DOUBLE The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, write a JavaFX application called PopulationDemo that connects to the CityDB database and allows the user to click any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the…
Python program named "YourWarehouseID_Sales.py" focusing on sales data: You have a list of dictionaries representing products in a warehouse. Each dictionary contains the product name, quantity sold, and the unit price. Perform the following tasks: (a) Calculate and display the total revenue generated from the sales (sum of quantity sold* unit price for each product). (b) Identify and display the product with the highest total revenue (quantity sold* unit price). (c) Implement a function that takes a user-input product name and searches for it in the list. If found, display the quantity sold and the total revenue of that product; if not found, print a message indicating that the product is not in the sales data. (d) Implement a sorting algorithm of your choice to sort the products based on their total revenue in descending order and display the sorted list. Make sure to incorporate functions for each task and display the results in the main function with appropriate messages.
JAVA Script Create a form that has a last name, a first name, an email address, a drop-down listing of 10 cities in Massachusetts. The list is to be sorted (hint: think array), an email address, and a zip code field. Each field is to be process through a validation function. You may use one function for each but if you are creative you should be able to use just one function. The drop-down listing will not require validation because they will be choosing from a list that you are providing. This input from must be styled and show an effect to the user as to which field that are currently providing input.
LOGICAL EXPRESSIONS #15 SURGERY_DATE is a datetime column that stores the dates on which surgeries were performed. The time stored is midnight. Which of the following will return TRUE for surgeries performed in 2016 and FALSE for all other surgeries? SELECT ONE OF THE FOLLOWING A. SURGERY_DATE BETWEEN '31 DEC 2015' AND '31 DEC 2016' B. SURGERY_DATE BETWEEN '31 DEC 2015' AND '1 JAN 2017' C. SURGERY_DATE BETWEEN '1 JAN 2016' AND '31 DEC 2016' D. SURGERY_DATE BETWEEN '1 JAN 2016' AND '1 JAN 2017'
Assume, you are given two dictionaries. The dictionary named current_sem_data contains the GPA of 3 students of their current semester courses. The dictionary named previous_sem_data contains their previous semesters’ CGPA and credits completed respectively. Assume that all courses are of 3 credits each.current_sem_data = {"John":[4.0,3.7,4.0], "Tom":[3.3,3.7,4.0], "Harry":[3.3,3.7,4.0]}previous_sem_data = {"John":[3.88,90], "Tom":[3.52, 70], "Harry":[3.25,85]}Now, write a Python program that will take a student’s name as user input and calculate and print that student’s current CGPA using both the given dictionaries.FORMULA for calculating CGPA:current_total_GPA= ∑ (current course grade X credit)previous_total_GPA= Previous CGPA* total credits previouslyC.G.P.A = (current_total_GPA + previous_total_GPA)/(Total Credits completed till current semester)=======================================================Sample Input 1:JohnSample Output 1:*****Data for John*****Previous semester's…
In java create an application to manage your data base information the database is already created in mysql tables, the tables are fill, So the user can use your database application user friendly Retrieve all data: Given a table name, retrieve all data from the table and present it to the user. Average: Given a table name and a column name, return the average of the column. Here the assumption is that the column type will be numeric (e.g., cost column). Insert: Given a table name, your program should show the column names of that table and ask the users to input new data to the table. In case of errors, your program should directly show the MySQL errors to the users. Assumption 1: Users will enter data according to the database constraints. Assumption 2: Users will input one record at a time. Delete: Given a table name, your program should show the column names of that table and ask the users to input data that they want to delete. Assumption 1: Users will enter data according to the…
Assume, you are given two dictionaries. The dictionary named current_sem_data contains the GPA of 3 students of their current semester courses. The dictionary named previous_sem_data contains their previous semesters’ CGPA and credits completed respectively. Assume that all courses are of 3 credits each.current_sem_data = {"John":[4.0,3.7,4.0], "Tom":[3.3,3.7,4.0], "Harry":[3.3,3.7,4.0]}previous_sem_data = {"John":[3.88,90], "Tom":[3.52, 70], "Harry":[3.25,85]}Now, write a Python program that will take a student’s name as user input and calculate and print that student’s current CGPA using both the given dictionaries.FORMULA for calculating CGPA:current_total_GPA= ∑ (current course grade X credit)previous_total_GPA= Previous CGPA* total credits previouslyC.G.P.A = (current_total_GPA + previous_total_GPA)/(Total Credits completed till current semester)=======================================================Sample Input 1:JohnSample Output 1:*****Data for John*****Previous semester's…