Writing multiple Data frame in same excel sheet one below other in python

user_5782481 0
Viewed 1557

Reproduced code :

import numpy as np 
import pandas as pd

# Create a Dataframe
df1 = pd.DataFrame(np.random.rand(8).reshape(4,2),columns=['X','Y']);print(df1.shape)
df2 = pd.DataFrame(np.random.rand(6).reshape(3,2),columns=['X','Y']);print(df2.shape)
df3 = pd.DataFrame(np.random.rand(10).reshape(5,2),columns=['X','Y']);print(df3.shape)

These above three data frame which has same columns but different rows , need to written in same excel sheet one below other . Expected Output as shown below. DataFrame in single sheet one below other

Note: No of dataframe may vary

pandas dataframe python-3.x automation
1 Answers

You could try this:

dfs = [df1, df2, df3]
startrow = 0
with pd.ExcelWriter('output.xlsx') as writer:
    for df in dfs:
        df.to_excel(writer, engine="xlsxwriter", startrow=startrow)
        startrow += (df.shape[0] + 2)
user_112460560
Related