pandas每次多Sheet写入文件的方法

# !usr/bin env python
# -*- coding: utf-8 -*- 
 
import pandas as pd
 
price_path = \'ASHAREEODPRICE.csv\'
df_price = pd.read_csv(price_path)
 
for i in xrange(4):
  sh = \'Sheet{}\'.format(i+1)
  file_path = \'qimo_close_price.xlsx\'
  raw_df = pd.read_excel(file_path, sheet_name=i)
 
  out_path = \'qimo_close_price_out.xlsx\'
  raw = pd.merge(raw_df, df_price, how=\'left\')
  raw.to_excel(out_path, sheet_name=sh, index=False)