Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
Based on given data sets (car_final.csv and car_insurance.CSV), complete the following tasks:

Based on given data sets (car_final.csv and car_insurance.CSV), complete the following tasks:

Computer Networking: A Top-Down Approach (7th Edition)
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...
See similar textbooks
icon
Related questions
Question
100%

using pandas (jupyter notebook) python, anaconda

Q1 d&e

1. Based on given data sets (car_final.csv and car_insurance.csv), complete the following tasks: a. Show the first 5 records of each data set. b. Merge car_final.csv and car_insurance.csv. Note that car_final.csv is the main data set. c. Sort the data by car (alphabetically) d. Plot a bar graph showing, for each car type, a number of cars that has moderate insurance fee. e. Plot a histogram for 'maintenance' and define bin = 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000
Transcribed Image Text:1. Based on given data sets (car_final.csv and car_insurance.csv), complete the following tasks: a. Show the first 5 records of each data set. b. Merge car_final.csv and car_insurance.csv. Note that car_final.csv is the main data set. c. Sort the data by car (alphabetically) d. Plot a bar graph showing, for each car type, a number of cars that has moderate insurance fee. e. Plot a histogram for 'maintenance' and define bin = 1000 1500 2000 2500 3000 3500 4000 4500 5000 5500 6000
car uniq_id maintenance insurance o toyota 1001 1500 moderate 1 toyota 1002 1650 moderate 2 toyota 1003 1600 moderate 3 toyota 1004 1600 moderate 4 honda 1005 1500 moderate 5 honda 1006 1600 moderate 6 honda 1007 1550 moderate 7 honda 1008 1550 moderate 8 honda 1009 1700 moderate honda 1010 1450 moderate 10 bmw 1011 4500 high 11 bmw 1012 4300 high 12 bmw 1013 4600 high 13 bmw 1014 4400 high 14 bmw 1015 4500 high 15 bmw 1016 5000 high 16 ford 1017 2300 high 17 ford 1018 2400 high 18 ford 1019 2200 high
Transcribed Image Text:car uniq_id maintenance insurance o toyota 1001 1500 moderate 1 toyota 1002 1650 moderate 2 toyota 1003 1600 moderate 3 toyota 1004 1600 moderate 4 honda 1005 1500 moderate 5 honda 1006 1600 moderate 6 honda 1007 1550 moderate 7 honda 1008 1550 moderate 8 honda 1009 1700 moderate honda 1010 1450 moderate 10 bmw 1011 4500 high 11 bmw 1012 4300 high 12 bmw 1013 4600 high 13 bmw 1014 4400 high 14 bmw 1015 4500 high 15 bmw 1016 5000 high 16 ford 1017 2300 high 17 ford 1018 2400 high 18 ford 1019 2200 high
Expert Solution
steps

Step by step

Solved in 3 steps

SEE SOLUTIONCheck out a sample Q&A here
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
SEE MORE TEXTBOOKS