Skip to main content

Load pandas DataFrames in Excel

Project description

excellentpandas

License

Very quickly load pandas DataFrames in Excel

Python is awesome and I love it for doing all sorts of data manipulation. But sometimes Microsoft Excel remains the best place to do quick data exploration and filtering. So thanks to the brilliant xlwings, it's easy to integrate the two. This module has some very simple functions to make this as easy as possible.

Screen capture showing Jupyter Notebook code cells being run with Excel workbooks being loaded in the background

Say you have this script:

>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex)

And you want to explore result quickly in Excel.

You can use one of the following functions to immediately launch the DataFrame in a new Excel Workbook on your desktop via a non-blocking call:

show_in_excel(df)

>>> from excellentpandas import show_in_excel
>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex)
>>> show_in_excel(result)
>>>

Use .pipe(via_excel) for a chained version

>>> from excellentpandas import via_excel
>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex).pipe(via_excel)
>>>

Show info as well with .pipe(via_info_excel)

>>> from excellentpandas import via_info_excel
>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex).pipe(via_info_excel)
<class 'pandas.core.frame.DataFrame'>
Int64Index: 16 entries, 2004 to 2019
Data columns (total 6 columns):
...
dtypes: float64(6)
memory usage: 896.0 bytes
>>>

Install

$ pip install -U excellentpandas

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for excellentpandas, version 0.1.1
Filename, size File type Python version Upload date Hashes
Filename, size excellentpandas-0.1.1-py3-none-any.whl (3.4 kB) File type Wheel Python version py3 Upload date Hashes View hashes

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page