pandas 使用经验
import pandas as pd
df = pd.read_excel(input_path,sheet_name="test",use_cols=["ceshi"])
df.to_excel(file_path,index=False)
df = df[df["ceshi"]!='无']
df = df.rename(columns={"ceshi":"ceshi1"})
tmp = df["ceshi"].map(eval).apply(pd.Series)
df[tmp.columns] = tmp
df.loc[:,"filter"] = df["ceshi"] + ":" + df["ceshi1"]
need_df = df.drop_duplicates(subset='filter',keep='first',inplace=False)
df_sheet = df[(df['ceshi']=="key1")& (df['ceshi1']=="key2")]
df_sheet.columns = ["ceshi01","ceshi02"]
data = pd.merge(df_sheet,df,on='ceshi',how='right')
data[data.duplicated()].count()
data.drop_duplicates(inplace=True)
data.reset_index(drop=True,inplace=True)
data.isnull()
data.notnull()