Is there a way to convert data frame styler object into dataframe in python

Question

I have extracted xlsx data into pandas dataframe and used style.format to format particular columns into percentages and dollars. So now my dataframe is converted to styler object, because I need to parse this data into csv. I have to convert this object into dataframe please help.

below is the code and output:

import pandas as pd
import numpy as np

file_path = "./sample_data.xlsx"

df = pd.read_excel(file_path, sheet_name = "Channel",skiprows=10, header = 
[0,1,2])

dollar_cols = ['SalesTY', 'SalesLY','InStoreTY', 'InStoreLY','eCommTY']

dollar_dict = {}
for dollar_col in dollar_cols: 
    formatdict[dollar_col] = "${:,.0f}"
    final_df = df.style.format(formatdict)

Here final_df has the columns converted to dollars but I am unable to convert this to csv or into a data frame. It's a styler object now, I need to convert this into a data frame again. Any help is appreciated. Thanks.

good question, please share with us your codes and a bit of sample data. — MEdwin
– MEdwin, Commented Mar 20, 2019 at 10:46

tomanizer · Accepted Answer · 2019-12-27 14:17:14Z

17

You can retrieve the original dataframe from the styler object using the "data" attribute.

In your example:

df = final_df.data

type(df) yields

pandas.core.frame.DataFrame

answered Dec 27, 2019 at 14:17

tomanizer

1,0271 gold badge8 silver badges19 bronze badges

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

6 Comments

Gabriel Over a year ago

This method works but you lose the formatting in the process.

tomanizer Over a year ago

Yes. The question was to get the original data frame back. The formatting is of course in the styling object the questioner already has.

Thadeu Melo Over a year ago

And how do I get a new dataframe with the correct new format?

tomanizer Over a year ago

you want a dataframe with formattng which is not a styler or using styles?if you actually want to see $ symbols in the exported csv you will need to replace the numbers with strings, e.g. replace 1000 with $1,000. are you sure that's what you want? why would you want that?

Attila the Fun Over a year ago

I would be fine with "losing the formatting" if the formatting was still stored in the new data frame's style attribute. style.data.style should be an identity. Alas, it is not.

|

Collectives™ on Stack Overflow

Is there a way to convert data frame styler object into dataframe in python

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related