Pandas DataFrame.to_csv creating a new line when saving a dataframe to file

Question

I have a dataframe df_new which looks like:

And when I use the command:

df_new.to_csv(csv+'_filtered.csv', index=False)

I generate a csv file that suddenly breaks the row 24 before the 2 last columns, generating a new undesirable row which is completely empty, except the data of the last 2 columns that should be in the previous row:

Am I doing something wrong to save this file?

Can you add the line as it is originally ? perhaps it includes a new line — kakou, Apr 18 '23 at 09:25
There is a `\r` at the end of the URL on row 21. I don't know if that is the proper situation, but [this method](https://stackoverflow.com/a/34550393/18125313) may load correctly. — ken, Apr 18 '23 at 09:32
@ken, It was exactly this and your link solved my problem. If you want to post it as an answer, I will accept it — brenodacosta, Apr 18 '23 at 13:09

score 1 · Accepted Answer · answered Apr 18 '23 at 13:43

1

There is a \r at the end of the URL on row 21. I don't know if that is the proper situation, but this method may load correctly.

answered Apr 18 '23 at 13:43

ken

1,543
1
2
14

Pandas DataFrame.to_csv creating a new line when saving a dataframe to file

1 Answers1