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.

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

excellentpandas-0.1.1-py3-none-any.whl (3.4 kB view hashes)

Uploaded Python 3

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page