How to print all rows/data from csv file with Pandas in Python?

Question

Problem

I have a CSV file which has 100 rows. I want to print them all with pandas module. But It only printing 10 rows. How can I print all of them?

Code

from pandas import *

cvs=read_csv('sample.csv')

print(cvs)

Output which I get

    Serial Number                   Company Name  ...         Description Leave
0   9788189999599                 TALES OF SHIVA  ...                mark     0
1   9780099578079      1Q84 THE COMPLETE TRILOGY  ...                Mark     0
2   9780198082897                       MY KUMAN  ...                Mark     0
3   9780007880331        THE GOD OF SMAAL THINGS  ...  4TH HARPER COLLINS     2
4   9780545060455               THE BLACK CIRCLE  ...  4TH HARPER COLLINS     0
..            ...                            ...  ...                 ...   ...
94  9788184821536  MORE STORIES FROM THE JATAKAS  ...                 ACK     0
95  9788184821543           MORE TALES OF BIRBAL  ...                 ACK     0
96  9788184821550         TALES FROM THE JATAKAS  ...                 ACK     0
97  9788184821567               RAMarkS OF MEWAR  ...                 ACK     0
98  9788184821574       THE SONS OF THE PANDAVAS  ...                 ACK     0

[99 rows x 5 columns]
[Finished in 5.6s]

Printing a dataframe, by default, only gives a summary

jackal
– jackal

2021-12-22 12:13:56 +00:00
Commented Dec 22, 2021 at 12:13 — jackal
– jackal, Commented Dec 22, 2021 at 12:13

sunil ghimire · Accepted Answer · 2021-12-22 12:16:29Z

1

You can try this one

from pandas import *

cvs=read_csv('sample.csv')
pandas.set_option('display.max_rows', csv.shape[0]+1)

print(cvs)

answered Dec 22, 2021 at 12:16

sunil ghimire

5555 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Sviat Lavrinchuk · Accepted Answer · 2021-12-22 12:13:13Z

1

Set display.max_rows:

pd.set_option('display.max_rows', 500)

answered Dec 22, 2021 at 12:13

Sviat Lavrinchuk

4245 silver badges11 bronze badges

Collectives™ on Stack Overflow

How to print all rows/data from csv file with Pandas in Python?

Problem

Code

Output which I get

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

Problem

Code

Output which I get

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related