7. Assume that required libraries (panda and numpy) are imported and dataframe df2 has been created as per questions 4 and 5 above. Predict the output of following code fragment :

df2[“IQ”] = [130, 105, 115]
df2[“Married”] = False
print(df2)

# Solution

import pandas as pd, numpy as np

my_di = {“name” : [“Jiya”, “Tim”, “Rohan”],
“age” : np.array([10,15,20]),
“weight” : (75,123,239),
“height” :[4.5, 5, 6.1],
“siblings” : 1,
“gender” : “M”}

df2 = pd.DataFrame(my_di, index=my_di[“name”])
df2[“IQ”] = [130, 105, 115] # Adds another column called ‘IQ’ to the dataframe df2
df2[“Married”] = False # Adds another column with all values equal to False
print(df2)

# Output
name age weight height siblings gender IQ Married
Jiya Jiya 10 75 4.5 1 M 130 False
Tim Tim 15 123 5.0 1 M 105 False
Rohan Rohan 20 239 6.1 1 M 115 False