[Python] I can't convert it to Excel from a dataframe due to not enough space, but I do have...

I have a dataframe that I want to proceed using this code:

Create an Excel writer object


with pd.ExcelWriter(output_file_path, engine='xlsxwriter') as writer:
# Write the first DataFrame to a sheet named 'grouped_df_tph_sku'
tph_summary.to_excel(writer, sheet_name='tph_summary', index=False)

# Write the second DataFrame to a sheet named 'df'
df.to_excel(writer, sheet_name='df', index=False)


Unfortunately, I got an error like this:

FileCreateError: [Errno 28] No space left on device
​

Even though I check it to my disk, I have 218 GB free on my disk. The dataframe itself only had 200K rows and 55 columns. But I still don't have any idea why this is happening.

The problem caused by the code even tough I don't have idea what is going on.

Continue reading...