A python function opens file data.csv, reads the data from the file and spits the data into three columns, x, y and z. The data is then printed out.Function:f = open("data.csv ", "r")print('x\ty\tz'.format())for row in f: temp = row.split(',') for cell in temp: print(cell,end='\t') print() data.csv contains:1.2,2.1,1.12.3,3.2,0.60.7,1.9,0.11.8,2.5,0.34.6,2.7,0.9 Write a function write_csv_file that will compute the square of each of these valuesand write out a new file called output.txt that contains the new data. Ensure that boththe input and output data have the same format (i.e. both are comma separated variable files)and that the output numbers are written to 3 decimal places. Verify that the output is correctby read csv file to read in the data, and print the new data out.

Required: Required code with comments for explanation and screenshot of both code and output has…

A python function opens file data.csv, reads the data from the file and spits the data into three columns, x, y and z. The data is then printed out. Function: f = open("data.csv ", "r") print('x\ty\tz'.format()) for row in f: temp = row.split(',') for cell in temp: print(cell,end='\t') print() data.csv contains: 1.2,2.1,1.1 2.3,3.2,0.6 0.7,1.9,0.1 1.8,2.5,0.3 4.6,2.7,0.9

A python function opens file data.csv, reads the data from the file and spits the data into three columns, x, y and z. The data is then printed out. Function: f = open("data.csv ", "r") print('x\ty\tz'.format()) for row in f: temp = row.split(',') for cell in temp: print(cell,end='\t') print() data.csv contains: 1.2,2.1,1.1 2.3,3.2,0.6 0.7,1.9,0.1 1.8,2.5,0.3 4.6,2.7,0.9

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.3: Random File Access

Problem 6E

See similar textbooks

Similar questions

You are creating a function that reads a data file and prints each line of the file. You write the following code. Line numbers are included for reference only The code attempts to read the file even if the file does not exist. SEE PHOTO You need to correct the code. Which three lines have indentation problems? Each correct answer presents part of the solution. (Choose three.) Group of answer choices Line 04 Line 03 Line 05 Line 02 Line 06 Line 07 Line 01 Line 08
Define a function named get_freq_of_e_ending_words (filename) that takes a filename as a parameter. The function reads the contents of the file specified in the parameter and returns the number of words which end with the letter 'e'. Note: remember to close the file properly. Note: you can assume that a word is considered to be any sequence of characters separated with white-space and the file is a plain text file that contains 1 or more words. For example: Test Result print (get_freq_of_e_ending_words ('summer.txt')) 15
Write a Python function ‘AVGCSV’ that reads a .csv file that includes ‘n’ rows and ‘m’ columns, it calculates the average of each row and writes it at the end of the row, and it calculates the average of each column and writes it at the end of the column. The function should modify the .csv file and save it after adding all the averages.
Define a function named get_words_from_file(filename) that takes a filename as a parameter. The function reads the contents of the file specified in the parameter and returns a list of words. The words in the file are separated by whitespace. Note: remember to close the file. Click here to download a sample text file. For example: Test Result print (get_words_from_file("input2.txt")) ['the', 'heavy', 'rain', 'is', 'to', 'ease', 'tonight', 'however', 'further', 'showers', 'are', 'expected', 'tomorrow']
Write a write_scores function that opens the file, and writes scores and names from lst_scores and lst_names into the file. An example function call is below. Make sure to handle a file error. Assume good input in both lists. Function name: write_scoresParameters: lst_scores, a list of ints; lst_names, a list of strings; file_name, a string Purpose: Writes the names and scores to the file name, with one name and one corresponding score per line.Example function call: (attached) After this code runs, the file final_grades.txt should read: Ayesha 96 Paolo 99 Ahmed 93 Anna 94
13. Write function quote() that takes as input the name of a file (as a string) and anindex i (as an integer). The file will contain quotes, one per line. The function shouldopen the file, read the file, close the file, and return the i-th quote (i.e. the i-th line in thefile), assuming that the quote numbering starts at 0. Test your solution onfile Wilde_Quotes.txt.>>> quote("Wilde_Quotes.txt", 5)'At twilight, nature is not without loveliness, thoughperhaps its chief use is to illustrate quotations from thepoets.\n'>>> quote("Wilde_Quotes.txt", 0)'A little sincerity is a dangerous thing, and a great dealof it is absolutely fatal.\n'>>> quote("Wilde_Quotes.txt", 23)'Patriotism is the virtue of the vicious. \n'>>>
(5) Write a function called copy_even_lines() that takes two strings (filenames) as input parameters and copies every other line from the first file into the second. That is, counting from 0, it copies the 0th line, the 2nd line, the 4th line, etc. from the first file to the second file. You may assume that both files exist. (6) Write a python program that asks the user for two filenames and calls your function copy_even_lines() from (5) using those two filenames. If one or more files do not exist, your program must handle the exception by repeating the prompts until valid filenames are entered.
Time Write a Python script that extracts and prints a single record from an input file in which organized by line. Each line contains the name of a person (possibly containing multiple followed by the year of his birth. Abbas ibn Firnas ibn Wirda: 809 Muhammad ibn Musa al - Khwarizmi: 780 Abu Al - Walid Muhammad Ibn Ahmad Rushd: 1126 The program uses function extract DataRecord with the specification: @param infile the input text file object @return pants a list containing the name (string) in the first element and the year of bir the second element. If the end of file was reached, an empty list is returned
3. Write a program that reads (up to 100) temperature values from a file called input.txt. Read the temperature values and the name of the city into two arrays. Use functions to determine the city that has the maximum temperature, the minimum temperature. The program outputs all results to another file called output.txt. Output.txt + X Muscat has the maximum temperature which is 42 Salalah has the minimum temperature which is 27 inputtxt* + x Muscat 42 Sohar 38 Salalah 27 Sur 29 Seeb 40 Nizwa 39 Mutrah 41 Ibri 38
Write a function void saveByDept(char *fileName, char *deptName , student allStudents[], int size) that will save the information of all students who belong to the department with name pointed to by deptNameinto a text file. The name of the file is given as an input parameter, fileName
Examine the following three functions that take as argument a file name and return the extension of that file. For instance, if the file name is 'myfile.tar.gz' the returned value of the function should be 'gz'. If the file name has no extention, i.e. when the file name is just 'myfile', the function should return an empty string. def get_extension1(filename): return(filename.split(".")[-1]) def get_extension2(filename): import os.path return(os.path.splitext(filename)[1]) def get_extension3(filename): return filename[filename.rfind('.'):][1:] Which of the these functions are doing exactly what they are supposed to do according to the description above? get_extension3 only get_extension2 only None of them. get_extension1 only
Write a program to calculate the students’ average test scores and their grades. assume the following input data: Johnson 85 83 77 91 76 Cooper 78 81 11 90 73 Kennedy 77 31 52 74 83 Use three parallel arrays; one array to store the students’ names, one array to store the students’ average test scores, and one array to store the students’ grades. Your program should have at least the following functions: • a function to open the file.• a function to read the data.• a function to compute the grades.• a function to sort the students’ by average test scores.