The limit is your memory. ( but these limits are really large )
On the other hand, concerning the possibility of displaying a large number of rows or columns, for example in “Jupyter Notebook”, there is some predefined limits.
For example you can:
print (pd.options.display.max_columns) # <--- this will display your limit
pd.options.display.max_columns = 500 # this will set limit of columns to 500
The same idea work with rows:
display.max_rows
More details on:
https://pandas.pydata.org/pandas-docs/stable/options.html