10000 Pandas to_csv adds extra line terminator by default - winpython 3.8.5.0 · Issue #884 · winpython/winpython · GitHub
[go: up one dir, main page]

Skip to content
Pandas to_csv adds extra line terminator by default - winpython 3.8.5.0 #884
Open
@ceaza

Description

@ceaza
import pandas as pd
import numpy as np
df = pd.DataFrame(np.random.randint(0,15,size=(15, 4)), columns=list('ABCD'))
df.to_csv('d://data//df.csv')

# gives

,A,B,C,D

0,2,3,0,1

1,0,1,2,0

2,0,4,2,0

3,0,0,3,2

Where as with the line_terminator explicitly referenced:


df.to_csv('d://data//test.csv',line_terminator='\n')

# gives the normal output expected
,A,B,C,D
0,2,3,0,1
1,0,1,2,0
2,0,4,2,0
3,0,0,3,2
4,4,4,0,4

Did upgrade to pandas 1.1.1 from 1.1.0 but had no effect.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions

      0