How to show all of columns name on pandas dataframe

Question

I have a dataframe that consist of hundreds of columns  and I need to see all column names   What I did   In 37   data all2 columns   The output is   Out 37   Index   customer id    incoming    outgoing    awan    bank    family    food           government    internet    isipulsa                      overdue 3months feature78    overdue 3months feature79           overdue 3months feature80    overdue 3months feature81           overdue 3months feature82    overdue 3months feature83           overdue 3months feature84    overdue 3months feature85           overdue 3months feature86    loan overdue 3months total y          dtype  object   length 102    How do I show all columns  instead of a truncated list

User · Accepted Answer

You can globally set printing options  I think this should work  Method 1  pd set option  display max columns   None  pd set option  display max rows   None   Method 2  pd options display max columns   None pd options display max rows   None  This will allow you to see all column names  amp  rows when you are doing  head    None of the column name will be truncated   If you just want to see the column names you can do  print df columns tolist

User · Answer

Not a conventional answer  but I guess you could transpose the dataframe to look at the rows instead of the columns  I use this because I find looking at rows more  intuitional  than looking at columns   data all2 T   This should let you view all the rows  This action is not permanent  it just lets you view the transposed version of the dataframe   If the rows are still truncated  just use print data all2 T  to view everything

User · Answer

If you just want to see all the columns you can do something of this sort as a quick fix  cols   data all2 columns   now cols will behave as a iterative variable that can be indexed  for example  cols 11 20

User · Answer

This will do the trick  Note the use of display   instead of print   with pd option context  display max rows   5   display max columns   None        display my df    EDIT   The use of display is required because pd option context settings only apply to display and not to print

User · Answer

The easiest way I ve found is just list df columns   Personally I wouldn t want to change the globals  it s not that often I want to see all the columns names

User · Answer

A quick and dirty solution would be to convert it to a string  print   t  join data all2 columns     would cause all of them to be printed out separated by tabs Of course  do note that with 102 names  all of them rather long  this will be a bit hard to read through

User · Answer

What worked for me was the following   pd options display max seq items   None   You can also set it to an integer larger than your number of columns

User · Answer

you can try this  pd pandas set option  display max columns   None

User · Answer

In the interactive console  it s easy to do   data all2 columns tolist     Or this within a script   print data all2 columns tolist

User · Answer

I know it is a repetition but I always end up copy pasting and modifying YOLO s answer   pd set option  display max columns   500  pd set option  display max rows   500

User · Answer

To obtain all the column names of a DataFrame  df data in this example  you just need to use the command df data columns values  This will show you a list with all the Column names of your Dataframe  Code   df data pd read csv     input data csv   print df data columns values    Output     PassengerId   Survived   Pclass   Name   Sex   Age   SibSp   Parch   Ticket   Fare   Cabin   Embarked

User · Answer

I had lots of duplicate column names  and once I ran  df   df loc    df columns duplicated      I was able to see the full list of columns  Credit  https   stackoverflow com a 40435354 5846417

User · Answer

To get all column name you can iterate over the data all2 columns   columns   data all2 columns for col in columns      print col   You will get all column names  Or you can store all column names to another list variable and then print list

[python] How to show all of columns name on pandas dataframe?

Examples related to python

Examples related to pandas

Examples related to dataframe

Examples related to show