a) Write a python program that reads the data file class-a.csv into a data frame and displays 3 rows of those data. Please import the suitable library. b) Write a function which receives the data frame from (a) to calculate the BMI and return the BMI data. Include the function call. Height data is in meter and Weight data is in kg. The formula for BMI as follows: BMI = weight / height2 c) Display the BMI data in sequence and calculate the mean of BMI. If the mean of BMI is exceeded 25 then display “Students are overweight”. d) Plot the pie chart for BMI distribution with student’s name as a label. Please import the suitable library.

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

a) Write a python program that reads the data file class-a.csv into a data frame and displays 3 rows of those data. Please import the suitable library.

b) Write a function which receives the data frame from (a) to calculate the BMI and return the BMI data. Include the function call. Height data is in meter and Weight data is in kg. The formula for BMI as follows:
BMI = weight / height2

c) Display the BMI data in sequence and calculate the mean of BMI. If the mean of BMI is exceeded 25 then display “Students are overweight”.

d) Plot the pie chart for BMI distribution with student’s name as a label. Please import the suitable library.

Table 1 shows the data of class A students in University XYZ. The data file name is class-
a.csv. The data consist of information on gender, height, and weight for every student.
Table 1: class-a.csv
Student ID
Name
Gender
Height
Weight
23345
Ahmad Abu
Male
1.68
84
23356
Siti Haliza Karim
Female
1.57
66
23311
Nurul Arifin
Female
1.63
45
23344
Mohd Ahmad
Male
1.75
87
23317
Hassan Ismail
Male
1.71
72
Transcribed Image Text:Table 1 shows the data of class A students in University XYZ. The data file name is class- a.csv. The data consist of information on gender, height, and weight for every student. Table 1: class-a.csv Student ID Name Gender Height Weight 23345 Ahmad Abu Male 1.68 84 23356 Siti Haliza Karim Female 1.57 66 23311 Nurul Arifin Female 1.63 45 23344 Mohd Ahmad Male 1.75 87 23317 Hassan Ismail Male 1.71 72
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 4 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