python 利用pandas将数据转换成dataframe再存为excel

做个记录方便回看

import numpy as np
from pandas import  DataFrame
from openpyxl import Workbook
from openpyxl.utils.dataframe import dataframe_to_rows
 

 
# 数据类型转换为dataframe#index，行名，columns，列名
data_frame = DataFrame(columns=['店名','有关直播的信息','好物一栏/商品信息'],data =[[A],[B],[C]])#ABC本身就是列表



print(dataframe)




 
# 创建工作簿，写入，并保存
wb = Workbook()
ws = wb.active
ws.title = 'data'    # 工作表名字
 
for x in dataframe_to_rows(data_frame):
    ws.append(x)
 
wb.save('data_file.xlsx')