Excel转CSV,一个sheet表存入一个CSV文件中,并以sheet名字命名
import pandas as pd
def xlsx_to_csv_pd():
sheet_name=None表示读取全部sheet,或者sheet_name=[0,10],此处用sheet_name,而不是用sheetname
data_xls = pd.read_excel(‘C:\Users\Administrator\Desktop\test\1.xlsx’,sheet_name=None,index_col=0)
for key in data_xls:
data_xls[key].to_csv(‘C:\Users\Administrator\Desktop\test\’+key+’.csv’, encoding=’utf-8′)
if name == ‘main’:
xlsx_to_csv_pd()
csv转Excel
import pandas as pd
def csv_to_xlsx_pd():
csv.to_excel(‘C:\Users\Administrator\Desktop\test\2.xlsx’, sheet_name=’data’)
if name == ‘main’:
csv_to_xlsx_pd()
Original: https://blog.csdn.net/weixin_39989159/article/details/113963108
Author: weixin_39989159
Title: python pandas模块读取excel_python中pandas模块读取Excel的所有sheet表
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/742771/
转载文章受原作者版权保护。转载请注明原作者出处!