pandas拆分数据写入不同sheet

最新推荐文章于 2024-07-22 15:15:29 发布

会飞的尼古拉斯

最新推荐文章于 2024-07-22 15:15:29 发布

阅读量402

点赞数

分类专栏： Python Pandas 文章标签： pandas python 开发语言

本文链接：https://blog.csdn.net/weixin_43632687/article/details/129733438

版权

Python 同时被 2 个专栏收录

127 篇文章 6 订阅

订阅专栏

Pandas

10 篇文章 0 订阅

订阅专栏

import pandas as pd


bigdata = [{"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           {"a":10,"b":20},
           ]

# Create a Pandas DataFrame with your data
df = pd.DataFrame(bigdata)

# Split the DataFrame into chunks that fit within the sheet size limit
chunk_size = 2 # Change this to a size that fits your data and system
chunks = [df.iloc[i:i + chunk_size] for i in range(0, df.shape[0], chunk_size)]

# Create a new Excel file
with pd.ExcelWriter('./output.xlsx') as writer:
    # Write each chunk to a new sheet in the Excel file
    for i, chunk in enumerate(chunks):
        sheet_name = f'sheet_{i}'
        chunk.to_excel(writer, sheet_name=sheet_name, index=False)