Section 9 – Lab Work part 5 - *AWK* # Challenge Lab Using the following data file (delimited by a space or tab) named **(section9.5.input)** ``` November 650 January 225 June 380 March 200 April 227 May 356 July 409 August 325 September 400 February 396 October 347 December 204 ``` Write a script named **(section9.5.sh)** that will use *AWK* to process the data file line by line. The script will send the output to a file **(section9.5.out)** in the following format: ``` Month Sales -------- ------- January 225 February 396 March 200 April 227 May 356 June 380 July 409 August 325 September 400 October 347 November 650 December 204 ======= Total show the total ``` ### What to upload into Moodle: Upload your fully functioning, well-documented script **(section9.5.sh)**, input file **(section9.5.input)**, and output file **(section9.5.out)** into Moodle.

Section 9 – Lab Work part 5 - AWK # Challenge Lab Using the following data file (delimited by a space or tab) named (section9.5.input) ``` November 650 January 225 June 380 March 200 April 227 May 356 July 409 August 325 September 400 February 396 October 347 December 204 ``` Write a script named (section9.5.sh) that will use AWK to process the data file line by line. The script will send the output to a file (section9.5.out) in the following format: ``` Month Sales -------- ------- January 225 February 396 March 200 April 227 May 356 June 380 July 409 August 325 September 400 October 347 November 650 December 204 ======= Total show the total ``` ### What to upload into Moodle: Upload your fully functioning, well-documented script (section9.5.sh), input file (section9.5.input), and output file (section9.5.out) into Moodle.

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

Write a program that reads the strings from file SortedStrings. txt and report whether the strings in the files are stored in ascending order. If the strings are not sorted in the file, display the first two strings that are out of order.
Write a program to read and store four student’s name and their Salaries, sort them into an order name, based on Salaries from the smallest to the largest, then print them out. The student’s name and their Salary values should be typed in by the user in response to a prompt message. Save the file as SortName_yourID.java
6. Write a program that will randomly generate 500 integer numbers in the range -249 to 250. Write thosenumbers in a text file named “in.txt”. Now Sort (in ascending order) all the integer numbers in the file “in.txt”using Buuble Sort. Save the sorted output into another text file named “out.txt”. (Try to write separatefunction for SWAP and BUBBLE_SORT and call them from main function.)
Create a file called search_replace.py. Here, create a program thatimplements a search and replace function recursively. Your programshould allow a user to enter a string, a substring they wish to find andanother string with which they wish to replace the found substring. Consider finding the index of the string you want replace then use concatenation and slicing to join the different parts togetherThe output of your program should be similar to the output given below:Please enter a string: Hello worldPlease enter the substring you wish to find: lloPlease enter a string to replace the given substring: @@Your new string is: he@@ world
msleep**** For this assignment, you must name your R file msleep.R (using Rstudio) For all questions you should load tidyverse. You should not need to use any other libraries. Load tidyverse with suppressPackageStartupMessages(library(tidyverse)) The actual data set is called msleep Round all float/dbl values to two decimal places. If your rounding does not work the way you expect, convert the tibble to a dataframe by using as.data.frame() All statistics should be run with variables in the order I state E.g., “Run a regression predicting mileage from mpg, make, and type” would be: lm(mileage ~ mpg + make + type...) Before attempting to answer these, or if you lose points upon an attempt, please review all CodeGrade information provided in the CodeGrade overview submodule - if you do not you are likely to lose points. What is the variance in total sleep for carni vores and those whose conservation status is lc? Your answer should be in a 1 X 1 data frame with a value…
Write a program that uses a sentinel loop (use ‘X’ as the sentinel value) and a dictionary that allows a user to input names and email addresses that are stored in a dictionary as key-value pairs. The program should then use a second sentinel loop to allow the user to look up a person’s email address until ‘X’ is entered. The program should pickle the dictionary and save it to a file when the user exits the program. Each time the program starts, it should retrieve the dictionary from the file and unpickle it. Please use Python
Please help me write the following function (see the photos for context of the problem): follow_trail(filename, treasure_map, start_row, start_col): Takes as inputs a string corresponding to a filename, a list of lists corresponding to a treasure map, and two non-negative integers representing a row and column index. Follows the trail in the given treasure map, starting at the given row and column index. Following the trail means to look at each character of the trail and perform the appropriate operation for that character: '>', '<', 'v', ' ∧': Continues following the trail by moving to the character to the right, left, below or above the current trail character, respectively. '.': Creates a new map file, with 'new_' prepended to the current map filename, and stores the same treasure map but with an X at the current position. Then, returns a tuple of three elements: the first being -1, and the latter two being the current row and column index. '*': Returns a tuple of three…
Write a program called p1.py that contains a function called filereader() that takes a number n (int) and a filename (string) as input. The function should read and store every nth line of the file in a list and return it.Test your function inside the main function (don’t forget the main guard).Sample output with “samplefile_t8.txt” file. It contains the following lines of text.kangaroo, 5capybara, 7wombat, 2koala, 3wallaby, 4quokka, 5platypus, 9dingo, 2kookaburra, 1>>> filereader(“samplefile_t8.txt”, 3) returns[“wombat, 2”, “quokka, 5”, “kookaburra, 1”]
Write one line of code that reads a full line from a file with file handle fp into a string defined aschar line[256]. Do this using both fscanf and fgets.
Task 2: Reading lines from a FileWrite C code which will read a line of characters (terminated by a \n) from input_file into a character array called buffer. NULL terminate the buffer upon reading a \n.NOTE:Your source code must display any of the given sample output below.It means your source code should be flexible enough to meet any of the given sample output.Your source code output must be identical to any of the given sample output.It means you have to strictly follow what are the displayed text, labels, casing of characters in the sample output.Strictly follow the naming of file. Required Outputs is attached.
The following Python code is a partially written function that attempts to read a file's contents into a dictionary. Fill in the missing code in the make_dictionary function. You do not need to copy any of the existing code. Just write the code that would go in place of "YOUR CODE HERE". def make_dictionary(filename):'''Function -- make_dictionaryCreates a dictionary from a file's contents. Each line in the file is split into a list at commas.If, after splitting, the list contains exactly 2 parts,the first item is added to the dictionary as a keyand the second item is the value. If the providedfile doesn't exist, the message "File doesn'texist" is printed to the terminal and anempty dictionary is returned.Parameter:filename -- The name of the file to open.Returns:A dictionary of the file's contents, if thefile matches the expected format. Otherwise, anempty dictionary is returned.'''contents = {}# YOUR CODE HEREreturn contents Example If the contents of the file passed to the function…
9b_act2. Please help me answer this in python programming.