Tablexplore is an application for data analysis and plotting built in Python using the PySide2/Qt toolkit.

Last update: Dec 26, 2022

Overview

Tablexplore

Tablexplore is an application for data analysis and plotting built in Python using the PySide2/Qt toolkit. It uses the pandas DataFrame class to store the table data. Pandas is an open source Python library providing high-performance data structures and data analysis tools.

This application is intended primarily for educational/scientific use and allows quick visualization of data with convenient plotting. The primary goal is to let users explore their tables interactively without any prior programming knowledge and make interesting plots as they do this. One advantage is the ability to load and work with relatively large tables as compared to spreadsheets. The focus is on data manipulation rather than data entry. Though basic cell editing and row/column changes are supported.

Installation

For all operating systems with Python and pip installed:

pip install -e git+https://github.com/dmnfarrell/tablexplore.git#egg=tablexplore

Linux

The pip method above should work fine for most distributions but if you prefer you can also try the AppImage (experimental). Download from the latest release page and run as follows:

chmod +x tablexplore-0.3.0-x86_64.AppImage
./tablexplore-0.3.0-x86_64.AppImage

There is also a snap available, which can be installed using:

snap install tablexplore

Windows

A Windows standalone binary can be downloaded here.

Current features

save and load projects
import csv/hdf/from urls
delete/add columns
groupby-aggregate/pivot/transpose/melt operations
merge tables
show sub-tables
plotting mostly works
apply column functions, resample, transform, string methods and date/time conversion
python interpreter

Screenshots

Videos

https://www.youtube.com/watch?v=nscmtsG5SKQ

Use the widget in Python

from PySide2 import QtCore
from PySide2.QtWidgets import *
from PySide2.QtGui import *
import pandas as pd
from tablexplore import data, core, plotting, interpreter

class TestApp(QMainWindow):
    def __init__(self, project_file=None, csv_file=None):

        QMainWindow.__init__(self)
        self.setAttribute(QtCore.Qt.WA_DeleteOnClose)
        self.setWindowTitle("Example")
        self.setGeometry(QtCore.QRect(200, 200, 800, 600))
        self.main = QWidget()
        self.setCentralWidget(self.main)
        layout = QVBoxLayout(self.main)
        df = data.getSampleData()
        t = core.DataFrameWidget(self.main,dataframe=df)
        layout.addWidget(t)
        #show a Python interpreter
        t.showInterpreter()
        return

if __name__ == '__main__':
    import sys
    app = QApplication(sys.argv)
    aw = TestApp()
    aw.show()
    app.exec_()

Graph Zoom-in // Zoom-out odd behaviour

When you click to Zoom-in // Zoom-out on the top right corner of the graph, it changes the text size, but display doesn't zoom at all. Is this normal behavior or maybe a bug? Maybe it's just the magnifier glass icon which is misleading.

opened by Goran-L 3
Bump numpy from 1.19.5 to 1.21.0
Bumps numpy from 1.19.5 to 1.21.0.

Release notes

Sourced from numpy's releases.

v1.21.0

NumPy 1.21.0 Release Notes

The NumPy 1.21.0 release highlights are

continued SIMD work covering more functions and platforms,

initial work on the new dtype infrastructure and casting,

universal2 wheels for Python 3.8 and Python 3.9 on Mac,

improved documentation,

improved annotations,

new PCG64DXSM bitgenerator for random numbers.

In addition there are the usual large number of bug fixes and other improvements.

The Python versions supported for this release are 3.7-3.9. Official support for Python 3.10 will be added when it is released.

:warning: Warning: there are unresolved problems compiling NumPy 1.21.0 with gcc-11.1 .

Optimization level -O3 results in many wrong warnings when running the tests.

On some hardware NumPy will hang in an infinite loop.

New functions

Add PCG64DXSM BitGenerator

Uses of the PCG64 BitGenerator in a massively-parallel context have been shown to have statistical weaknesses that were not apparent at the first release in numpy 1.17. Most users will never observe this weakness and are safe to continue to use PCG64. We have introduced a new PCG64DXSM BitGenerator that will eventually become the new default BitGenerator implementation used by default_rng in future releases. PCG64DXSM solves the statistical weakness while preserving the performance and the features of PCG64.

See upgrading-pcg64 for more details.

(gh-18906)

Expired deprecations

The shape argument numpy.unravel_index cannot be passed as dims keyword argument anymore. (Was deprecated in NumPy 1.16.)

... (truncated)

Commits

b235f9e Merge pull request #19283 from charris/prepare-1.21.0-release

34aebc2 MAINT: Update 1.21.0-notes.rst

493b64b MAINT: Update 1.21.0-changelog.rst

07d7e72 MAINT: Remove accidentally created directory.

032fca5 Merge pull request #19280 from charris/backport-19277

7d25b81 BUG: Fix refcount leak in ResultType

fa5754e BUG: Add missing DECREF in new path

61127bb Merge pull request #19268 from charris/backport-19264

143d45f Merge pull request #19269 from charris/backport-19228

d80e473 BUG: Removed typing for == and != in dtypes

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies
opened by dependabot[bot] 1
Link to blog not working

On https://dmnfarrell.github.io/tablexplore/, there is a link to "My Blog", which links to https://dmnfarrell.github.com/. I think that should be dmnfarrell.github.io.

The app looks great, by the way. I used Pandastable before and just found out about Tablexplore, so I'm interested to try Tablexplore now.

opened by DataExplorerUser 1
Bump numpy from 1.21.5 to 1.22.0
Bumps numpy from 1.21.5 to 1.22.0.

Release notes

Sourced from numpy's releases.

v1.22.0

NumPy 1.22.0 Release Notes

NumPy 1.22.0 is a big release featuring the work of 153 contributors spread over 609 pull requests. There have been many improvements, highlights are:

Annotations of the main namespace are essentially complete. Upstream is a moving target, so there will likely be further improvements, but the major work is done. This is probably the most user visible enhancement in this release.

A preliminary version of the proposed Array-API is provided. This is a step in creating a standard collection of functions that can be used across application such as CuPy and JAX.

NumPy now has a DLPack backend. DLPack provides a common interchange format for array (tensor) data.

New methods for quantile, percentile, and related functions. The new methods provide a complete set of the methods commonly found in the literature.

A new configurable allocator for use by downstream projects.

These are in addition to the ongoing work to provide SIMD support for commonly used functions, improvements to F2PY, and better documentation.

The Python versions supported in this release are 3.8-3.10, Python 3.7 has been dropped. Note that 32 bit wheels are only provided for Python 3.8 and 3.9 on Windows, all other wheels are 64 bits on account of Ubuntu, Fedora, and other Linux distributions dropping 32 bit support. All 64 bit wheels are also linked with 64 bit integer OpenBLAS, which should fix the occasional problems encountered by folks using truly huge arrays.

Expired deprecations

Deprecated numeric style dtype strings have been removed

Using the strings "Bytes0", "Datetime64", "Str0", "Uint32", and "Uint64" as a dtype will now raise a TypeError.

(gh-19539)

Expired deprecations for loads, ndfromtxt, and mafromtxt in npyio

numpy.loads was deprecated in v1.15, with the recommendation that users use pickle.loads instead. ndfromtxt and mafromtxt were both deprecated in v1.17 - users should use numpy.genfromtxt instead with the appropriate value for the usemask parameter.

(gh-19615)

... (truncated)

Commits

4adc87d Merge pull request #20685 from charris/prepare-for-1.22.0-release

fd66547 REL: Prepare for the NumPy 1.22.0 release.

125304b wip

c283859 Merge pull request #20682 from charris/backport-20416

5399c03 Merge pull request #20681 from charris/backport-20954

f9c45f8 Merge pull request #20680 from charris/backport-20663

794b36f Update armccompiler.py

d93b14e Update test_public_api.py

7662c07 Update init.py

311ab52 Update armccompiler.py

Additional commits viewable in compare view

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options

You can trigger Dependabot actions by commenting on this PR:

@dependabot rebase will rebase this PR

@dependabot recreate will recreate this PR, overwriting any edits that have been made to it

@dependabot merge will merge this PR after your CI passes on it

@dependabot squash and merge will squash and merge this PR after your CI passes on it

@dependabot cancel merge will cancel a previously requested merge and block automerging

@dependabot reopen will reopen this PR if it is closed

@dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually

@dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)

@dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)

@dependabot use these labels will set the current labels as the default for future PRs for this repo and language

@dependabot use these reviewers will set the current reviewers as the default for future PRs for this repo and language

@dependabot use these assignees will set the current assignees as the default for future PRs for this repo and language

@dependabot use this milestone will set the current milestone as the default for future PRs for this repo and language

You can disable automated security fix PRs for this repo from the Security Alerts page.

dependencies
opened by dependabot[bot] 0
Python interpreter command does not refresh table display

Hi, Disclaimer: I might be misusing the python command/interpreter, or it might be a bug as well ^^

When I execute a python command in the interpreter, the Table Display does not updates after the command. Whereas the Table info shows that the command was executed (The column "Deux" is created... but not visible). I think the screenshot below is a better explanation.

How to update the Table display? Am I missing something?

Thanks in advance

Goran

EDIT: I just found a workaround (or normal behaviour): The Table Display gets refreshed with Clean Table Button

opened by Goran-L 2
No module named 'scipy'

Hi, first I wanted to thank you for the amazing work you did with Tablexplore. I've been testing the latest version and I think I found some bugs. I could reproduce it on Windows 7 and 10:

If I choose plot type: density and axes layout multiple Tablexplore will throw an error

=> No module named 'scipy'

The Log Windows Command doesn't show any supplemental info about the error.

opened by Goran-L 5
replaced Qt bindings with qtpy

The Spyder project has developed a QtPy: Abstraction layer for PyQt5/PyQt4/PySide2/PySide that can be used to provide a more flexible use to the system available Qt modules.

A minor modification to the import call make it possible to set the module based on the environment variable QT_API.

opened by EmanueleCannizzaro 2

Releases(v0.5.1)

v0.5.1(May 22, 2022)
fix to duplicate sheet bug

column headers now wrap long text to fit width

changed plugins to dock in app, not table

updated tests plugin

colormap plugin

Source code(tar.gz)
Source code(zip)
tablexplore-setup-0.5.1.exe(46.07 MB)
v0.5.0(May 10, 2022)
re-did plot widgets, now movable docks

now saves table selections, scroll position

improvements to pie plot

try to always get numeric values for plotting

scratchpad - stores plots, tables, text

xlabel rotation

de-duplicate col names option

float precision setting

background color setting

column fill dates

Source code(tar.gz)
Source code(zip)
tablexplore-setup-0.5.0.exe(45.71 MB)
v0.4.1(Oct 4, 2021)
fix to saving when filtered

align header labels left

remember current sheet when saving

added enlarge/reduce buttons to plot toolbar

icon size preference

fix to plot style

format date index

sort by index

moved dpi to preferences

Source code(tar.gz)
Source code(zip)
tablexplore-setup-0.4.1.exe(46.55 MB)
v0.4.0(Aug 12, 2021)
append tables

will use PyQt5 if PySide2 not present

plugin system

GIS plugin

fill option with add column

fixes to import dialog

import multiple files

merge/concat sheets

hide plotter

disable col highlight for large tables

find/replace dialog

organise cols dialog

Source code(tar.gz)
Source code(zip)
tablexplore-setup-0.4.0.exe(46.56 MB)
v0.3.0(Jan 9, 2021)
progress bar for saving

added filtering tool

snap works

fixes to import dialog

can now set datetime display format

show memory usage in status bar

Source code(tar.gz)
Source code(zip)
tablexplore-0.3.0-x86_64.AppImage(221.38 MB)
tablexplore_setup_0.3.0.exe(55.88 MB)
v0.2.0(Dec 31, 2020)
manually set row and col layout in multiple subplots

can save zoom of tables and column widths

enabled using twin axes for line plots

selections use proper column order

now saves column order

date formatter

remembers recent files

saves previous urls for importing

added string operations

sort by index

sort by multiple columns

resample/transform

fixes to merge

Source code(tar.gz)
Source code(zip)
tablexplore_setup_0.2.0.exe(55.75 MB)
v0.1.0(Dec 21, 2020)
Initial release

What works so far:

save and load projects - saves figures, table state and plot options

import csv/hdf/from urls

delete/add columns, delete/add rows

groupby-aggregate/pivot/transpose/melt operations

merge tables

show sub-tables

basic python interpreter to manipulate table

plotting mostly works

remember some app settings

cache plots for saving later

Source code(tar.gz)
Source code(zip)

Owner

Damien Farrell

Research Fellow UCD Veterinary School ORCID ID: 0000-0003-3020-7945

GitHub Repository

Tablexplore is an application for data analysis and plotting built in Python using the PySide2/Qt toolkit.

Related tags

Overview

Tablexplore

Installation

Linux

Windows

Current features

Screenshots

Videos

Use the widget in Python

See also

Comments

Graph Zoom-in // Zoom-out odd behaviour

Bump numpy from 1.19.5 to 1.21.0

v1.21.0

NumPy 1.21.0 Release Notes

New functions

Add PCG64DXSM BitGenerator

Expired deprecations

Link to blog not working

Bump numpy from 1.21.5 to 1.22.0

v1.22.0

NumPy 1.22.0 Release Notes

Expired deprecations

Deprecated numeric style dtype strings have been removed

Expired deprecations for loads, ndfromtxt, and mafromtxt in npyio

Python interpreter command does not refresh table display

No module named 'scipy'

replaced Qt bindings with qtpy

Releases(v0.5.1)

v0.5.1(May 22, 2022)

v0.5.0(May 10, 2022)

v0.4.1(Oct 4, 2021)

v0.4.0(Aug 12, 2021)

v0.3.0(Jan 9, 2021)

v0.2.0(Dec 31, 2020)

v0.1.0(Dec 21, 2020)

Initial release

Owner

Damien Farrell

Pandas and Spark DataFrame comparison for humans

A utility for functional piping in Python that allows you to access any function in any scope as a partial.

Evidence enables analysts to deliver a polished business intelligence system using SQL and markdown.

A real data analysis and modeling project - restaurant inspections

Building house price data pipelines with Apache Beam and Spark on GCP

Big Data & Cloud Computing for Oceanography

Data processing with Pandas.

Pypeln is a simple yet powerful Python library for creating concurrent data pipelines.

Data exploration done quick.

Using approximate bayesian posteriors in deep nets for active learning

A probabilistic programming language in TensorFlow. Deep generative models, variational inference.

X-news - Pipeline data use scrapy, kafka, spark streaming, spark ML and elasticsearch, Kibana

An experimental project I'm undertaking for the sole purpose of increasing my Python knowledge

A Big Data ETL project in PySpark on the historical NYC Taxi Rides data

PyTorch implementation for NCL (Neighborhood-enrighed Contrastive Learning)

Handle, manipulate, and convert data with units in Python

Python script for transferring data between three drives in two separate stages

The official repository for ROOT: analyzing, storing and visualizing big data, scientifically

Example Of Splunk Search Query With Python And Splunk Python SDK

Hue Editor: Open source SQL Query Assistant for Databases/Warehouses

Expired deprecations for `loads`, `ndfromtxt`, and `mafromtxt` in npyio