Q. Write a python program that creates an excel file containing Student Record: Roll No.,Name, Marks of 6 subjects out of 100 each. Read multiple records from the user and save them in file. Once the user has entered all the records. Calculate the average marks of each student and assign them grades accordingly. Store these two columns in the same file. Don't use pointers and arrays keep the program as simple as possible for beginners level Paste the screenshots of full program with output

Q. Write a python program that creates an excel file containing Student Record: Roll No.,Name, Marks of 6 subjects out of 100 each. Read multiple records from the user and save them in file. Once the user has entered all the records. Calculate the average marks of each student and assign them grades accordingly. Store these two columns in the same file. Don't use pointers and arrays keep the program as simple as possible for beginners level Paste the screenshots of full program with output

C++ for Engineers and Scientists

4th Edition

ISBN:9781133187844

Author:Bronson, Gary J.

Publisher:Bronson, Gary J.

Chapter8: I/o Streams And Data Files

Section8.5: A Case Study: Pollen Count File Update

Problem 5E

See similar textbooks

Similar questions

Write a program that expands on the program below (i.e. reading data of each record in the file and storing it into data structure). The expansion involves writing all records to a file (use fprintf, call the name of the file csv). The displayed data must be accessed (and thus written) from data structure (i.e. array of structs). The format written to the file should be one line per record, with each field separated by a comma (‘,’) program should then output the number of lines in the file.test the program by creating a text file with at least 10 lines of text (of any composition). Use notepad++ to create the data file. #include<stdio.h>#include<stdlib.h> //Structurestruct Person{ char name[10];int age;float wage; }; //Main int main (int argc, char **argv) { FILE* f; if (argc != 2) { printf("No filename in the argument"); return 1; } f = fopen(argv[1], "r"); if (f == NULL) { printf("The file cannot be opened successfully:…
Write a program in C++ to do the following: 2. Create an array to hold up to 20 integers. 3. Create a data file or download attached text file (twenty_numbers.txt) thatcontains UP TO 20 integers.4. Request the input and output file names from the user. Open the filesbeing sure to check the file state.5. Request from the user HOW MANY numbers to read from the data file,up to twenty. Request the number until the user enters 20 or less, but not lessthan 0. The user enters the number of integers to read. The integers are storedin the file and are to be read from the file.6. Write a function that reads from the opened data file: the numberof integers the user wants to read, and store the numbers inthe array. For example, if the user wants to read 13 numbers,read 13 of the 20 that may be in the file.7. Write a function that writes to the opened output file AND THECONSOLE, the numbers stored in the array.8. NO GLOBAL variables are to be used. The input and output file variablesmust be passed…
Write a program to read the file numbers.txt created in part 1 that was saved to your home directory. As you read each number, keep track of how many times each of the numbers appear in the file (use a dictionary with the number as the key and count as the value). Print the count of each number and the sum of all the numbers in the file.
Question 1: Use Python (Class Average: Writing Student Records to a CSV File) An instructor teaches a class in which each student takes three exams. The instructor would like to store this information in a file named grades.csv for later use. Write code that enables an instructor to enter each student’s first name and last name as strings and the student’s three exam grades as integers. Use the csv module to write each record into the grades.csv file. Each record should be a single line of text in the following CSV format: firstname, lastname, exam1grade, exam2grade, exam3grade Question 2: (Class Average: Reading Student Records from a CSV File) Use the csv module to read the grades.csv file from the previous exercise (exercise 9.3). Display the data in tabular format, including an additional column showing each student’s average to the right of that student’s three exam grades and an additional row showing the class average on each exam below that exam’s column.
Write a program in C++ that creates a file. Write this data into that file column wise as a header. Then keep adding data in colum wise format. The program should check if there is data in the file and then write the data in the next row. First add: TIME DAY MONTH YEAR Then check the file and add: 01:25 07 JUNE 2008 Then check again the file and add this in next row: 14:00 30 MARCH 2019
Write a program which reads from the keyboard the names of two files containing two doublenumbers. Your program should read these two values from the two files, compute their sum, dif-ference, product and division, and write the results on separate lines into the file “results.txt”.You can safely assume that the input is valid, the two input files exist and each contains one validdouble value.(please solve in C programming language).
For an e-Shop, there is a Customer whose data is stored in a file ‘Customers.txt’, where ID, Name, Phone, Address, Email and AmountBalance. When the customer buys a product and pays from his AmountBalance, the system checks his balance and deducts if enough amount is there. Otherwise the customer receives a message “You don’t have sufficient Balance in your wallet”. Write python code to create a ‘Customers.txt’ file with at least one customer’s record. Write a function pay(), that takes amount as an input, reads the file and gets AmountBalance, print “Successful Transaction” when payment can be made or a message “You don’t have sufficient Balance in your wallet”. Write a function checkBalance(), that reads the file and gets AmountBalance, prints “Amaount Balance” Write a function recharge(), that takes “Enter Amount you want to recharge”, reads the file and gets AmountBalance, adds the new amount in AmountBalance, update the file and prints “Success”
2. This involves a .txt file with one thousand rows of random numbers (between 1-1000) Using Python, create a program to perform this task, with 3 methods of doing this: Read the entire contents of file1.txt into memory, then process each row. Read one row of file1.txt at a time and process it. Split file1.txt into 2 parts and read each part into memory separately.
Python Pandas: Suppose I have a file with columns I want to specify the spacing so that there are 5 spaces between the columns, how do I do this? file1 12 12.3 9.3 23 3.5 45.6 34 6.1 88.9
In Python: Build a function that takes a record from your FASTA file as an argument, and returns a count of each amino acid coded for by the codons of the sequence. Keep in mind that because these records are not necessarily in the proper reading frame, so the user should be prompted to select a reading frame (0, +1, +2). You should put some thought into the presentation of your results by your main function, making sure they are clear and readable. The fasta file contains the below: >MD10G1276500 pacid=40089867 polypeptide=MD10G1276500 locus=MD10G1276500 ID=MD10G1276500.v1.1.491…
The following needs to be debugged in Python. // The two senior class homerooms at Littleville High School// are having a fundraising drive for the prom. Each time a student// solicits a contribution, a record is created with the// student's name and the value. Two files have been created for// Homeroom A and Homeroom B. Each file is sorted in contribution// value order from highest to lowest. This program merges the two files.start Declarations string roomAName num roomAValue string roomBName num roomBValue string bothFilesDone = "N" num HIGH_VALUE = 999999 InputFile roomAFile InputFile roomBFile InputFile mergedFile getReady() while bothFilesDone = "N" detailLoop() endwhile allDone()stop getReady() open roomAFile "roomAFile.dat" open roomBFile "roomBFile.dat" open mergedFile "mergedFile.dat" readA() readB() checkBoth()return readA() input roomAName, roomAValue from roomAFile if eof then roomAValue =…
Suppose you are given a text file that contains the names of people. Every name in the file consists of a first name and last name. Unfortunately, the programmer that created the file of names did not guarantee that each name was on a single line of the file. Read this file of names and write them to a new text file sorted according to first name, one name per line. For example, if the input file contains Ed Marston Bob Jones Jeff Williams Fred Charles The output file should be Bob Jones Ed Marston Fred Charles Jeff Williams Use arrays to solve the problem.