Display all columns after running df.columns

Question

I currently have 120 columns in my DataFrame. When I execute

df.columns

I get a truncated list, where I only see 20 instead of 120 columns:

Index(['Reporting_FI', 'Reporting_FI_identification',
   'Reporting_FI_identification_type', 'Reporting_FI_street_address_1',
   'Reporting_FI_street_address_2', 'Reporting_FI_city',
   'Reporting_FI_state', 'Reporting_FI_postal_code',
   'Reporting_FI_country_code', 'Transaction_date',
   ...
   'FI_country_code_3', 'FI_name_4', 'FI_branch_4', 'FI_identification_4',
   'FI_identification_type_4', 'FI_account_number_4', 'FI_city_4',
   'FI_state_4', 'FI_country_code_4', 'Additional_infomation_2'],
  dtype='object', length=120)

How do I adjust this to display all 120?

I am not looking for:

pd.set_option('display.max_columns', 120)

Thanks

jpp · Accepted Answer · 2018-04-24 15:56:34Z

1

One easy way is to convert to list before printing:

res = df.columns.tolist()

print(res)

edited Apr 24, 2018 at 15:56

answered Apr 24, 2018 at 15:41

jpp

166k37 gold badges301 silver badges363 bronze badges

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

1 Comment

spacedustpi Over a year ago

Dang, why didn't I think of that! Very clever. Thanks.

Collectives™ on Stack Overflow

Display all columns after running df.columns

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related