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
icon
Related questions
Question
Solve by python
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:
Input:
A
B
C
1
13
1
10
7
8
1
21
1
20
1
3
5
10
Output:
A
10
7
10
2
3
3
6.
1
2
5
8
2
1
21
5
1
20
1
13
Apply your Program to the file "Car_sales3.csv" provided.
Transcribed Image Text: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: Input: A B C 1 13 1 10 7 8 1 21 1 20 1 3 5 10 Output: A 10 7 10 2 3 3 6. 1 2 5 8 2 1 21 5 1 20 1 13 Apply your Program to the file "Car_sales3.csv" provided.
Manufacturer Model
Engine_size Horsepower Fuel_efficiency
Acura
Integra
1.8
140
28
Acura
TL
3.2
225
25
Acura
RL
3.5
210
22
Audi
A4
1.8
150
27
Audi
A6
2.8
200
22
Audi
A8
4.2
310
21
BMW
328i
2.8
193
24
BMW
528i
2.8
193
25
Buick
Century
3.1
175
25
Buick
Regal
3.8
240
23
Buick
Park Avenue
3.8
205
24
Buick
LeSabre
3.8
205
25
Cadillac
DeVille
4.6
275
22
Cadillac
Seville
4.6
275
22
Cadillac
Eldorado
4.6
275
22
Cadillac
Catera
3
200
22
Cadillac
Escalade
5.7
255
15
Chevrolet
Cavalier
2.2
115
27
Chevrolet
Malibu
3.1
170
25
Chevrolet
Lumina
3.1
175
25
Chevrolet
Monte Carlo
3.4
180
27
Chevrolet
Camaro
3.8
200
25
Chevrolet
Corvette
5.7
345
22
Chevrolet
Prizm
1.8
120
33
Chevrolet
Metro
1
55
45
Chevrolet
Impala
3.4
180
27
Chrysler
Sebring Coupe
2.5
163
24
Chrysler
Sebring Conv.
2.5
168
24
Chrysler
Concorde
2.7
200
26
Chrysler
Cirrus
2
132
27
Chrysler
LHS
3.5
253
23
Chrysler
300M
3.5
253
23
Dodge
Neon
2
132
29
Dodge
Avenger
2.5
163
24
Dodge
Stratus
2.5
168
24
Dodge
Intrepid
2.7
202
24
Dodge
Viper
8
450
16
Dodge
Ram Pickup
5.2
230
17
Dodge
Ram Wagon
3.9
175
15
Dodge
Ram Van
3.9
175
16
Dodge
Dakota
2.5
120
19
Dodge
Caravan
2.4
150
24
Ford
Escort
2
110
30
Ford
Mustang
3.8
190
24
Ford
Contour
2.5
170
25
Ford
Taurus
3
155
24
Ford
Crown Victoria
4.6
200
21
Ford
Explorer
4
210
19
Ford
Windstar
3
150
21
Ford
Expedition
4.6
240
16
Ford
Ranger
2.5
119
23
Ford
F-Series
4.6
220
18
Honda
Civic
1.6
106
32
Honda
Аcсord
2.3
135
27
Honda
CR-V
2
146
24
Honda
Passport
3.2
205
19
Honda
Odyssey
3.5
210
23
Hyundai
Accent
1.5
92
31
Transcribed Image Text:Manufacturer Model Engine_size Horsepower Fuel_efficiency Acura Integra 1.8 140 28 Acura TL 3.2 225 25 Acura RL 3.5 210 22 Audi A4 1.8 150 27 Audi A6 2.8 200 22 Audi A8 4.2 310 21 BMW 328i 2.8 193 24 BMW 528i 2.8 193 25 Buick Century 3.1 175 25 Buick Regal 3.8 240 23 Buick Park Avenue 3.8 205 24 Buick LeSabre 3.8 205 25 Cadillac DeVille 4.6 275 22 Cadillac Seville 4.6 275 22 Cadillac Eldorado 4.6 275 22 Cadillac Catera 3 200 22 Cadillac Escalade 5.7 255 15 Chevrolet Cavalier 2.2 115 27 Chevrolet Malibu 3.1 170 25 Chevrolet Lumina 3.1 175 25 Chevrolet Monte Carlo 3.4 180 27 Chevrolet Camaro 3.8 200 25 Chevrolet Corvette 5.7 345 22 Chevrolet Prizm 1.8 120 33 Chevrolet Metro 1 55 45 Chevrolet Impala 3.4 180 27 Chrysler Sebring Coupe 2.5 163 24 Chrysler Sebring Conv. 2.5 168 24 Chrysler Concorde 2.7 200 26 Chrysler Cirrus 2 132 27 Chrysler LHS 3.5 253 23 Chrysler 300M 3.5 253 23 Dodge Neon 2 132 29 Dodge Avenger 2.5 163 24 Dodge Stratus 2.5 168 24 Dodge Intrepid 2.7 202 24 Dodge Viper 8 450 16 Dodge Ram Pickup 5.2 230 17 Dodge Ram Wagon 3.9 175 15 Dodge Ram Van 3.9 175 16 Dodge Dakota 2.5 120 19 Dodge Caravan 2.4 150 24 Ford Escort 2 110 30 Ford Mustang 3.8 190 24 Ford Contour 2.5 170 25 Ford Taurus 3 155 24 Ford Crown Victoria 4.6 200 21 Ford Explorer 4 210 19 Ford Windstar 3 150 21 Ford Expedition 4.6 240 16 Ford Ranger 2.5 119 23 Ford F-Series 4.6 220 18 Honda Civic 1.6 106 32 Honda Аcсord 2.3 135 27 Honda CR-V 2 146 24 Honda Passport 3.2 205 19 Honda Odyssey 3.5 210 23 Hyundai Accent 1.5 92 31
Expert Solution
steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Longest Common Subsequence
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education