17) Suppose you have three lists that contain the height in meter, the corresponding weight in kilogram, and the body mass index (bmi) of the height and weight as follow: height = [1.47, 1.5, 1.52, 1.55, 1.57, 1.6, 1.63, 1.65, 1.68, 1.7, 1.73, 1.75, 1.78, 1.8, 1.83] weight = [52.21, 53.12, 54.48, 55.84, 57.2, 58.57, 59.93, 61.29, 63.11, 64.47, 66.28, 68.1, 69.92, 72.19, 74.46] bmi = [24.16, 23.61, 23.58, 23.24, 23.21, 22.88, 22.56, 22.51, 22.36, 22.31, 22.15, 22.24, 22.07, 22.28, 22.23] Store the three lists in a pandas DataFrame. Call the DataFrame bmi_table. Call the columns height, weight, bmi. Show the first 6 rows of the table
python code:Q18
17) Suppose you have three lists that contain the height in meter, the corresponding weight in kilogram, and the body mass index (bmi) of the
height and weight as follow:
height = [1.47, 1.5, 1.52, 1.55, 1.57, 1.6, 1.63, 1.65, 1.68, 1.7, 1.73, 1.75, 1.78, 1.8, 1.83]
weight = [52.21, 53.12, 54.48, 55.84, 57.2, 58.57, 59.93, 61.29, 63.11, 64.47, 66.28, 68.1, 69.92, 72.19, 74.46]
bmi = [24.16, 23.61, 23.58, 23.24, 23.21, 22.88, 22.56, 22.51, 22.36, 22.31, 22.15, 22.24, 22.07, 22.28, 22.23]
Store the three lists in a pandas DataFrame. Call the DataFrame bmi_table. Call the columns height, weight, bmi.
Show the first 6 rows of the table
Problem 18
Two new people are added to these height (in meters) and weight (in kilogram) lists. They are the numbers in red below.
height = [1.47, 1.5, 1.52, 1.55, 1.57, 1.6, 1.63, 1.65, 1.68, 1.7, 1.73, 1.75, 1.78, 1.8, 1.83, 1.81, 2.20]
weight = [52.21, 53.12, 54.48, 55.84, 57.2, 58.57, 59.93, 61.29, 63.11, 64.47, 66.28, 68.1, 69.92, 72.19, 74.46, 49.12, 85.65]
Calculate the bmi of the last person added
Calculate the bmi of the second to last person added
Hint: to get the last person's height and weight you can use range -1 trick
Hint: to get the second to last persons height and weight you can use range -2 trick
Hint: The formula for BMI is weight in kilograms divided by height in meters squared
))You will use the dataframe you created in Problem 17 (more Pandas this shows me if you are good enough in basic Python At this point that you actually can tackle something new and not fall apart). If you like solving this problem you could consider getting into data science.
Write a function get_sample_mean that takes in two input arguments: the desired sample_size and a dataframe called data. In the function pull a random sample of the specified sample_size of rows and save those as another dataframe. Now Calculate and return the mean of the sample dataframe.
Call your function on the height column with a sample size of 5 and print the mean
Call your function on the weight column with a sample size of 5 and print the mean
Call your function on the bmi column with a sample size of 5 and print the mean.
Hint: you can call the function with bmi_table.height, 5
Hint: you can call the function with bmi_table.weight, 5
Hint: you can call the function with bmi_table.bmi, 5
Hint: in the function you can pull a random 5 rows using data.sample(n=5)
Ie sampledata = data.sample(n=5)
Hint: in the function to get the mean you can do
samplemean = sampledata.mean()
Or
sum(sample) / len(sample)
Hint: you can look in my pandas folder in class notes or just search google for examples on how to pull a specific column from a data frame, how to get a sample (a random number of rows pulled out) and get the mean etc.
Trending now
This is a popular solution!
Step by step
Solved in 4 steps with 2 images
