Solve by python Write a Python program that sorts the numbers in each column of a given input table (tablee, g, csv). An example is shown bellow:Input:ABC1131107812112013510Output:A107102336.125821215120113Apply your Program to the file "Car_sales3.csv" provided. Manufacturer ModelEngine_size Horsepower Fuel_efficiencyAcuraIntegra1.814028AcuraTL3.222525AcuraRL3.521022AudiA41.815027AudiA62.820022AudiA84.231021BMW328i2.819324BMW528i2.819325BuickCentury3.117525BuickRegal3.824023BuickPark Avenue3.820524BuickLeSabre3.820525CadillacDeVille4.627522CadillacSeville4.627522CadillacEldorado4.627522CadillacCatera320022CadillacEscalade5.725515ChevroletCavalier2.211527ChevroletMalibu3.117025ChevroletLumina3.117525ChevroletMonte Carlo3.418027ChevroletCamaro3.820025ChevroletCorvette5.734522ChevroletPrizm1.812033ChevroletMetro15545ChevroletImpala3.418027ChryslerSebring Coupe2.516324ChryslerSebring Conv.2.516824ChryslerConcorde2.720026ChryslerCirrus213227ChryslerLHS3.525323Chrysler300M3.525323DodgeNeon213229DodgeAvenger2.516324DodgeStratus2.516824DodgeIntrepid2.720224DodgeViper845016DodgeRam Pickup5.223017DodgeRam Wagon3.917515DodgeRam Van3.917516DodgeDakota2.512019DodgeCaravan2.415024FordEscort211030FordMustang3.819024FordContour2.517025FordTaurus315524FordCrown Victoria4.620021FordExplorer421019FordWindstar315021FordExpedition4.624016FordRanger2.511923FordF-Series4.622018HondaCivic1.610632HondaАcсord2.313527HondaCR-V214624HondaPassport3.220519HondaOdyssey3.521023HyundaiAccent1.59231

Answered: Write a Python program that sorts the…

Write a Python program that sorts the numbers in each column of a given input table (table e, g, csv). An example is shown bellow:

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 Python function to read players' names and scores from a file into two parallel lists, a list of names (namesList) and a list of scores (scoresList), which will be used during the game. While reading the file, your function keeps track of the best score read so far, along with the name of the player who got that score. After reading all of the names and scores, your function displays the highest score and that player's name. For instance, if Karin had the best score and her score was 7212, your function would display: Karin has the best score: 7212 Here is an example file: Michael 4999 Chris 5970 Madeleine 4110 Karin 7212 Strip off the newline character before adding a name to the list of names. Assume that the filename is given when the function is called, so do not ask the user for a filename. Also, assume that the two lists are initially empty and that all scores are different: there are no ties. Hints: 1- In a loop, read lines from the file: one read for the name and…
Write a Python program that asks the user to input 3 student names and then stores them in a list. The program should then ask the user to input the index/position of a student name stored in list to retriev. Using the index/position value provided by the user, the program should print the student name. The program should make sure the index/position/value is valid, otherwise the program should print a firenly error meesage saying the provided value was invalid.
You are a cyber investigator, your task is to write a python program that can read file signatures from a file and save them into a list. Each file signature is an element of your list. Then, try to find out if there is a JPG file in there. If there is a JPG file, print out a True on screen. (File Signature for JPG file is: FF D8 FF DB) The input file is: FSCS360_Midterm_Exam_Part2.txt
Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of movies.csv…
Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: • Each row contains the title, rating, and all showtimes of a unique movie. • A space is placed before and after each vertical separator (I) in each row. • Column 1 displays the movie titles and is left justified with a minimum of 44 characters. . If the movie title has more than 44 characters, output the first 44 characters only. • Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. • Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of…
Write a program in C++ that prints a sorted phone list from a database of names and phone numbers. The data is contained in two files named "phoneNames.txt" and "phoneNums.txt". The files may contain up to 2000 names and phone numbers. The files have one name or one phone number per line. To save paper, only print the first 50 lines of the output. Note: The first phone number in the phone number file corresponds to the first name in the name file. The second phone number in the phone number file corresponds to the second name in the name file. etc. You will find the test files in the Asn Five.zip
Write a program that reads movie data from a csv (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the csv file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator (|) in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the csv file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Ex: If the input of the program is: movies.csv and the contents of movies.csv…
In Java Write a program that prints the 128-character ASCII table. It should print the tablein eight tab-separated columns. The first column contains a "Dec" heading (fordecimal number) with the numbers 0 through 31 below it. The second columncontains the ASCII characters associated with the numbers 0 through 31. The nextcolumns contain the subsequent numbers and associated ASCII characters. See thebelow sample output for details. Be aware that that output was produced by aprogram running in a console window in a Windows environment. If you runyour program in a different environment, the first 32 characters and the lastcharacter will probably be different from what’s shown below.Note that some characters display in a non-standard manner. For example, thenumber 7 corresponds to a bell sound. You can’t see a sound, but you can see thevacant spot for 7’s character in the below table. The number 8 corresponds to thebackspace character. You can’t see a backspace, but you can see how the…
In Java Write a program that prints the 128-character ASCII table. It should print the tablein eight tab-separated columns. The first column contains a "Dec" heading (fordecimal number) with the numbers 0 through 31 below it. The second columncontains the ASCII characters associated with the numbers 0 through 31. The nextcolumns contain the subsequent numbers and associated ASCII characters. See thebelow sample output for details. Be aware that that output was produced by aprogram running in a console window in a Windows environment. If you runyour program in a different environment, the first 32 characters and the lastcharacter will probably be different from what’s shown below.Note that some characters display in a non-standard manner. For example, thenumber 7 corresponds to a bell sound. You can’t see a sound, but you can see thevacant spot for 7’s character in the below table. The number 8 corresponds to thebackspace character. You can’t see a backspace, but you can see how the…
A Canadian postal code is a six-character alphanumeric string that represents a part of a postal address. They are in the format of A1A 1A1, where A could be any letter and 1 could be any number from 0-9. Given an unsorted list of postal codes, write a Python program, in a file call postal.py, to sort the list of postal codes (actually modify the given list into a sorted list) and then display the sorted postal codes such that each postal code with the same starting letter is printed on the same line, with each line in alphabetical order. Note that the postal codes can be in any order on the same line, as long as they all start with the same letter, or you can have them sorted on the line as well. For example, given the following list of postal codes: postal_codes = ['A1A 1A1', 'B3K 5X5', 'V9A 7N2', 'A0Z 6P7', 'H0H 0H0', 'A1B 1T0'] The output would be similar to: Sorted postal codes: A0Z 6P7 A1A 1A1 A1B 1T0 B3K 5X5 H0H 0H0 V9A 7N2 Note: You are not permitted to use the sort() method.
Write a program that reads movie data from a CSV (comma separated values) file and output the data in a formatted table. The program first reads the name of the CSV file from the user. The program then reads the CSV file and outputs the contents according to the following requirements: Each row contains the title, rating, and all showtimes of a unique movie. A space is placed before and after each vertical separator ('|') in each row. Column 1 displays the movie titles and is left justified with a minimum of 44 characters. If the movie title has more than 44 characters, output the first 44 characters only. Column 2 displays the movie ratings and is right justified with a minimum of 5 characters. Column 3 displays all the showtimes of the same movie, separated by a space. Each row of the CSV file contains the showtime, title, and rating of a movie. Assume data of the same movie are grouped in consecutive rows. Hints: Use the find() function to find the index of a comma in each row of…
An “inverted file” is a critical data structure for implementing applications like the index of a book, or a web search engine. Given a document D (which can be viewed as an unordered, numbered list of words), an inverted file is an ordered list of words L such that for each word W in L, we store the indices of the places in D where W appears. Write a C# program (from scratch please, written by yourself (ask instructor if you are stuck), not borrowed from any other sources) that reads in a list of words separated by spaces from a text file, then uses an efficient O(N) algorithm to create the inverted file index (hint: consider the topic of this chapter, consider using a Dictionary/hashtable to help you), and writes this index out to another file or prints it to the screen. Each line of the output file should start with the next word (the words should be listed in alphabetical order, and this sorting does not have to be part of the O(N) runtime complexity, e.g. you can use regular…