a. Write a Pandas program to read a dataset from automobiles DataFrame and modify the default columns values and print the first 10 rows. b. Write a Pandas program to select a series from automobilesDataFrame. Print the content of the series. c. Write a Pandas program to create a new Company - Price' Series (use bracket notation to define the Series name) of the automobiles DataFrame

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
100%

Can you please solve as soon as possible in python according to the information? Unfortunately I could not do it. I hope everything is clear.

Thank you! 

a. Write a Pandas program to read a dataset from automobiles DataFrame and modify the default
columns values and print the first 10 rows.
b. Write a Pandas program to select a series from automobilesDataFrame. Print the content of the series.
c. Write a Pandas program to create a new Company - Price' Series (use bracket notation to define the
Series name) of the automobiles DataFrame
d. Write a Pandas program to remove body style, engine type, length columns at once of the automobiles
Dataframe
e. Write a Pandas program to sort the entire automobiles DataFrame by the price Series in ascending
and descending order.
f. Write a Pandas program to find average price and change from nan to average price according to other
automobiles of same company.
g. Write a Pandas program to find the automobiles that are either hatchback or wagon. h.
Write a Pandas program to read rows 0, 5, 7 and all columns of automobiles DataFrame.
i. Write a Pandas program to calculate the memory usage for each Series (in bytes) of automobiles and
total DataFrame and delete 3 feature which have maximum memory and calculate the memory usage for
each Series (in bytes) of automobiles and total DataFrame.
Transcribed Image Text:a. Write a Pandas program to read a dataset from automobiles DataFrame and modify the default columns values and print the first 10 rows. b. Write a Pandas program to select a series from automobilesDataFrame. Print the content of the series. c. Write a Pandas program to create a new Company - Price' Series (use bracket notation to define the Series name) of the automobiles DataFrame d. Write a Pandas program to remove body style, engine type, length columns at once of the automobiles Dataframe e. Write a Pandas program to sort the entire automobiles DataFrame by the price Series in ascending and descending order. f. Write a Pandas program to find average price and change from nan to average price according to other automobiles of same company. g. Write a Pandas program to find the automobiles that are either hatchback or wagon. h. Write a Pandas program to read rows 0, 5, 7 and all columns of automobiles DataFrame. i. Write a Pandas program to calculate the memory usage for each Series (in bytes) of automobiles and total DataFrame and delete 3 feature which have maximum memory and calculate the memory usage for each Series (in bytes) of automobiles and total DataFrame.
company body-sty wheel-bi length
O alfa-rom convertit
1 alfa-rom convertit
2 alfa-rom hatchba
3 audi
index
engine-t num-of- horsepov average price
111
88.6
168.8 doho
four
21
13495
88.6
168.8 doho
four
111
21
16500
94.5
171.2 ohov
six
154
19
16500
sedan
99.8
176.6 oho
four
102
24
13950
4 audi
sedan
99.4
176.6 oho
five
115
18
17450
5 audi
sedan
99.8
177.3 ohc
five
110
19
15250
6 audi
9 bmw
wagon
105.8
192.7 oho
five
110
19
18920
176.8 ohc
sedan
sedan
101.2
four
101
23
16430
10 bmw
101.2
176.8 oho
four
101
23
16925
11 bmw
sedan
101.2
176.8 oho
six
121
21
20970
13 bmw
sedan
103.5
189 ohc
six
182
16
30760
14 bmw
sedan
103.5
193.8 ohc
six
182
16
41315
15 bmw
sedan
110
197 oho
six
182
15
36880
16 chevrole hatchba
17 chevrole hatchba
88.4
141.1I
three
48
47
5151
94.5
155.9 oho
four
70
38
6295
18 chevrole sedan
94.5
158.8 oho
four
70
38
6575
dodge hatchba
20 dodge
93.7
157
oho
four
68
31
6377
hatchba
93.7
157.3 oho
four
68
31
6229
7295
27 honda
wagon
96.5
157.1 oho
four
76
30
28 honda
sedan
96.5
175.4 oho
four
101
24
12945
29 honda
sedan
96.5
169.1 oho
four
100
25
10345
30 isuzu
sedan
94.3
170.7 oho
four
78
24
6785
31 isuzu
32 isuzu
sedan
94.5
155.9 oho
four
70
38
sedan
94.5
155.9 oho
four
70
38
33 jaguar
34 jaguar
35 jaguar
36 mazda hatchba
37 mazda hatohba
hatchba
39 mazda hatchba
sedan
sedan
113
199.6 doho
176
15
32250
35550
six
113
199.6 doho
six
176
15
sedan
102
191.7 ohov
twelve
262
13
36000
93.1
159.1 oho
four
68
30
5195
93.1
159.1 oho
four
68
31
6095
38 mazda
93.1
159.1 oho
four
68
31
6795
95.3
169 rotor
101
17
11845
two
43 mazda sedan
104.9
175 oho
four
72
31
18344
44 mercede sedan
45 mercede wagon
46 mercede sedan
47 mercede hardtop
49 mitsubist hatchba
50 mitsubist hatchba
51 mitsubisł sedan
110
190.9 oho
five
123
22
25552
110
190.9 ohc
five
123
22
28248
eight
eight
four
120.9
208.1 ohov
184
14
40960
112
199.2 ohov
184
14
45400
93.7
157.3 oho
68
37
5389
93.7
157.3 oho
four
68
31
6189
96.3
172.4 ohc
four
88
25
6989
52 mitsubish sedan
96.3
172.4 oho
four
88
25
8189
53 nissan
sedan
94.5
165.3 oho
four
55
45
7099
54 nissan
sedan
94.5
165.3 oho
four
69
31
6649
55 nissan
sedan
94.5
165.3 oho
four
69
31
6849
7349
13499
34028
56 nissan
wagon
94.5
170.2 oho
four
69
31
57 nissan
sedan
100.4
184.6 ohcv
six
152
19
61 porsche hardtop
62 porsche convertit
63 porsche hatchba
66 toyota
89.5
168.9 ohof
six
207
17
89.5
168.9 ohcf
six
207
17
37028
98.4
175.7 dohov
eight
four
288
17
hatchba
95.7
158.7 oho
62
35
5348
67 toyota
hatchba
hatchba
95.7
158.7 oho
four
62
31
6338
68 toyota
69 toyota
70 toyota
71 toyota
79 toyota
80 volkswag sedan
81 volkswag sedan
82 volkswag sedan
86 volkswag sedan
87 volvo
95.7
158.7 oho
four
62
31
6488
wagon
95.7
169.7 oho
four
62
31
6918
wagon
95.7
169.7 oho
four
62
27
7898
wagon
95.7
169.7 oho
four
62
27
8778
wagon
104.5
187.8 doho
six
156
19
15750
97.3
171.7 oho
four
52
37
7775
171.7 oho
171.7 ohc
97.3
four
85
27
7975
97.3
four
52
37
7995
97.3
171.7 oho
four
100
26
9995
sedan
104.3
188.8 oho
four
114
23
12940
88 volvo
wagon
104.3
188.8 oho
four
114
23
13415
Transcribed Image Text:company body-sty wheel-bi length O alfa-rom convertit 1 alfa-rom convertit 2 alfa-rom hatchba 3 audi index engine-t num-of- horsepov average price 111 88.6 168.8 doho four 21 13495 88.6 168.8 doho four 111 21 16500 94.5 171.2 ohov six 154 19 16500 sedan 99.8 176.6 oho four 102 24 13950 4 audi sedan 99.4 176.6 oho five 115 18 17450 5 audi sedan 99.8 177.3 ohc five 110 19 15250 6 audi 9 bmw wagon 105.8 192.7 oho five 110 19 18920 176.8 ohc sedan sedan 101.2 four 101 23 16430 10 bmw 101.2 176.8 oho four 101 23 16925 11 bmw sedan 101.2 176.8 oho six 121 21 20970 13 bmw sedan 103.5 189 ohc six 182 16 30760 14 bmw sedan 103.5 193.8 ohc six 182 16 41315 15 bmw sedan 110 197 oho six 182 15 36880 16 chevrole hatchba 17 chevrole hatchba 88.4 141.1I three 48 47 5151 94.5 155.9 oho four 70 38 6295 18 chevrole sedan 94.5 158.8 oho four 70 38 6575 dodge hatchba 20 dodge 93.7 157 oho four 68 31 6377 hatchba 93.7 157.3 oho four 68 31 6229 7295 27 honda wagon 96.5 157.1 oho four 76 30 28 honda sedan 96.5 175.4 oho four 101 24 12945 29 honda sedan 96.5 169.1 oho four 100 25 10345 30 isuzu sedan 94.3 170.7 oho four 78 24 6785 31 isuzu 32 isuzu sedan 94.5 155.9 oho four 70 38 sedan 94.5 155.9 oho four 70 38 33 jaguar 34 jaguar 35 jaguar 36 mazda hatchba 37 mazda hatohba hatchba 39 mazda hatchba sedan sedan 113 199.6 doho 176 15 32250 35550 six 113 199.6 doho six 176 15 sedan 102 191.7 ohov twelve 262 13 36000 93.1 159.1 oho four 68 30 5195 93.1 159.1 oho four 68 31 6095 38 mazda 93.1 159.1 oho four 68 31 6795 95.3 169 rotor 101 17 11845 two 43 mazda sedan 104.9 175 oho four 72 31 18344 44 mercede sedan 45 mercede wagon 46 mercede sedan 47 mercede hardtop 49 mitsubist hatchba 50 mitsubist hatchba 51 mitsubisł sedan 110 190.9 oho five 123 22 25552 110 190.9 ohc five 123 22 28248 eight eight four 120.9 208.1 ohov 184 14 40960 112 199.2 ohov 184 14 45400 93.7 157.3 oho 68 37 5389 93.7 157.3 oho four 68 31 6189 96.3 172.4 ohc four 88 25 6989 52 mitsubish sedan 96.3 172.4 oho four 88 25 8189 53 nissan sedan 94.5 165.3 oho four 55 45 7099 54 nissan sedan 94.5 165.3 oho four 69 31 6649 55 nissan sedan 94.5 165.3 oho four 69 31 6849 7349 13499 34028 56 nissan wagon 94.5 170.2 oho four 69 31 57 nissan sedan 100.4 184.6 ohcv six 152 19 61 porsche hardtop 62 porsche convertit 63 porsche hatchba 66 toyota 89.5 168.9 ohof six 207 17 89.5 168.9 ohcf six 207 17 37028 98.4 175.7 dohov eight four 288 17 hatchba 95.7 158.7 oho 62 35 5348 67 toyota hatchba hatchba 95.7 158.7 oho four 62 31 6338 68 toyota 69 toyota 70 toyota 71 toyota 79 toyota 80 volkswag sedan 81 volkswag sedan 82 volkswag sedan 86 volkswag sedan 87 volvo 95.7 158.7 oho four 62 31 6488 wagon 95.7 169.7 oho four 62 31 6918 wagon 95.7 169.7 oho four 62 27 7898 wagon 95.7 169.7 oho four 62 27 8778 wagon 104.5 187.8 doho six 156 19 15750 97.3 171.7 oho four 52 37 7775 171.7 oho 171.7 ohc 97.3 four 85 27 7975 97.3 four 52 37 7995 97.3 171.7 oho four 100 26 9995 sedan 104.3 188.8 oho four 114 23 12940 88 volvo wagon 104.3 188.8 oho four 114 23 13415
Expert Solution
steps

Step by step

Solved in 3 steps with 6 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY