How do I read the first 10 rows of a Pandas DataFrame?

Question

I am looking for a way to read a sample of a DataFrame in pandas like:

df = pd.read_csv('path_to_my_csv/csv.csv', header=True, sample=10)

#or 
df = pd.read_parquet('path_to_my_parquet/csv.parquet', engine="pyarrow", sample=10)

What I want is to load on the X (10 is this case) first rows of my Data, for test purpose.

Luke · Accepted Answer · 2021-09-16T07:00:06.520

3

You can load only the first 10 non-header rows using nrows

df = pd.read_csv('path_to_my_csv/csv.csv', header=True, nrows=10)

edited Sep 16 '21 at 07:00

answered Sep 16 '21 at 06:51

Luke

1,741
10
29

1

This looks good. it wouldn't read the entire `csv` but only the first 10 rows. Upvoted! – Raymond Toh Sep 16 '21 at 06:57
1

@jezrael OP needs the first 10 rows of data as opposed to sampling 10 rows – Luke Sep 16 '21 at 07:17
1

Agree, so closed like dupe. – jezrael Sep 16 '21 at 07:18
1

Thank, it helps me :) – PicxyB Sep 16 '21 at 08:25

score 0 · Answer 2 · answered Sep 16 '21 at 06:51

0

df = pd.read_csv('path_to_my_csv/csv.csv', header=True).head(10)

Your df will have the first 10 rows of your csv file

answered Sep 16 '21 at 06:51

snag9677

53
5

1

This solution will not scale well for larger datasets – darth baba Sep 16 '21 at 06:53

How do I read the first 10 rows of a Pandas DataFrame?

2 Answers2