Load pandas DataFrames in Excel
Project description
excellentpandas
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.
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 do the following. This and all the following examples will immediately launch the DataFrame in a new Excel Workbook on your desktop via a non-blocking call.
>>> from excellentpandas import show_in_excel
>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex).pipe(via_excel)
>>> show_in_excel(result)
>>>
Better:
>>> from excellentpandas import via_excel
>>> df = read_data()
>>> result = df.groupby("blah")[vars].agg(something_complex).pipe(via_excel)
>>>
My favourite also prints df.info()
to the console:
>>> 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
>>>
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Hashes for excellentpandas-0.1.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7ed98303b063f0a177ec93df53f403fb6ef8428502e2ddf76eb60dd45ba9c0a6 |
|
MD5 | 883ea98e957563acc44381a5db5af115 |
|
BLAKE2b-256 | e8e5e7447ad71b41fd5509ce0f40769314cc8b5280ea272b71e713f38860a553 |