pd.read_clipboard()
pd.ExcelFile(xls_fpath).parse().to_csv(csv_fpath)
pd.read_excel()
pd.read_csv()
pd.DataFrame.from_dict()
df_src.columns = ['a', 'b']
df['xxx'].apply(lambda x:x)
df.drop(columns='xxx')
df.drop_duplicates()
df.merge(df2, how='inner') # how 选择合并方式,默认inner, 即只保留交集
for index, rows in df.iterrows():
print(index, rows.xxx) # rows类型类似nametuple
break
pd.DataFrame.from_dict(xxx)
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
pd.set_option('display.expand_frame_repr', False)
pd.set_option('max_colwidth', None)