pandas基本操作2

# df转excel
df1.to_excel("output.xlsx", sheet_name='Sheet_name_1') 
# df转excel并写入多个sheet
with pd.ExcelWriter('output.xlsx') as writer:  
    df1.to_excel(writer, sheet_name='Sheet_name_1')
    df2.to_excel(writer, sheet_name='Sheet_name_2')
# 在已有excel表格中追加sheet
with pd.ExcelWriter('output.xlsx',
                    mode='a') as writer:  
    df.to_excel(writer, sheet_name='Sheet_name_3')

# 正则比配所有文件
import glob
dat_files = glob.glob('*.dat')

# df广播操作
df['row3'] = df['row1'] - df['row2']

# df更新一个值
df.iloc['row1','col1'] = new_data

# pandas读取excel表
pd.read_excel(excel_name)

# 读取excel中所有sheet
pd.read_excel(excel_name, sheet_name=None)

# 遍历df某一列
for col in df['col1']:
	print(col)
# 或者
print(df['col1'].values())

# 去一列特定值相应另一列的值
df.loc[df['C'] == 9, 'D']