pandas 读写excle中的多个表-昊天SEO

import <span class='wp_keywordlink_affiliate'><a href="https://www.168seo.cn/tag/pandas" title="View all posts in pandas" target="_blank">pandas</a></span> as pd
import numpy as np
xls = pd.ExcelFile('aa.xlsx')
df = xls.parse('Sheet1')
df2 = xls.parse('Sheet2')

xls.sheet_names # see all sheet names

xls.parse(sheet_name) # read a specific sheet to DataFrame
df.to_<span class='wp_keywordlink_affiliate'><a href="https://www.168seo.cn/tag/csv" title="View all posts in csv" target="_blank">csv</a></span>('cc.<span class='wp_keywordlink_affiliate'><a href="https://www.168seo.cn/tag/csv" title="View all posts in csv" target="_blank">csv</a></span>',encoding=('utf-8')) #写入csv中