题目:给出如下数据集
1.使用numpy生成随机数组,以添加'身高(cm)'列,范围[140, 200] 和'体重(kg)'列,范围[30, 100]
2.添加BMI列,根据生成的身高体重列计算BMI
import numpy as np
import pandas as pd # panel data analysis
data = [['Alex', 'M', 16], ['Alpha', 'M', 17], ['Allen', 'M', 18], ['Athena', 'F', 19],
['Chad', 'M', 17], ['Chole', 'F', 18], ['Dane', 'F', 19], ['Dale', 'F', 20],
['Frances', 'M', 18], ['Olivia', 'F', 19], ['Dave', 'M', 20], ['David', 'M', 21],
['John', 'M', 19], ['Ada', 'F', 20], ['Jane', 'F', 21], ['Ivy', 'F', 22],
['Julius', 'M', 20], ['Amy', 'F', 21], ['Irene', 'F', 22], ['Irma', 'F', 23],
['Jim', 'M', 21], ['Joseph', 'M', 22], ['Jenny', 'F', 23], ['Jennifer', 'F', 24],
['Micheal', 'M', 22], ['Crystal', 'F', 23], ['Claire', 'F', 24], ['Christine', 'F', 25],
['Kent', 'M', 23], ['Kenneth', 'M', 24], ['Justin', 'M', 25], ['Joyce', 'M', 26]]
df1 = pd.DataFrame(data, columns=['name', 'gender', 'age'])
def calBmi(df):
for i in range(len(df)):
df['heigth'] = np.random.randint(140, 201, len(df))
df['weight'] = np.random.randint(30, 101, len(df))
df['IMB'] = df['weight'] / ((df['heigth'] / 100) ** 2)
i += 1
return df
df2 = calBmi(df1)
print(df2)