pandas模块操作excel

pandas实现操作同一个excel文件对象写入两个工作表sheet

pandas创建dataframe对象：
df = pandas.DataFrame(列表)

import pandas as pd


# 读取总表sheet1和sheet2
# 生成两个表到excel文件

df1 = pd.read_excel("tiaojian.xlsx",sheet_name=0)
df2 = pd.read_excel("tiaojian.xlsx",sheet_name=1)

path = "data.xlsx"
writer = pd.ExcelWriter(path)
df1.to_excel(excel_writer=writer,sheet_name="test1",index=False)

# df2.to_excel(excel_writer=writer,sheet_name="test2",index=False)
df2.to_excel(excel_writer=writer,sheet_name="test2",index=False)
writer.save()

遍历dataframe对象

# 该遍历会略过表头
df = pd.read_excel("tiaojian.xlsx",sheet_name=1)
for i in df.index:
	data = df.loc[i].values
	data = list(data)

pandas读取表头与创建dataframe对象时指定表头

df = pd.DataFrame(columns=[])   # 创建一个dataframe对象，colmns参数指定一个表头

pandas读取表头
print(df.columns)