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

df2[“College”] = pd.Series([“IIT”], index=[“Rohan”])
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[“College”] = pd.Series([“IIT”], index=[“Rohan”]) # Adds a column ‘College’ with all values NaN except the value at index ‘Rohan’ which is inserted as “IIT”
print(df2)

# Output
name age weight height siblings gender College
Jiya Jiya 10 75 4.5 1 M NaN
Tim Tim 15 123 5.0 1 M NaN
Rohan Rohan 20 239 6.1 1 M IIT