Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
head()
#1
the command 'head()' only partially displays the excel file I am dealing with.
How do I display the whole file?

these lines
data=pd.read_excel(r'excelfile.xlsx')
print(data.head())
only print 5 rows and 5 columns (default value) and If I add a parameter to 'head()'
The rows and columns shown will be different but still no more than 5.

How do I show the excel file in its entirety ?
Reply


Messages In This Thread
head() - by d8a988 - Sep-02-2020, 09:32 PM
RE: head() - by Larz60+ - Sep-03-2020, 04:05 AM
RE: head() - by perfringo - Sep-03-2020, 04:11 AM
RE: head() - by d8a988 - Sep-03-2020, 07:26 AM
RE: head() - by buran - Sep-03-2020, 09:08 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  pandas head() not reading all rows naab 0 1,819 Apr-07-2020, 01:06 PM
Last Post: naab

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020