Exporting sorted/adjusted data to excel with python

Question

I have a simple dataset that I have sorted with dataframe based on 'category'.

The sorting has gone all well. But now, I'd like to export the sorted/adjusted dataset in .xlsx format. That is the dataset that has been categorized, not the dataset that is read in excel.

I have tried the following:

import pandas as pd
df = pd.read_excel("python_sorting_test.xlsx",index_col=[1])

df.head()

print(df.sort_index(level=['Category'], ascending=True))

df.to_excel (r'C:\Users\Laptop\PycharmProjects\untitled8\export_dataframe.xlsx', header=True)

The issue: It doesn't doesn't store the sorted/adjusted dataset.

Add inplace flag otherwise it does not "save" the sort operation. — Tom Ron
– Tom Ron, Commented May 11, 2019 at 12:19
Your code doesn't do anything. print(df.sort_index(level=['Category'], ascending=True)) just shows the result of sorting and throws it away. Either use inplace=True or use df = df.sort_index(level=['Category'], ascending=True)) to assign the result back — roganjosh
– roganjosh, Commented May 11, 2019 at 12:20

kvorobiev · Accepted Answer · 2019-05-11 12:20:18Z

1

Actually, you doesn't save results of sort_index. You can add inplace=True

print(df.sort_index(level=['Category'], ascending=True, inplace=True))

or save results of df.sort_index

df = df.sort_index(level=['Category'], ascending=True)

answered May 11, 2019 at 12:20

kvorobiev

5,0704 gold badges32 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Exporting sorted/adjusted data to excel with python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related