tabulous.commands package

Submodules

tabulous.commands.analysis module

tabulous.commands.analysis.polynomial_fit(viewer: TableViewerBase)

Polynomial fitting of 1D data

tabulous.commands.analysis.show_column_filter_widget(viewer: TableViewerBase)

Show column filter widget.

tabulous.commands.analysis.show_eval_widget(viewer: TableViewerBase)

Evaluate a Python expression

tabulous.commands.analysis.show_filter_widget(viewer: TableViewerBase)

Show filter widget.

tabulous.commands.analysis.show_optimizer_widget(viewer: TableViewerBase)

Open optimizer widget

tabulous.commands.analysis.show_scipy_stats_widget(viewer: TableViewerBase)

Analyze data distribution with scipy.stats

tabulous.commands.analysis.show_sklearn_widget(viewer: TableViewerBase)

Open scikit-learn widget

tabulous.commands.analysis.show_stats_widget(viewer: TableViewerBase)

Statistical test with scipy.stats

tabulous.commands.analysis.summarize_table(viewer: TableViewerBase)

Summarize table data

tabulous.commands.column module

tabulous.commands.column.adjust_brightness_background_colormap(viewer: TableViewerBase) → None

Adjust brightness of the background colormap

tabulous.commands.column.adjust_brightness_text_colormap(viewer: TableViewerBase) → None

Adjust brightness of the text colormap

tabulous.commands.column.invert_background_colormap(viewer: TableViewerBase) → None

Invert background colormap

tabulous.commands.column.invert_text_colormap(viewer: TableViewerBase) → None

Invert text colormap

tabulous.commands.column.reset_background_colormap(viewer: TableViewerBase) → None

Reset background colormap

tabulous.commands.column.reset_text_colormap(viewer: TableViewerBase) → None

Reset text colormap

tabulous.commands.column.reset_text_formatter(viewer: TableViewerBase) → None

Reset text formatter

tabulous.commands.column.run_cut(viewer: TableViewerBase)

Cut a table column into bins (pd.cut)

tabulous.commands.column.run_groupby(viewer: TableViewerBase) → None

Group table by its columns (pd.groupby)

tabulous.commands.column.set_background_colormap(viewer: TableViewerBase) → None

Set background colormap to a column

tabulous.commands.column.set_background_colormap_opacity(viewer: TableViewerBase) → None

Set opacity to the background colormap

tabulous.commands.column.set_text_colormap(viewer: TableViewerBase) → None

Set text colormap to a column

tabulous.commands.column.set_text_colormap_opacity(viewer: TableViewerBase) → None

Set opacity to the text colormap

tabulous.commands.column.set_text_formatter(viewer: TableViewerBase) → None

Set text formatter

tabulous.commands.file module

tabulous.commands.file.open_sample(viewer: TableViewerBase)

Open sample data

tabulous.commands.file.open_spreadsheet(viewer: TableViewerBase)

Open a file as a spreadsheet

tabulous.commands.file.open_table(viewer: TableViewerBase)

Open a file as a table

tabulous.commands.file.save_as_xlsx(viewer: TableViewerBase)

Save all tables to an Excel book

tabulous.commands.file.save_table(viewer: TableViewerBase)

Save current table data

tabulous.commands.file.save_table_to_source(viewer: TableViewerBase)

Save current table data to the source file if exists

tabulous.commands.plot module

class tabulous.commands.plot.PlotInfo(names, columns)

Bases: NamedTuple

columns: slice

Alias for field number 1

names: list[Hashable]

Alias for field number 0

tabulous.commands.plot.bar(viewer: TableViewerBase)

Run plt.bar

tabulous.commands.plot.barplot(viewer: TableViewerBase)

Run sns.barplot

tabulous.commands.plot.boxenplot(viewer: TableViewerBase)

Run sns.boxenplot

tabulous.commands.plot.boxplot(viewer: TableViewerBase)

Run sns.boxplot

tabulous.commands.plot.errorbar(viewer: TableViewerBase)

Run plt.errorbar

tabulous.commands.plot.fill_between(viewer: TableViewerBase)

Run plt.fill_between

tabulous.commands.plot.fill_betweenx(viewer: TableViewerBase)

Run plt.fill_betweenx

tabulous.commands.plot.hist(viewer: TableViewerBase)

Run plt.hist

tabulous.commands.plot.new_figure(viewer: TableViewerBase)

New figure canvas

tabulous.commands.plot.plot(viewer: TableViewerBase)

Run plt.plot

tabulous.commands.plot.scatter(viewer: TableViewerBase)

Run plt.scatter

tabulous.commands.plot.stripplot(viewer: TableViewerBase)

Run sns.stripplot

tabulous.commands.plot.swarmplot(viewer: TableViewerBase)

Run sns.swarmplot

tabulous.commands.plot.violinplot(viewer: TableViewerBase)

Run sns.violinplot

tabulous.commands.selection module

tabulous.commands.selection.add_highlight(viewer: TableViewerBase)

Add highlight to cells

tabulous.commands.selection.copy_as_html(viewer: TableViewerBase)

Copy as HTML text

tabulous.commands.selection.copy_as_latex(viewer: TableViewerBase)

Copy as LaTeX text

tabulous.commands.selection.copy_as_literal(viewer: TableViewerBase)

Copy as literal

tabulous.commands.selection.copy_as_markdown(viewer: TableViewerBase)

Copy as markdown text

tabulous.commands.selection.copy_as_new_spreadsheet(viewer: TableViewerBase)

Copy as new spreadsheet

tabulous.commands.selection.copy_as_new_table(viewer: TableViewerBase)

Copy as new table

tabulous.commands.selection.copy_as_rst_grid(viewer: TableViewerBase)

Copy as reStructuredText (rst) grid table

tabulous.commands.selection.copy_as_rst_simple(viewer: TableViewerBase)

Copy as reStructuredText (rst) simple table

tabulous.commands.selection.copy_data_comma_separated(viewer: TableViewerBase)

Copy cells (comma separated)

tabulous.commands.selection.copy_data_tab_separated(viewer: TableViewerBase)

Copy cells (tab separated)

tabulous.commands.selection.copy_data_with_header_comma_separated(viewer: TableViewerBase)

Copy cells with headers (comma separated)

tabulous.commands.selection.copy_data_with_header_tab_separated(viewer: TableViewerBase)

Copy cells with headers (tab separated)

tabulous.commands.selection.cut_data(viewer: TableViewerBase)

Cut selected cells

tabulous.commands.selection.delete_selected_highlight(viewer: TableViewerBase)

Delete selected highlight

tabulous.commands.selection.delete_values(viewer: TableViewerBase)

Delete selected cells

tabulous.commands.selection.edit_current(viewer: TableViewerBase) → None

Edit current cell

tabulous.commands.selection.filter_by_columns(viewer: TableViewerBase) → None

Filter by selected columns

tabulous.commands.selection.insert_column_left(viewer: TableViewerBase)

Insert a column left

tabulous.commands.selection.insert_column_right(viewer: TableViewerBase)

Insert a column right

tabulous.commands.selection.insert_row_above(viewer: TableViewerBase)

Insert a row above

tabulous.commands.selection.insert_row_below(viewer: TableViewerBase)

Insert a row below

tabulous.commands.selection.paste_data_comma_separated(viewer: TableViewerBase)

Paste from comma separated text

tabulous.commands.selection.paste_data_from_markdown(viewer: TableViewerBase)

Paste from Markdown text

tabulous.commands.selection.paste_data_from_numpy_string(viewer: TableViewerBase)

Paste from numpy-style text

tabulous.commands.selection.paste_data_from_rst(viewer: TableViewerBase)

Paste from reStructuredText (rst) table

tabulous.commands.selection.paste_data_space_separated(viewer: TableViewerBase)

Paste from space separated text

tabulous.commands.selection.paste_data_tab_separated(viewer: TableViewerBase)

Paste from tab separated text

tabulous.commands.selection.raise_slot_error(viewer: TableViewerBase)

Show traceback at the cell

tabulous.commands.selection.remove_selected_columns(viewer: TableViewerBase)

Remove selected columns

tabulous.commands.selection.remove_selected_rows(viewer: TableViewerBase)

Remove selected rows

tabulous.commands.selection.select_all(viewer: TableViewerBase)

Select all the cells

tabulous.commands.selection.set_column_dtype(viewer: TableViewerBase)

Set column specific dtype for data conversion and validation.

tabulous.commands.selection.show_context_menu(viewer: TableViewerBase)

Execute context menu

tabulous.commands.selection.shuffle_data_column_wise(viewer: TableViewerBase) → None

Shuffle table data columnwise

tabulous.commands.selection.sort_by_columns(viewer: TableViewerBase) → None

Sort by column(s)

tabulous.commands.selection.sort_inplace(viewer: TableViewerBase) → None

Sort table data inplace

tabulous.commands.selection.write_data_reference_in_console(viewer: TableViewerBase) → None

Write data reference to console

tabulous.commands.selection.write_data_signal_in_console(viewer: TableViewerBase)

Write data signal connection to console

tabulous.commands.selection.write_slice_in_console(viewer: TableViewerBase) → None

Write data slice to console

tabulous.commands.tab module

tabulous.commands.tab.activate_left(viewer: TableViewerBase)

Activate left table.

tabulous.commands.tab.activate_right(viewer: TableViewerBase)

Activate right table.

tabulous.commands.tab.delete_tab(viewer: TableViewerBase) → None

Delete current tab.

tabulous.commands.tab.rename_tab(viewer: TableViewerBase)

Rename tab.

tabulous.commands.tab.swap_tab_with_left(viewer: TableViewerBase)

Swap the current tab with the left one

tabulous.commands.tab.swap_tab_with_right(viewer: TableViewerBase)

Swap the current tab with the right one

tabulous.commands.tab.tile_tables(viewer: TableViewerBase)

Tile tabs

tabulous.commands.tab.tile_with_adjacent_table(viewer: TableViewerBase)

Tile adjacent tabs

tabulous.commands.tab.untile_table(viewer: TableViewerBase)

Untile current tab

tabulous.commands.table module

tabulous.commands.table.concat(viewer: TableViewerBase)

Concatenate table data (pd.concat)

tabulous.commands.table.copy_as_spreadsheet(viewer: TableViewerBase)

Copy current table as a new spreadsheet

tabulous.commands.table.copy_as_table(viewer: TableViewerBase)

Copy current table as a new table

tabulous.commands.table.copy_to_clipboard(viewer: TableViewerBase)

tabulous.commands.table.date_range(viewer: TableViewerBase)

Generate a range of date values (pd.date_range)

tabulous.commands.table.dropna(viewer: TableViewerBase)

Drop nan values (pd.dropna)

tabulous.commands.table.fillna(viewer: TableViewerBase)

Fill nan values (pd.fillna)

tabulous.commands.table.interval_range(viewer: TableViewerBase)

Generate a range of interval values (pd.interval_range)

tabulous.commands.table.jump_to_cell(viewer: TableViewerBase)

Jump to a cell.

tabulous.commands.table.map_values(viewer: TableViewerBase)

Map values of selected column (pd.Series.map)

tabulous.commands.table.melt(viewer: TableViewerBase)

Melt (unpivot) current table data on selected columns if any (pd.melt)

tabulous.commands.table.merge(viewer: TableViewerBase)

Merge two tables (pd.merge)

tabulous.commands.table.new_spreadsheet(viewer: TableViewerBase)

Add an empty spreadsheet.

tabulous.commands.table.period_range(viewer: TableViewerBase)

Generate a range of period values (pd.period_range)

tabulous.commands.table.pivot(viewer: TableViewerBase)

Pivot current table data (pd.pivot)

tabulous.commands.table.random(viewer: TableViewerBase)

Generate random values

tabulous.commands.table.redo_table(viewer: TableViewerBase)

Redo table operation

tabulous.commands.table.reset_proxy(viewer: TableViewerBase) → None

Reset proxy (sort/filter)

tabulous.commands.table.round(viewer: TableViewerBase)

Round table data

tabulous.commands.table.show_finder_widget(viewer: TableViewerBase)

Toggle finder widget

tabulous.commands.table.show_undo_stack_view(viewer: TableViewerBase)

Show undo stack view

tabulous.commands.table.switch_columns(viewer: TableViewerBase)

Switch column header and the top row

tabulous.commands.table.switch_index(viewer: TableViewerBase)

Switch index header and the left column

tabulous.commands.table.switch_layout(viewer: TableViewerBase)

Switch table layout

tabulous.commands.table.timedelta_range(viewer: TableViewerBase)

Generate a range of timedelta values (pd.timedelta_range)

tabulous.commands.table.toggle_editability(viewer: TableViewerBase)

Toggle table editability

tabulous.commands.table.transpose(viewer: TableViewerBase)

Transpose current table data

tabulous.commands.table.undo_table(viewer: TableViewerBase)

Undo table operation

tabulous.commands.table.zoom_in(viewer: TableViewerBase)

Zoom in

tabulous.commands.table.zoom_out(viewer: TableViewerBase)

Zoom in

tabulous.commands.view module

tabulous.commands.view.reset_view_mode(viewer: TableViewerBase)

Reset view mode

tabulous.commands.view.set_dual_h_mode(viewer: TableViewerBase)

Horizontal dual-view

tabulous.commands.view.set_dual_v_mode(viewer: TableViewerBase)

Vertical dual-view

tabulous.commands.view.set_popup_mode(viewer: TableViewerBase)

Popup table.

tabulous.commands.window module

tabulous.commands.window.add_file_explorer(viewer: TableViewerBase)

Add a file explorer dock widget.

tabulous.commands.window.add_text_edit(viewer: TableViewerBase)

Add a note (text edit) dock widget.

tabulous.commands.window.close_window(viewer: TableViewerBase)

Close window

tabulous.commands.window.focus_table(viewer: TableViewerBase)

Move focus to the table.

tabulous.commands.window.new_window(viewer: TableViewerBase)

Create a new window

tabulous.commands.window.show_command_palette(viewer: TableViewerBase)

Show the command palette.

tabulous.commands.window.show_keymap(viewer: TableViewerBase)

Show key map widget

tabulous.commands.window.show_preference(viewer: TableViewerBase)

Show preference dialog

tabulous.commands.window.toggle_console(viewer: TableViewerBase)

Toggle QtConsole visibility

tabulous.commands.window.toggle_focus(viewer: TableViewerBase)

Toggle focus between table and command palette.

tabulous.commands.window.toggle_fullscreen(viewer: TableViewerBase)

Toggle fullscreen

tabulous.commands.window.toggle_toolbar(viewer: TableViewerBase)

Toggle toolbar visibility

Module contents

tabulous.commands.iter_commands() → Iterator[tuple[str, function]]

tabulous.commands.register_command(func: Callable = None, title: str = 'User defined', desc: str = None) → Callable[[Callable[[TableViewerBase], Any]], Callable[[TableViewerBase], Any]]