pandas 日常工作笔记

df_ind['行业'] = df_ind['行业'].ffill()  # 自动填充空值

pf.insert(loc=5, column='Unit-Data',value=pf["SN"] + "-" + pf["CP"])  #新增列

sheetname_list = pd.ExcelFile(filename).sheet_names #获取工作簿所有工作表名称

---

a=["a", "c", "d","e","a"]

value_list, index_list = np.unique(a,return_index=True)

unique_value_list=[a[index] for index in sorted(index_list)]

print(unique_value_list)

---

SN_UnitNumber = dict(zip(df_SN.Number,df_SN.SN)) # 生成字典

needed_data =data.loc[data['SerialNumber'] == sn] # 数据筛选