pandas dataframe print all columns code example

Example 1: python show all columns

pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)

Example 2: pd show all columns

pd.set_option('max_columns', None)

Example 3: pandas print all columns

# This will print all columns and rows
# 'display.max_colwidth', -1  will print entire row content

pd.set_option("display.max_rows", None, "display.max_columns", None,'display.max_colwidth', -1)

Example 4: view all columns pandas

print(dataframe.columns)

Example 5: pandas show all dataframe method

# with HTML output
from IPython.display import display_html

def display_frames(frames, num_space=0):
    t_style = '<table style="display: inline;"'
    tables_html = [df.to_html().replace('<table',t_style)
                  for df in frames]
    space = '&nbsp;' * num_space
    display_html(space.join(tables_html),raw=True)

years = 2016,2017,2018 # initial data.
stock_tables = [pd.read_csv('stocks_{}.csv'.format(year))
                for year in years]

display_frames(stock_tables,10)
stocks_2016, stocks_2017, stocks_2018 = stock_tables