Python Forum
Seeing al the data in a dataframe or numpy.array
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Seeing al the data in a dataframe or numpy.array
#1
I am programming in Python and reading large file. Itis a csv file. When I code df on a single line it gives me a lot of information on the file, the data to be specific. However, it does give me enough info.

When going horizontally, going across a row the data columns stop after about 10 columns and uses an ellipsis (...) to say this is continued and it then finishes the whole row by picking up and showing the data for the last ten columns. That leaves of over 30 missing columns in my case.

Now I want to see those columns and what is in them. I do not want an ellipsis. I want the data instead of those missing columns.

I know that this also happens in a similar fashion when going vertically down a column. Several rows are missing and in their place is an ellipsis.

How do I see all the data and no ellipsis?

Any help appreciated.

Respectfully,

LZ
Reply
#2
set options:
pd.set_option("display.max_rows", None, "display.max_columns", None)
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Elegant way to apply each element of an array to a dataframe? sawtooth500 7 376 Mar-29-2024, 05:51 PM
Last Post: deanhystad
  Convert numpy array to image without loading it into RAM. DreamingInsanity 7 5,861 Feb-08-2024, 09:38 AM
Last Post: paul18fr
  IPython errors for numpy array min/max methods muelaner 1 553 Nov-04-2023, 09:22 PM
Last Post: snippsat
  Filter data into new dataframe as main dataframe is being populated cubangt 8 990 Oct-23-2023, 12:43 AM
Last Post: cubangt
  Matplot / numpy noisy data problem the57chambers 1 693 Feb-09-2023, 03:27 AM
Last Post: deanhystad
  Expand the range of a NumPy array? PythonNPC 0 745 Jan-31-2023, 02:41 AM
Last Post: PythonNPC
  Change a numpy array to a dataframe Led_Zeppelin 3 1,103 Jan-26-2023, 09:01 PM
Last Post: deanhystad
  from numpy array to csv - rounding SchroedingersLion 6 2,158 Nov-14-2022, 09:09 PM
Last Post: deanhystad
  numpy.array has no attribute head Led_Zeppelin 1 1,225 Jul-13-2022, 12:56 AM
Last Post: Led_Zeppelin
  Need help formatting dataframe data before saving to CSV cubangt 16 5,766 Jul-01-2022, 12:54 PM
Last Post: cubangt

Forum Jump:

User Panel Messages

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