Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

ENH: Ignoring empty lines in files #4466

Closed
holocronweaver opened this issue Aug 5, 2013 · 6 comments
Closed

ENH: Ignoring empty lines in files #4466

holocronweaver opened this issue Aug 5, 2013 · 6 comments
Labels
Enhancement IO CSV read_csv, to_csv
Milestone

Comments

@holocronweaver
Copy link

Currently pandas preserves empty lines when reading CSV files. I think the default should be to ignore empty lines, with a possible optional parameter to retain them.

Implementing this in the C and Python parsers should be an easy extension of my work on #2685 , but I wanted some feedback before I do so.

@hayd
Copy link
Contributor

hayd commented Aug 21, 2013

+1 This sounds like an excellent idea!

Will your PR fix #4623?

@jtratner
Copy link
Contributor

@timmie were you working on something like this?

@timmie
Copy link
Contributor

timmie commented Aug 22, 2013

@jtratner

#4340 is about the content before data is read.
I assume this issue is about ignoring within the data part.
So answer is no.

@jreback jreback closed this as completed Jan 3, 2014
@jreback jreback reopened this Jan 3, 2014
@jreback jreback modified the milestones: 0.15.0, 0.14.0 Mar 28, 2014
@H0R5E
Copy link
Contributor

H0R5E commented Jun 4, 2014

I have an issue with more than one blank line at the end of csv files. This tends to lead to hard to track down problems with the produced dataframes, but with no complaints from the reader.

It would be good if read_csv ignored a continuous block of blank line at the end of a csv file.

@jreback
Copy link
Contributor

jreback commented Jun 4, 2014

@holocronweaver any thoughts/progress on impl of this?

@jreback
Copy link
Contributor

jreback commented Sep 19, 2014

closes by #7470

@jreback jreback closed this as completed Sep 19, 2014
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Enhancement IO CSV read_csv, to_csv
Projects
None yet
Development

Successfully merging a pull request may close this issue.

6 participants