PrettyPandas

PrettyPandas is an extension to the Pandas DataFrame class that helps you create report qualitiy tables with a simple API.

(
    df
    .pipe(PrettyPandas)
    .as_currency('GBP', subset='A')
    .as_percent(subset='B')
    .total()
    .average()
)
_images/API@2x.png

Features

  • Add summary rows and columns.
  • Number formatting for currency, scientific units, and percentages.
  • Chaining commands.
  • Works seamlessly with Pandas Style API.

Note

Version 0.0.4 removes the apply_pretty_globals function and other custom CSS properties because Pandas and Jupyter now defaults to providing great looking html tables. If you still want custom CSS you can use the Pandas Style API.

Installation

You can install PrettyPandas using pip with support for Python 2.7, 3.3, 3.4, and 3.5:

pip install prettypandas

You can also install from source:

git clone git@github.com:HHammond/PrettyPandas.git
cd PrettyPandas
python setup.py install

Contributing

The project is available on GitHub and anyone is welcome to contribute. You can use the issue tracker to report issues, bugs, or suggest improvements.

Indices and tables