To excel import

To excel import#

from IPython.display import HTML
HTML('''
<style>
    h1 {text-align:center}
</style>
''')

Several pd.DataFrame on list#

import pandas as pd

df1 = pd.DataFrame({'A': [1, 2, 3], 'B': [4, 5, 6]})
df2 = pd.DataFrame({'C': [7, 8, 9], 'D': [10, 11, 12]})

writer = pd.ExcelWriter('excel_export_files/output.xlsx')

df1.to_excel(writer, sheet_name='Sheet1')
df2.to_excel(writer, sheet_name='Sheet1', startrow=df1.shape[0] + 2)

df1.to_excel(writer, sheet_name='Sheet2')
df2.to_excel(writer, sheet_name='Sheet2', startrow=df1.shape[0] + 2)

writer.close()
Contents