Pandas .to_csv not exporting correct output into the csv file

Question

I am trying to put a dataframe into a csv file and then access it. But by doing so the NaN values are showing up and the data are misaligned.

expenses = df.iloc[:][['Description','Debit']].dropna()

Here, i am trying to get the Description and debit column where there is no NaN data.

expenses.to_csv(path_or_buf= 'expenses.csv',index=False, header=["Description", "Debit"],encoding='utf-8')
expenses = pd.read_csv("expenses.csv", thousands=",", header= 0)

And then saving that dataframe into expenses and trying to access the same csv file but the content is misaligned. When I open the csv file its correct.

Here, is a screenshot to help you understand:

user2906838 · Accepted Answer · 2021-09-13 09:49:11Z

2

That is because, by default the inplace=False, when you use dropna , do:

df.dropna(subset=['Description','Debit'], inplace=True)

It should work. Your df, in this case, should have dropped the NaN values on these two columns.

edited Sep 13, 2021 at 9:49

answered Sep 13, 2021 at 9:43

user2906838

1,17811 silver badges22 bronze badges

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

2 Comments

senarijit1618 Over a year ago

I tried the same but it is making "expenses" dataframe into NoneType. And unable to use the to_csv method further down the line.

user2906838 Over a year ago

this way, the original dataframe itself is changed, and you can do, df.to_csv() directly, if you could share some sample rows, I can give you the working example.

Collectives™ on Stack Overflow

Pandas .to_csv not exporting correct output into the csv file

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related