show all dataframe pandas code example
Example 1: pandas show all rows
pd.set_option('display.max_columns', None)
pd.set_option('display.max_rows', None)
pd.set_option('display.max_colwidth', -1)
Example 2: show full pd dataframe
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
pd.set_option('display.max_colwidth', None)
Example 3: pandas show all dataframe
with pd.option_context('display.max_rows', None, 'display.max_columns', None):
print(df)
Example 4: pandas show all dataframe method
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 = ' ' * num_space
display_html(space.join(tables_html),raw=True)
years = 2016,2017,2018
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