python大数据期末大题

#第一题，判断是否活跃
import pandas as pd
dic = {"序号":[1,2,3,4,5,6],
        "股票名称":["天士力","天下秀","广誉远","西藏药业","康缘药业","济川药业"],
        "日个股交易股数":[9877307,1837300,2485059,4815515,6221107,6357894]}
df = pd.DataFrame(dic)  #从字典变成表格
for i in range(df.shape[0]):
    if df.loc[i,日个股交易股数] < 2000000:
        df.loc[i,"交易情况"] = "不活跃"
    elif df.loc[i,日个股交易股数] < 6000000:
        df.loc[i, "交易情况"] = "一般"
    else:
        df.loc[i, "交易情况"] = "活跃"
# for i in range(df.shape[0]):  #也可以把if写在一行
#     df.loc[i,"交易情况"] = "不活跃" if df.iloc[i, 2] < 2000000 else "一般" if df.iloc[i,2] < 6000000 else "活跃"
#第二题，回报率和波动率排序以及评分
import pandas as pd
dic