Recent Releases of pandastable

pandastable - v0.14.0

From this version interactive edits to cells are prevented if they conflict with the column type i.e. entering strings into float or int columns. You will have to change column type first. Previously this would happen without the users knowledge.

Changes

  • Fixed precision bug for negative numbers
  • Mouse_wheel now works for mac
  • Removed xlrd dep
  • Column name length and max cell width in adjustColumnWidths
  • Can now use different datetime formats
  • Changed header color variable names
  • Can set row header color in prefs
  • Index header uses row header color
  • Fix to block editing when in filtered mode
  • float32 type recognised, works for precision
  • No longer allows non dtype edits unless column type is changed first
  • Page up and page down now works
  • ctrl+ and ctrl- for zooming table
  • Fix to movetoselection to redraw table
  • Show git version in help dialog

- Python
Published by dmnfarrell 11 months ago

pandastable - v0.13.1

Minor bug fixes

- Python
Published by dmnfarrell almost 3 years ago

pandastable - v0.13.0

Changes

  • Fixes to read_excel
  • HDF import
  • Fix to plot error
  • Fix to maximise app on small screens
  • Added thousand separator formatting
  • Changed tablecolheader to colheader
  • Can now set header colors on object
  • Removed vertical plot tools option
  • Hide/show plot tools button
  • Try to extract numeric from mixed data before plotting

- Python
Published by dmnfarrell almost 4 years ago

pandastable - v0.12.2

Changes

  • added editable and enable_menus parameters to Table
  • import numbers as string
  • changed to pickle for project files
  • fix to multi_index check for pandas 1.0
  • fixes to row_colors sync

- Python
Published by dmnfarrell almost 6 years ago

pandastable - v0.12.1

Changes

  • fix to mlab griddata import
  • moved to scipy for griddata
  • added col header color pref

- Python
Published by dmnfarrell over 6 years ago

pandastable - v0.12.0

Changes

  • fixes to clean data
  • convert currencies to numeric
  • column widths now saved in dataexplore
  • fix to string query to allow python code
  • new preferences system uses a text config file
  • violinplot
  • datetime conversion fixes
  • batch process plugin

- Python
Published by dmnfarrell almost 7 years ago

pandastable - v0.11.0

Changes

  • find/replace functionality added
  • open recent projects from file menu in dataexplore
  • some fixes to improve 3d plottting
  • removed redundant options from 3d panel
  • grouped scatter plots in 3D
  • removed redundant data in saving of plot options
  • drop down entry menu for categorical columns
  • crosstab function
  • added radviz plot
  • improved multi-index column display

- Python
Published by dmnfarrell over 7 years ago

pandastable - v0.10.0

Changes

  • Fix to dropping index when no name
  • Added dotplot
  • Added axis tick and tick label format options
  • Added plotting animation dialog
  • Added ability to label points in scatter plots using a column
  • Can set point sizes in scatter from a column
  • Fix to plot frame closing bug
  • Added empty column selection for groupby option
  • Fixes to copy/paste and saving projects in snap
  • Long column names now wrapped in plots
  • Can now wrap column header text
  • Fix to column resizing
  • Expand/contract columns buttons

- Python
Published by dmnfarrell over 7 years ago

pandastable - v0.9.0

Changes

  • Row/col options for sample data
  • Fixed scrolling up/down and right/left for arrow keys
  • Re-did aggregate dialog to be more general
  • Resample/transform functions for columns
  • Added find duplicates dialog
  • Zoom in/out functions to view menu
  • Improved grid layout dialog to use interactive grid
  • Ability to auto create multi plot views in grid
  • Ability to split data over multiple grid plots
  • Fix to slow loading of large tables
  • Import csv from URL

- Python
Published by dmnfarrell almost 8 years ago

pandastable - v0.8.3

Changes

  • Cell color by mask added
  • Set color by value added
  • Can color filtered rows
  • Fix to save when filtered
  • Can now set per column alignment
  • Snap now works
  • Fix to deleterows
  • Added move/copy column to menu
  • Fixes to index header
  • Options for heatmap
  • Can open excel files from cmd line

- Python
Published by dmnfarrell about 8 years ago

pandastable - v0.8.2

Changes

  • Fixed setup.py error that broke pip install
  • Added column coloring functionality
  • Fixed slow adding of multiple rows
  • Fix to display row numbers properly for large tables

- Python
Published by dmnfarrell over 8 years ago

pandastable - v0.8.1

Changes

  • Added table operations to main menu
  • Added time series resample (table menu)
  • Can now undo last change for most operations
  • Differential expression plugin
  • Element-wise transform menu item
  • Added aggfunc to pivot dialog
  • Filtering tool highlights filtered rows by default
  • Added predefined widget filters to filtering dialog
  • Fixed slow drawing of large tables

- Python
Published by dmnfarrell over 8 years ago

pandastable - v0.8.0

Adds some miscellaneous improvements. Grouped plots now work better, see http://dmnfarrell.github.io/dataexplore/2017/07/05/grouped-plots. A datetime conversion dialog has been added as shown in http://dmnfarrell.github.io/dataexplore/2016/11/20/sea-ice-example.

Changes

  • Added datetime conversion dialog
  • Changes to make more compatible with matplotlib 2.0
  • Can now plot grouped single plots for some plot types (line, bar, scatter)
  • Fixed sharey, sharex for grouped plots
  • Added ability to choose pre-defined mpl styles
  • Fix to memory leak on redraws
  • Changes to right click copy behaviour in table
  • snapcraft.yaml to create snap package
  • Fix for displaying small floats that were rounded to zero
  • Added floating precision to table preferences
  • Clipboard bug fix
  • Improvement to merge dialog
  • Fixes to widget styling issues on linux
  • Added duplicate column removal in clean data

- Python
Published by dmnfarrell over 8 years ago

pandastable - v0.7.2

This minor release adds experimental text annotation support. This allows the addition of arbitrary labels. see http://dmnfarrell.github.io/dataexplore/2016/02/19/annotations. Note that new releases mean .dexpl project files from older versions might not load properly.

Changes

  • Added black and white option for plotting
  • Fix to avoid white lines with some colormaps
  • Can now add text annotations to plots
  • Most plot options are now saved including grid settings
  • -t option for launching a test app
  • fix to scatter colors
  • changed predefined datasets to csv to avoid msgpack issues

- Python
Published by dmnfarrell almost 10 years ago

pandastable - v0.7.1

This minor release provides updates to allow python 2.7 compatibility. An annotation tab has been added to the plot options to allow adding manual textbox or graphical objects manually later.

Changes

  • Updated code for python 2.7 compatibility
  • Plot labels now in separate annotation tab
  • Added color by column value for scatter plots
  • Can now only save as messagepack, other formats are under export
  • Fix to setup file that prevent plugins from being installed

- Python
Published by dmnfarrell about 10 years ago

pandastable - v0.7.0

This release adds several new features. It updates the 3D plotting options so that they are all properly functional. It also adds the ability to create/change columns data using ranges or randomly generated from a distribution. You can now combine different kinds of plots together or from different tables in one plot using the grid layout option.

Changes

  • Added fill data functions for columns
  • Updates to 3D plotting allow working contour, wireframe and surface plots
  • Added contour and imshow plots
  • Can now display plot tools in vertical orientation
  • IPython console plugin
  • Combining multiple different plots in a grid layout is now possible

- Python
Published by dmnfarrell about 10 years ago

pandastable - v0.6.0

This release adds a simple plugin architecture to allow third party scripts to be easily added. A factor plotting plugin has been added using this method. This will be provided by default. The other major change is to allow table selections and properties to be saved with projects. Plots can therefore be re-loaded from the last selections and plot settings. Finally numpy functions can now be used in the function evaluation bar. Columns generated from functions are remembered so that you can keep track of how the data was made, a bit like a spreadsheet formula.

Changes

  • Implemented plugin system with sample seaborn plugin
  • Moved batch file rename tool to plugins
  • Meta data now saved with project files - allows saving plots and selections
  • Can add a table to plot using sub-table contents
  • Integrated table copy and paste into toolbars
  • Changed function evaluation so that math functions work
  • Column-wise functions can be applied
  • Added ability to show error bars in plots
  • Various fixes for table selections
  • Added melt function for converting to long form data

- Python
Published by dmnfarrell about 10 years ago

pandastable - v0.5.0

This release adds a model fitting interface based on the statsmodels library. This library will be an optional dependency. Other additions such as data cleaning are added that may be useful aids for fitting.

Changes

  • Model fitting interface using statsmodels
  • Added ability to create categorical and dummy columns, useful for fitting
  • Clean data options added
  • Dialog to apply certain row-wise functions added to column menu
  • String operations added to column menu
  • Re-did aggregate dialog
  • Correlation matrix calculator
  • Row index header to show index names
  • Display column multiiindexes
  • Cell text now fits properly with any font/size
  • Convenient copy and paste table menu items for DataExplore
  • Added minimal unit tests

- Python
Published by dmnfarrell over 10 years ago

pandastable - v0.4.2

Minor fixes

Changes

  • Added plot save dpi entry
  • Fixed missing data files for setuptools install
  • Updated scatter to allow multiple subplots

- Python
Published by dmnfarrell over 10 years ago

pandastable - v0.4.1

Adds more predefined datasets, file rename utility

Changes

  • More datasets for testing
  • Fix to update groupby comboboxes when table changes
  • Added batch file renaming tool

- Python
Published by dmnfarrell over 10 years ago

pandastable - 0.4.0

Adds working grouped plots, initial multiindex display and basic function evaluation.

Changes

  • Can now display and set row multiindexes
  • Added function evaluation tool
  • Grouped plots now work
  • Can now sort by multiple columns
  • Can set column dtype
  • Show table as formatted text
  • Fixed copy to clipboard
  • Fix to import dialog error
  • improvements to pivot,aggregate dialogs

- Python
Published by dmnfarrell over 10 years ago

pandastable - v0.3.1

Adds various new features for table manipulation and the use of a child table for table join operations and other uses.

Changes

  • Added ability to create sub/child table
  • Merge, concat operations with sub table
  • Removed row/col buttons from toolbar to prevent clutter
  • Added filtering using string queries; pandas query()
  • Rendering and handling of empty tables
  • Added clear table button
  • Can now hide plot viewer in dataexplore app
  • Fix to relative imports

- Python
Published by dmnfarrell over 10 years ago

pandastable - v0.2.0

This is an alpha release. Includes a download of the windows binary version of the DataExplore application that comes with this library in the form of an MSI installer.

Changes

  • Added dataframe index display in row header
  • Ability to reset index
  • Added hexbin, pie and area plots
  • Added iris.data for tests
  • Fixes for subplots layout
  • Improved histogram plots
  • Aggregate, pivot tools added
  • freeze script for windows binary

- Python
Published by dmnfarrell over 10 years ago