python---deel with data by pandas

Original: http://pandas.pydata.org/pandas-docs/stable/user_guide/io.html#excel-files
Excel files
The read_excel() method can read Excel 2003 (.xls) and Excel 2007+ (.xlsx) files using the xlrd Python module. The to_excel() instance method is used for saving a DataFrame to Excel. Generally the semantics are similar to working with csv data. See the cookbook for some advanced strategies.

Reading Excel Files:
#Returns a DataFrame
pd.read_excel(‘path_to_file.xls’, sheet_name=‘Sheet1’)

ExcelFile class:
xlsx = pd.ExcelFile(‘path_to_file.xls’)
df = pd.read_excel(xlsx, ‘Sheet1’)

The ExcelFile class can also be used as a context manager :
with pd.ExcelFile(‘path_to_file.xls’) as xls:
df1 = pd.read_excel(xls, ‘Sheet1’)
df2 = pd.read_excel(xls, ‘Sheet2’)

data = {}
#For when Sheet1’s format differs from Sheet2
with pd.ExcelFile(‘path_to_file.xls’) as xls:
data[‘Sheet1’] = pd.read_excel(xls, ‘Sheet1’, index_col=None,na_values=[‘NA’])
data[‘Sheet2’] = pd.read_excel(xls, ‘Sheet2’, index_col=1)

#equivalent using the read_excel function
data = {}
data = pd.read_excel(‘path_to_file.xls’, [‘Sheet1’, ‘Sheet2’], index_col=None, na_values=[‘NA’])

Reading a MultiIndex:
read_excel can read a MultiIndex index, by passing a list of columns to index_col and a MultiIndex column by passing a list of rows to header. If either the index or columns have serialized level names those will be read in as well by specifying the rows/columns that make up the levels.

Writing Excel Files:
To write a DataFrame object to a sheet of an Excel file, you can use the to_excel instance method. The arguments are largely the same as to_csv described above, the first argument being the name of the excel file, and the optional second argument the name of the sheet to which the DataFrame should be written. For example:

df.to_excel(‘path_to_file.xlsx’, sheet_name=‘Sheet1’)

with pd.ExcelWriter(‘path_to_file.xlsx’) as writer:
df1.to_excel(writer, sheet_name=‘Sheet1’)
df2.to_excel(writer, sheet_name=‘Sheet2’)

Writing Excel Files to Memory:

Pandas supports writing Excel files to buffer-like objects such as StringIO or BytesIO using ExcelWriter.

#Safe import for either Python 2.x or 3.x
try:
from io import BytesIO
except ImportError:
from cStringIO import StringIO as BytesIO

bio = BytesIO()

#By setting the ‘engine’ in the ExcelWriter constructor.
writer = pd.ExcelWriter(bio, engine=‘xlsxwriter’)
df.to_excel(writer, sheet_name=‘Sheet1’)

#Save the workbook
writer.save()

#Seek to the beginning and read to copy the workbook to a variable in memory
bio.seek(0)
workbook = bio.read()