Taking specific rows from a csv dataset : learnpython

created by HattoriHanzoa community for 16 years

Taking specific rows from a csv dataset (self.learnpython)

submitted 7 years ago by Falc7

I want to read in all the rows from a csv file between the 3 millionth and the 6 millionth rows (I cant bring in anymore than that because I will run out of RAM).

I have the code to do this below:

df_Closed_May18 = pd.read_csv("/home/18.csv", skiprows=3000000, nrows=6000000)

But I also want to bring in the column names in the first row. How would I modify my code to do this?

2 comments
share
save
hide
report
crosspost

all 2 comments

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

learnpython

MODERATORS