Please make sure to answer in the pseudocode. Use pseudocode to describe a function you'd write to read in a text file of student grades andcalculate averages for each student. You do not know how many students the file containsrecords for. You may assume identical names in the file refer to the same student. Each studentshould have 15 scores. However, some students did not complete all the assignments, andthese students will have fewer than 15 scores. The missing scores should be counted as zeros.An incomplete sample of the data file is shown below:Steven 93Melissa 85Rose 100Stevan 75Charles 83(Hint: Consider using Maps)Pseudocode should explain enough that it could be easily converted into working code, but itdoes not need to be (in fact, shouldn't be), correct Java syntax. Think of it more as what youmight put in comments to explain what code is doing.

define HashMap<String, int> score open file using file reader BufferedReader br = new…

se pseudocode to describe a function you'd write to read in a text file of student grades and alculate averages for each student. You do not know how many students the file contains ecords for. You may assume identical names in the file refer to the same student. Each student hould have 15 scores. However, some students did not complete all the assignments, and ese students will have fewer than 15 scores. The missing scores should be counted as zeros. n incomplete sample of the data file is shown below:

se pseudocode to describe a function you'd write to read in a text file of student grades and alculate averages for each student. You do not know how many students the file contains ecords for. You may assume identical names in the file refer to the same student. Each student hould have 15 scores. However, some students did not complete all the assignments, and ese students will have fewer than 15 scores. The missing scores should be counted as zeros. n incomplete sample of the data file is shown below:

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

At the end of this and other textbooks, there usually is an index that lists the pages where a certain word appears. In this problem, you will create an index for a text but, instead of page number, you will use the line numbers. You will implement function index() that takes as input the name of a text file and a list of words. For every word in the list, your function will find the lines in the text file where the word occurs and print the corresponding line numbers (where the numbering starts at 1). You should open and read the file only once Create the python function as part of a python program. The data required for the function should be created in the python program and passed to the function. its an exercise pyrthon problem 6.27
using C++ In this exercise you would be using a text input file to store a number of students first and last names, and each students scores in test1, test2, midterm, final and homeworks. Now, you get all the stored in relevant arrays. Write a function that will accept all the scores and compute the average score for each student. You can pass only one student’s information at a time while calling the function. Write another function for the grade computation. Display your results with last name, first name, average score and grade for each student. Display should be on screen as well as in an output file.
post in python please and a coding editor too You are asked to help write a program that will help users purchase cookies. A user will input types of cookies and the number of cookies that they want, and your program will suggest how many boxes that they should order. There are 30 cookies per box, so your goal is to make sure that the user will buy enough boxes so that they will get the cookies that they want. Write a function cookie_order that takes a dictionary as a parameter containing cookie names as keys and numbers of those cookies as values. Have this function return a new dictionary that has cookie names and the number of boxes that should be purchased of each type. Hint: This means if someone wants 31 cookies, they need to buy 2 boxes of cookies of that type. You may want to consider using math.ceil for this problem. Examples: >>> cookie_order({'thin mints': 97}) {'thin mints': 4} >>> cookie_order({'thin mints':34, 'shortbread': 60, 'caramel delites': 71,…
Using C++ Write the section of code which takes an array of characters and copies it to another array of characters. At this point two arrays of characters should hold the same name. You will need to use one of the loop instructions to do this. You can't use any built in functions. Write a second section of code which concatenates two arrays of characters into a third array of characters. The first array (which holds the first name) will be copied into the third array and the second array (which holds the last name) will be concatenated onto the third array. Once you are done filling in the arrays you should output the two sentences below. You are given the example input and output below.Example Input: Input first name -> FredInput last name -> SmithExample output: Your first name is Fred and the copy of your first name is Fred. Your first name is Fred and your last name is Smith and the concatenation is FredSmith.
Write a python program that will open a file and place each line of text from the file into a Python list. This program will calculate total number of lines, words and characters in the file. Write a python function counter to calculate and return total number of lines, words and characters in a text (.txt) file. The count function needs to return total number of lines, words and characters from the function. Also the function will take two parameters: • fileName is the name of the file that need to be opened to calculate the file stats (# of lines, # of words and # of characters). • lineList – this is python list that contains that will add each line (strip of new line feed in the line) to the python list. #function count will open the file fileName and counts how many lines, words and chars # in the file, and place each line of the file in the lineList parameter. # The function must RETURN numOfLine, numOfWords, numOfChars as return value, # and lineList as parameter # # numOfLine:…
Write a function, named randomPassword, that generates a random password that takes noparameter. It will return the randomly generated password as its ONLY result. Display the randomlygenerated password in the main program. Password Criteria:o The password should have a random length of between 7 and 10 characters.o Each character should be randomly selected from positions 33 to 126 from the ASCII table. 1. You must import randint function directly and inline within the random package and it must be thefirst line of code in your program 2.Declaring and using FOUR constants 3. You must use the chr built-in function within your randomPassword function.4. Declaring the main function and invoking randomPassword function. 5. Please do NOT use any special formatting in your print statement.6. Do not use __main__ anywhere in your program code. Sample runs : Run 1. your random password is : "Y)IC>Vm Run 2. your random password is : WM,L8"7 this is the error I am getting Please let me…
Write a function, named randomPassword, that generates a random password that takes noparameter. It will return the randomly generated password as its ONLY result. Display the randomlygenerated password in the main program. Password Criteria:o The password should have a random length of between 7 and 10 characters.o Each character should be randomly selected from positions 33 to 126 from the ASCII table. 1. You must import randint function directly and inline within the random package and it must be thefirst line of code in your program 2.Declaring and using FOUR constants 3. You must use the chr built-in function within your randomPassword function.4. Declaring the main function and invoking randomPassword function. 5. Please do NOT use any special formatting in your print statement.6. Do not use __main__ anywhere in your program code. Sample runs : 1. your random password is : "Y)IC>Vm 2. your random password is : WM,L8"7
Problem Definition Task. Your task is to develop a python program that reads input from text file and finds if the alphanumeric sequence in each line of the provided input file is valid for Omani car license plate. The rules for valid sequences for car plates in Oman are as follows: Each sequence is composed of 1 to 5 digits followed by one or two letters. Digits cannot start with 0, for instance, 00, 011, or 09 are not valid digit sequences. The following list are the only valid letter combinations: ['A','AA','AB','AD','AR','AM','AW",'AY"', 'B', BA','BB','BD',"BR','BM',"BW',"BY', 'D','DA','DD','DR','DW','DY', 'R','RA','RR','RM','RW','RY', 'S','SS', 'M','MA','MB','MM','MW','MY", "W',"WA',WB',"wW', Y,YA','YB','YD','YR','YW',YY] Program Input/Output. Your program should read input from a file named plates.txt and write lines with valid sequences to a file named valid.txt. Any line from the input file containing invalid sequence should be written to a file named invalid.txt. Each line…
This problem needs to be solved in python. Write a function read_movies_data(f) that takes in a movies file and returns a pandas DataFrame, where the index is the movie id and the columns are "title", "year", and "genre" (in that order). movies_df = read_movies_data("moviesSample.txt") assert movies_df.shape == (9, 3)assert movies_df.iloc[2, 2] == "Comedy"assert movies_df.loc[6, "title"] == "Heat"assert all(movies_df.columns == ["title", "year", "genre"])assert list(movies_df.index) == [1, 2, 3, 4, 5, 6, 8, 9, 10] NOTE: Make sure all of the asserts work The moviesSample.txt looks like this: 1|Toy Story|1995|Adventure2|Jumanji|1995|Adventure8|Tom and Huck|1995|Adventure3|Grumpier Old Men|1995|Comedy4|Waiting to Exhale|1995|Comedy5|Father of the Bride Part II|1995|Comedy6|Heat|1995|Action9|Sudden Death|1995|Action10|GoldenEye|1995|Action NOTE: Try to sent screenshots of the code working.
PLEASE ASSIST ON THE BELOW REVIEW Before the user can read an email, they have to see the emails. To achieve this, your program should first of all determine which emails have not been read and return that to the user. Then the user can choose. The emails should be numbered so that the user can provide the number as the index. Consider using the enumerate function to achieve this. I realise that there are no emails within the email box , kindly add some dummy emails in this list so that at least there is something within the inbox list.Do the same for marks as spam. Present to the user all the emails that have not been marked as spam for the user to mark as spam.Most importantly, your code is not well indented. Try to work on your indentation as it makes your code easier to read and the logic easier to follow. Indentation is key in python to define the blocks of statements. The number of spaces must be uniform in a block of code. It is preferred to use four whitespaces instead of tabs…
Step 3. Your starting code has a function readNames returns an array of student names. The temporary code you were given always returns the same five names shown above (Ava, Ben, ...). Now you will change this function so that it reads from StdIn an integer N 2 0, followed by N names. You can assume that after N, the input will always be exactly N names, each on one line that could be read using the function StdIn.readString . There are several example data files in the directory that conform to this specification. For example names3.txt contains 3 names (Ava, Ben and Carol). Your function should return an array containing those N student names. For example, if you provide the file names3.txt on StdIn your version of readNames would return the three names in that text file, and the output would be: $ java-introcs ZoomRooms greedy 3 < names3.txt Room: 0 Ava Ben Carol Room: 1 Note that with the code we have so far we will always print out exactly two rooms, regardless of the number of…
The average amount Sold function is not run as expect. Please fix it. The input file: sales.txt header in picture. It is over 5000 char. I can't copy. 13492785 2017 Jane North; 1000 78534520 2012 Tim South; 95020192756 2017 Linda East; 15000 19273458 2012 Paul West; 500078520192 2017 Mary Jane Doe; 5001 32278520 2012 Victor Smith; 799514278520 2012 Mary Johnson; 12056192785 2017 Tom Baker; 1300 88278529 2012 Diana Newman; 150089278527 2012 William Peterson; 1420098278528 2012 Jim Gaddis; 120099192785 2017 Laura King; 1000 43278524 2012 Ann McDonald; 2000 The output expect: in picture. #include "Sales.h"#include <iostream>#include <sstream>#include <iomanip>#include <fstream>#include <string>using namespace std; const int MAX_SIZE = 30; void readData(string fileName, Sales salesArr[], int n);double calcSalesAvg(Sales salesArr[], int n);void displayOverAvg(Sales salesArr[], int n, double avg);void writeReport(Sales salesArr[], int n, string…