pythoon的数据框结构DataFrame读写Excel表

一、pandas的DataFrame读Excel

import pandas

data_xls_file1 = 'infile.xls'
with pandas.ExcelFile(data_xls_file1) as xls_file1:
    data1 = pandas.read_excel(xls_file1)

二、pandas的DataFrame写Excel

import  pandas

outfilename1 = 'outfile.xls'

writer1 = pandas.ExcelWriter(outfilename1)

df1.to_excel(writer1)    #df1是一个DataFrame结构的数据

writer1.save()

参考：http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_excel.html#pandas.DataFrame.to_excel

http://pandas.pydata.org/pandas-docs/stable/10min.html#excel

http://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html