# solution to the problem pd.set_option('display.max_columns', 1000) #reset option to default value pd.reset_option('display.max_rows') pd.reset_option('display.max_columns') #and reset all of them back: pd.reset_option('all')