
Concept explainers
Python Programming - Creating DataFrame (Assignment Details)
Introduction:
In this assignment students are to create a program that allows user to student names and scores, the program is to also allow defining the subject the grades are being entered for. The entered information is to be stored in a DataFrame
Instructions:
For this assignment, you will do the following
Part 1
As explained in the introduction above, the program is for saving student scores for a specific number of tests.
- First, the program is to ask user how many tests are the grades for. If 3 entered for instance, the program is to ask user to enter test names. This would be used as indices for the grades that will be entered.
- Next, the program is to ask user the number of students they would like to enter grades for. Then the program is to ask user to enter dictionary information as following:
- Student Name
- List of grades (3 grades minimum)
Note: it’s important that the program allows entering name and grades for more than one student.
Make sure that a dataFrame is created to store all of the information collected.
3. Display the DataFrame content and verify that test names were assigned as labels for each row.
An example of the outcome is shown below in the attached image.
Submit your finished code solution file(s) through the assignment link below.
Note: Write program Pseudocode (detail


Trending nowThis is a popular solution!
Step by stepSolved in 3 steps with 2 images

- C program Create a dice game that uses two six‐sided dice. Each time the program runs, use random numbers to assign values to each die variable. Output a “player wins” message to the user if the sum of the two dice is 7 or 11. Otherwise, output the sum of the two dice and thank the user for playing.arrow_forwardc++arrow_forward1. Complete an algorithm, code and compile the following program. Save the program as mathTutor.py. Math Tutor You will be creating a math tutor program that can be used for young children to practice their math skills. The program will be driven by the following menu: See Rules Practice Math Exit If the user chooses (1) from the menu, the following rules will be displayed: This program will help you practice your math skills. First, you will choose Addition, Subtraction or Multiplication. Next, you will choose a level. Level 1 will give you problems with single digits and Level 2 will use two-digit numbers. Then, you will choose how many math problems you would like to complete. After you have completed all your problems, you will be given a score. You can play as many times as you want. Have fun!! If the user chooses (2) from the menu: First, prompt from the following math operation menu: Addition Subtraction Multiplication Next, prompt from the following level menu:…arrow_forward
- Problem Statement for Stock Transaction Program George uses the services of a brokerage firm to buy and sell stocks. Each time he buys or sells a block of stocks, he must pay the brokerage firm a commission of 1.5% per share.Design a program that allows George to enter the number of shares in the block, the price per share when he bought the block and the price per share when he sold the block. The program should display the amount of money he paid to buy the stock and the amount of the commission. The amount of money he made when he sold the stock and the amount of the commission, the amount of profit (or loss) he madeafter paying for the purchase cost and both commissions. There are three user inputs for this problem: the number of shares in the block, the price per share when the block was bought, the price per share when the block was sold. There is one constant: the percentage of the commission (1.5%) The amount to buy the stock is: number of shares in block * purchase price per…arrow_forwardC++ Visual Studio Modify the following program so it displays a menu allowing the user to select an addition, subtraction, multiplication, or division problem. The final selection on the menu should let the user quit the program. After the user has finished the math problem, the program should display the menu again. This process is repeated until the user chooses to quit the program. Input Validation: If the user selects an item not on the menu, display an error message and display the menu again. Code: #include <iostream>#include <cstdlib>#include <ctime>#include <conio.h> using namespace std; int main() {srand(static_cast<unsigned int>(time(nullptr))); while (true) {// Generate two random numbers.int num1 = rand() % 1000;int num2 = rand() % 1000; // Display the problem.cout << "Solve the following math problem:" << endl;cout << num1 << " + " << num2 << endl; // Wait for user input to reveal the answer.cout <<…arrow_forwardPython programmingarrow_forward
- python onlystart from here: def ask_for_age(): age = int(input('Enter the age of a family member: ')) return agearrow_forwardPYTHON!!! The credit plan at TidBit Computer Store specifies a 10% down payment and an annual interest rate of 12%. Monthly payments are 5% of the listed purchase price, minus the down payment. Write a program that takes the purchase price as input. The program should display a table, with appropriate headers, of a payment schedule for the lifetime of the loan. Each row of the table should contain the following items: The month number (beginning with 1) The current total balance owed The interest owed for that month The amount of principal owed for that month The payment for that month The balance remaining after payment The amount of interest for a month is equal to balance × rate / 12. The amount of principal for a month is equal to the monthly payment minus the interest owed. An example of the program input and output is shown below: Enter the puchase price: 200 (SEE IMAGE FOR PURCHASE PRICE CHART) Results you should get: Input: 200 Output: Purchase price: 200…arrow_forwardC# languagearrow_forward
- Asking help for Java Programming Create a program that simulates a meeting reservation system. Part 1: Basic requirements The program shall allow the user to select from the following options: Create a new meeting Show meetings on the calendar Clear all meetings Each meeting has a subject, start day/time and end day/time Subject is a short text description of the meeting Day is a date that contains month, day, and year Meeting times need only deal with hour and minute When the user wants to create a new meeting, the program asks for the subject, start and end day/times for it and adds it to the calendar For the basic requirements, meetings are not allowed to overlap. If a meeting the user wants to schedule overlaps with an existing meeting, the program presents an error message showing which meeting the one the user wants to schedule overlaps with When the user wants to show all meetings for the week, the report displays all meetings each day as follows Show all meetings…arrow_forwardPython Programming Only Please: Write a program that asks the user to enter a person’s age. The program should displaya message indicating whether the person is an infant, a child, a teenager, or an adult. Following are the guidelines: • If the person is 1 year old or less, he or she is an infant.• If the person is older than 1 year, but younger than 13 years, he or she is a child.• If the person is at least 13 years old, but less than 20 years old, he or she is a teenager.• If the person is at least 20 years old, he or she is an adult.arrow_forwardWeek runners log Coding in Python and mainly using loops create a program base on the following; Mike, Tina, Jason, Vicky, and Tammy are preparing for an upcoming marathon. Each day of the week, they run a certain number of miles and write them into a notebook. At the end of the week, they would like to know the number of miles run each day, the total miles for the week, and average miles run each day, Write a program to help them analyze their data. Your program should create a two-dimensional list of five rows and seven columns to store the number of miles run by each runner each day. Sample Output Name Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Average =============================================Mike 10.00 15.00 20.00 25.00 18.00 20.00 26.00 19.14Tina 15.00 18.00 29.00 16.00 26.00 20.00 23.00 21.00Jason 20.00 26.00 18.00 29.00 10.00 12.00 20.00 19.29Vicky 17.00 20.00 15.00 26.00 18.00…arrow_forward
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education





