Add "load more columns button" and columns-displayed info

[paddymul]

Checks

• I have checked that this enhancement has not already been requested

How would you categorize this request. You can select multiple if not sure

Summary stats, Other (please describe in Issue Description)

Enhancement Description

If you want to display a dataframe with greater than the max columns (250 default), the last column should be a button that will load the next segment.

so clicking the last column will load 250-330 in a 330 column dataframe.

The columns displayed in the status bar should reflect which segment of columns is currently displayed.

Further when the left most column displayed isn't column 0, column 0 should be a button to display the previous set of columns.

Once this is implemented, the max columns should be reduced to 50 or 100. Wanting to look at large numbers of columns is rare, slow, and still confusing. Also the column range used should be able to be rpeset

Pseudo Code Implementation

above

Prior Art

N/A

I see that button is not clickable inside pandas dataframe.Button is only clickable using ipywidgets.This is one solution.

import pandas as pd
import ipywidgets as widgets
from IPython.display import display, clear_output
import buckaroo
df = pd.DataFrame({f"col_{i}": [i] for i in range(330)})
MAX_COLS = 100
start_col = 0
output = widgets.Output()
status = widgets.HTML()
prev_btn = widgets.Button(description="◀ Prev")
next_btn = widgets.Button(description="▶ Next")
nav_box = widgets.HBox([prev_btn, next_btn])
ui = widgets.VBox([status, nav_box, output])
display(ui)
def display_segment(start):
total_cols = df.shape[1]
end = min(start + MAX_COLS, total_cols)
segment = df.iloc[:, start:end]
status.value = f"<b>Showing columns {start} to {end - 1} of {total_cols}</b>"
with output:
clear_output(wait=True)
display(segment)
prev_btn.disabled = start == 0
next_btn.disabled = end >= total_cols
return start
current_start = start_col
display_segment(current_start)
def on_prev(b):
global current_start
current_start = max(0, current_start - MAX_COLS)
display_segment(current_start)
def on_next(b):
global current_start
current_start = min(df.shape[1] - MAX_COLS, current_start + MAX_COLS)
display_segment(current_start)
prev_btn.on_click(on_prev)
next_btn.on_click(on_next)