{
    "info": {
        "author": "",
        "author_email": "",
        "bugtrack_url": null,
        "classifiers": [],
        "description": "# excellentpandas\n\n[![License](http://img.shields.io/badge/license-MIT-blue.svg)](https://github.com/kinverarity1/excellentpandas/blob/master/LICENSE)\n\nVery quickly load pandas DataFrames in Excel\n\nPython 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](xlwings), it's easy to integrate the two. This module has some very simple functions to make this as easy as possible.\n\n![Screen capture showing Jupyter Notebook code cells being run with Excel workbooks being loaded in the background](demo.gif)\n\nSay you have this script:\n\n```python\n>>> df = read_data()\n>>> result = df.groupby(\"blah\")[vars].agg(something_complex)\n```\n\nAnd you want to explore ``result`` quickly in Excel.\n\nYou 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:\n\n### ``show_in_excel(df)``\n\n```python\n>>> from excellentpandas import show_in_excel\n>>> df = read_data()\n>>> result = df.groupby(\"blah\")[vars].agg(something_complex)\n>>> show_in_excel(result)\n>>>\n```\n\n### Use ``.pipe(via_excel)`` for a chained version\n\n```python\n>>> from excellentpandas import via_excel\n>>> df = read_data()\n>>> result = df.groupby(\"blah\")[vars].agg(something_complex).pipe(via_excel)\n>>>\n```\n\n### Show info as well with ``.pipe(via_info_excel)``\n\n```python\n>>> from excellentpandas import via_info_excel\n>>> df = read_data()\n>>> result = df.groupby(\"blah\")[vars].agg(something_complex).pipe(via_info_excel)\n<class 'pandas.core.frame.DataFrame'>\nInt64Index: 16 entries, 2004 to 2019\nData columns (total 6 columns):\n...\ndtypes: float64(6)\nmemory usage: 896.0 bytes\n>>>\n```\n\n## Install\n\n```\n$ pip install -U excellentpandas\n```\n\n\n",
        "description_content_type": "text/markdown",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/kinverarity1/excellentpandas",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "excellentpandas",
        "package_url": "https://pypi.org/project/excellentpandas/",
        "platform": "",
        "project_url": "https://pypi.org/project/excellentpandas/",
        "project_urls": {
            "Homepage": "https://github.com/kinverarity1/excellentpandas"
        },
        "release_url": "https://pypi.org/project/excellentpandas/0.1.1/",
        "requires_dist": [
            "xlwings",
            "pandas"
        ],
        "requires_python": "",
        "summary": "Load pandas DataFrames in Excel",
        "version": "0.1.1"
    },
    "last_serial": 5766186,
    "releases": {
        "0.1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "883ea98e957563acc44381a5db5af115",
                    "sha256": "7ed98303b063f0a177ec93df53f403fb6ef8428502e2ddf76eb60dd45ba9c0a6"
                },
                "downloads": -1,
                "filename": "excellentpandas-0.1.0-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "883ea98e957563acc44381a5db5af115",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 2384,
                "upload_time": "2019-08-30T03:42:56",
                "url": "https://files.pythonhosted.org/packages/e8/e5/e7447ad71b41fd5509ce0f40769314cc8b5280ea272b71e713f38860a553/excellentpandas-0.1.0-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f38a6c2b5fedd740286160a57e8cad62",
                    "sha256": "cefcf80f03977c8992a56c84b6720cedd73e525ac9b27f26bb254d4210e0c40b"
                },
                "downloads": -1,
                "filename": "excellentpandas-0.1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "f38a6c2b5fedd740286160a57e8cad62",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 1984,
                "upload_time": "2019-08-30T03:42:59",
                "url": "https://files.pythonhosted.org/packages/30/57/e24c021a263ce74bfd1a904591a6137101f5c3fb7bd3653fdb5f8afa5cae/excellentpandas-0.1.0.tar.gz"
            }
        ],
        "0.1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "69ed5974bdfb05300fff87605da6dad0",
                    "sha256": "0231229a2bcbb698c2e97843ab6119dea6e39222c687bb6fe3a959ce3bb1c30e"
                },
                "downloads": -1,
                "filename": "excellentpandas-0.1.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "69ed5974bdfb05300fff87605da6dad0",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 3406,
                "upload_time": "2019-09-01T05:47:01",
                "url": "https://files.pythonhosted.org/packages/e1/93/ad1cd7aca6de7e82a3785b0ca16b62645eb2122ad2b1845930124c47a81f/excellentpandas-0.1.1-py3-none-any.whl"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "69ed5974bdfb05300fff87605da6dad0",
                "sha256": "0231229a2bcbb698c2e97843ab6119dea6e39222c687bb6fe3a959ce3bb1c30e"
            },
            "downloads": -1,
            "filename": "excellentpandas-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "69ed5974bdfb05300fff87605da6dad0",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 3406,
            "upload_time": "2019-09-01T05:47:01",
            "url": "https://files.pythonhosted.org/packages/e1/93/ad1cd7aca6de7e82a3785b0ca16b62645eb2122ad2b1845930124c47a81f/excellentpandas-0.1.1-py3-none-any.whl"
        }
    ]
}