{
    "info": {
        "author": "Max Harlow",
        "author_email": "maxharlow@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Development Status :: 5 - Production/Stable",
            "Environment :: Console",
            "Intended Audience :: Developers",
            "Intended Audience :: End Users/Desktop",
            "Intended Audience :: Science/Research",
            "License :: OSI Approved :: Apache Software License",
            "Natural Language :: English",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.6",
            "Topic :: Scientific/Engineering :: Information Analysis",
            "Topic :: Utilities"
        ],
        "description": "CSV Pivot\n=========\n\nPivot tables for CSV files in the terminal.\n\nTested on Python 3.6 and 2.7.\n\n\nInstalling\n----------\n\n    pip install csvpivot\n\n\nUsage\n-----\n\nSay you have a CSV file such as:\n\n    name,country,gender,salary\n    Oliver,UK,M,10000\n    Jack,UK,M,21000\n    Emily,UK,F,32000\n    Harry,UK,M,43000\n    Adam,France,M,54000\n    Paul,France,M,65000\n    Louise,France,F,76000\n    Alice,France,F,87000\n    Emma,Germany,F,98000\n\nWe could then find the average salary in each country:\n\n    $ csvpivot test.csv --rows country --values 'mean(salary)'\n\n    country,mean(salary)\n    France,70500\n    Germany,98000\n    UK,26500\n\nIt would be useful to find out the maximum and minimum values too though:\n\n    $ csvpivot test.csv --rows country --values 'mean(salary)' 'min(salary)' 'max(salary)'\n\n    country,mean(salary),min(salary),max(salary)\n    France,70500,54000,87000\n    Germany,98000,98000,98000\n    UK,26500,10000,43000\n\nAs well as `mean`, `min`, and `max`, CSV Pivot also supports `median`, `sum`, `stddev`, `count`, `countuniq`, `concat`, and `concatuniq`. All require numerical values apart from the last two. If numbers contain commas they are interpreted as thousands separators and removed.\n\nColumns are also supported. So we could break down our data by gender:\n\n    $ csvpivot test.csv --rows country --values 'mean(salary)' --columns gender\n\n    country,mean(salary):F,mean(salary):M\n    France,81500,59500\n    Germany,98000,\n    UK,32000,24666.666666666668\n",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/maxharlow/csvpivot",
        "keywords": "",
        "license": "Apache",
        "maintainer": "",
        "maintainer_email": "",
        "name": "csvpivot",
        "package_url": "https://pypi.org/project/csvpivot/",
        "platform": "",
        "project_url": "https://pypi.org/project/csvpivot/",
        "project_urls": {
            "Homepage": "https://github.com/maxharlow/csvpivot"
        },
        "release_url": "https://pypi.org/project/csvpivot/1.4/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Pivot tables for CSV files in the terminal.",
        "version": "1.4"
    },
    "last_serial": 3990589,
    "releases": {
        "1.0": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "2d318f527e229381aafe3f235a5fc8af",
                    "sha256": "6489b4a2651da1b72f4add1d5c714abe71644909dc539920eb82dd3137d6318b"
                },
                "downloads": -1,
                "filename": "csvpivot-1.0-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "2d318f527e229381aafe3f235a5fc8af",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 4690,
                "upload_time": "2016-03-14T21:35:15",
                "url": "https://files.pythonhosted.org/packages/9f/88/5061a6107de18b47daa47b52b7aa909b9c48b2b2a9ff336884a97fa6137a/csvpivot-1.0-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "db6016c4d9ed7d80b9232fd4c3af11d5",
                    "sha256": "97c8b46410238fa8b78ff501940062e6e59ddb44f90dd88b693e27166f9037dd"
                },
                "downloads": -1,
                "filename": "csvpivot-1.0.tar.gz",
                "has_sig": false,
                "md5_digest": "db6016c4d9ed7d80b9232fd4c3af11d5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3092,
                "upload_time": "2016-03-14T21:35:07",
                "url": "https://files.pythonhosted.org/packages/0b/23/dca6f4f46cc72234df0f97d27111642bc86395bc3d6b5b3977e669795348/csvpivot-1.0.tar.gz"
            }
        ],
        "1.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "68061e5f68473ddd68e97e1f6e2a7d1f",
                    "sha256": "2bffaa53e6838f3719ba5b9dff57c661ce0c714467969c9b1542c90d4f3f6902"
                },
                "downloads": -1,
                "filename": "csvpivot-1.1-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "68061e5f68473ddd68e97e1f6e2a7d1f",
                "packagetype": "bdist_wheel",
                "python_version": "2.7",
                "requires_python": null,
                "size": 5983,
                "upload_time": "2016-04-10T16:40:49",
                "url": "https://files.pythonhosted.org/packages/d4/fa/c21c1a0e22066179f94127eb87c66e147eed0008ebe4f55db0215a649353/csvpivot-1.1-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "b460da30ef9b681318a71b87bc4b60d9",
                    "sha256": "0289fb4ff5d8be9c574eda1f65805271da2ca5465d1a0de5a7231b2ef174dfea"
                },
                "downloads": -1,
                "filename": "csvpivot-1.1.tar.gz",
                "has_sig": false,
                "md5_digest": "b460da30ef9b681318a71b87bc4b60d9",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 3828,
                "upload_time": "2016-04-10T16:40:44",
                "url": "https://files.pythonhosted.org/packages/ad/82/500093a4aef76cd7b638903f9a6d620ff77186f90b5ffdac2d0257760925/csvpivot-1.1.tar.gz"
            }
        ],
        "1.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "7a9690163250cd1db6f174d7560e8ffb",
                    "sha256": "ecb8dee4fa23c63aa3ced5e1cafe3822a2ff5b5b8caa46216cf771da5f9b8481"
                },
                "downloads": -1,
                "filename": "csvpivot-1.2-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "7a9690163250cd1db6f174d7560e8ffb",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 6794,
                "upload_time": "2018-03-31T11:39:26",
                "url": "https://files.pythonhosted.org/packages/89/99/abb2f3d9c48c87977a4a174a3c2de15ce15a7e4ed24cedc790cd6f26efb5/csvpivot-1.2-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "fdf16ce11f02d4a7e4088cf183ef673e",
                    "sha256": "4ecff7dccb320f559159168e35d0cc6b2811d8de01bd8bc6746b33d0e8fee688"
                },
                "downloads": -1,
                "filename": "csvpivot-1.2.tar.gz",
                "has_sig": false,
                "md5_digest": "fdf16ce11f02d4a7e4088cf183ef673e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4471,
                "upload_time": "2018-03-31T11:39:24",
                "url": "https://files.pythonhosted.org/packages/bc/30/e539877a76c85e0e959ec83ebbbffea65a107fc5c9114fb59fa93cb7b975/csvpivot-1.2.tar.gz"
            }
        ],
        "1.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "0d2f134827c7ea7eba1f3feb82d274fd",
                    "sha256": "4d6b279fb9594122f5baf668f282bfccbeb963a9813b4f2781c615150936cc59"
                },
                "downloads": -1,
                "filename": "csvpivot-1.3-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "0d2f134827c7ea7eba1f3feb82d274fd",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 6811,
                "upload_time": "2018-03-31T12:52:35",
                "url": "https://files.pythonhosted.org/packages/c5/65/8033610746f7cc4c396a2a5d1612777ef4cc21ae38469b04def7bd026ec4/csvpivot-1.3-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "f54e5879a49f80255f891d360eb24815",
                    "sha256": "e4908c5f2cd93e8191a2bb178646b470983b7bf704ac8ac48ad88cc46410af56"
                },
                "downloads": -1,
                "filename": "csvpivot-1.3.tar.gz",
                "has_sig": false,
                "md5_digest": "f54e5879a49f80255f891d360eb24815",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4494,
                "upload_time": "2018-03-31T12:52:33",
                "url": "https://files.pythonhosted.org/packages/98/c1/6777447a02b98900dc40168a8eb58025ee7fcaee5da66fb35c17770bee67/csvpivot-1.3.tar.gz"
            }
        ],
        "1.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "1838e8987dddc744e2273ada8c5da81b",
                    "sha256": "928a7ec23027227296bc855c76d7cb2077863585795280caf19d59d3253e58a0"
                },
                "downloads": -1,
                "filename": "csvpivot-1.4-py2.py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "1838e8987dddc744e2273ada8c5da81b",
                "packagetype": "bdist_wheel",
                "python_version": "3.6",
                "requires_python": null,
                "size": 5168,
                "upload_time": "2018-06-22T21:01:11",
                "url": "https://files.pythonhosted.org/packages/d0/62/dffa4c06376b76cb6212a5d6c7bda2631e2b290ab1de715ad21bbb77f443/csvpivot-1.4-py2.py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "d605d03612753c9e21f4d74442ccd041",
                    "sha256": "e3963769e2575345711b98587997d68b758915aec8b9194a073f572571659b5a"
                },
                "downloads": -1,
                "filename": "csvpivot-1.4.tar.gz",
                "has_sig": false,
                "md5_digest": "d605d03612753c9e21f4d74442ccd041",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 4525,
                "upload_time": "2018-06-22T21:01:09",
                "url": "https://files.pythonhosted.org/packages/35/48/ba02f11fcbed83ee93c2dd84571d45beb7086a5b1e39c96aeda0a01eff8c/csvpivot-1.4.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "1838e8987dddc744e2273ada8c5da81b",
                "sha256": "928a7ec23027227296bc855c76d7cb2077863585795280caf19d59d3253e58a0"
            },
            "downloads": -1,
            "filename": "csvpivot-1.4-py2.py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "1838e8987dddc744e2273ada8c5da81b",
            "packagetype": "bdist_wheel",
            "python_version": "3.6",
            "requires_python": null,
            "size": 5168,
            "upload_time": "2018-06-22T21:01:11",
            "url": "https://files.pythonhosted.org/packages/d0/62/dffa4c06376b76cb6212a5d6c7bda2631e2b290ab1de715ad21bbb77f443/csvpivot-1.4-py2.py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "d605d03612753c9e21f4d74442ccd041",
                "sha256": "e3963769e2575345711b98587997d68b758915aec8b9194a073f572571659b5a"
            },
            "downloads": -1,
            "filename": "csvpivot-1.4.tar.gz",
            "has_sig": false,
            "md5_digest": "d605d03612753c9e21f4d74442ccd041",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 4525,
            "upload_time": "2018-06-22T21:01:09",
            "url": "https://files.pythonhosted.org/packages/35/48/ba02f11fcbed83ee93c2dd84571d45beb7086a5b1e39c96aeda0a01eff8c/csvpivot-1.4.tar.gz"
        }
    ]
}