{
    "info": {
        "author": "KOBAYASHI Ittoku",
        "author_email": "nono381d815@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "License :: OSI Approved :: MIT License",
            "Operating System :: OS Independent",
            "Programming Language :: Python :: 3"
        ],
        "description": "## csvkey\nFor a very limited situation such that you don't need performance and \nwant to use CSV as database.\n\n## Example\n```python\nfrom csvkey import Connection\nimport pandas as pd\nimport numpy as np\n\n\n# prepare DataFrame\ndata = pd.DataFrame()\ndata['A'] = pd.Series([1,2,3], dtype='int')\ndata['B'] = pd.Series([4,5,6], dtype='float32')\ndata['C'] = pd.Series([7,8,9], dtype='float64')\n\n\n# register database\nconn = Connection()\nconn.initialize(data, r'C:\\TEST\\database.csv',\n                primary=['A', 'B'],\n                unique=['C'],\n                notnull=['C'])\n# database.csv and the configuration file (default: csv.conf) are generated in C:\\TEST\\\n# set 'A' and 'B' columns as a primary key\n# values in 'C' column must be unique and not NaN\n\n\n# connect to database.csv\nconn.connect(r'C:\\TEST\\database.csv')\nconn.df.dtypes # dtypes are preserved\n\n\n# change values in conn.df\nconn.df.loc[0, 'C'] = 8\nconn.commit() # raise ValueError because 8 is not unique\nconn.df.loc[0, 'C'] = np.nan \nconn.commit() # raise ValueError because NaN is not allowed in 'C'\nconn.df.loc[0, 'C'] = -1\nconn.commit() # OK\nconn.df.loc[2, ['A', 'B']] = [1, 4]\nconn.commit() # raise ValueError because primary keys are duplicated\n```\n\n## Installation\n```\npip install csvkey\n```\n\n## Requirements\npandas  \npyyaml\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/kittoku/csvkey",
        "keywords": "",
        "license": "",
        "maintainer": "",
        "maintainer_email": "",
        "name": "csvkey",
        "package_url": "https://pypi.org/project/csvkey/",
        "platform": "",
        "project_url": "https://pypi.org/project/csvkey/",
        "project_urls": {
            "Homepage": "https://github.com/kittoku/csvkey"
        },
        "release_url": "https://pypi.org/project/csvkey/0.0.3/",
        "requires_dist": [
            "pandas",
            "pyyaml"
        ],
        "requires_python": "",
        "summary": "use PRIMARY KEY and UNIQUE in CSV",
        "version": "0.0.3"
    },
    "last_serial": 4352878,
    "releases": {
        "0.0.1": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8d5fa432b5f178c6828d54e066a1edc0",
                    "sha256": "85407ca43b6c9dc4e964981eec9bf0bb51a820402517c614c8401ed1a2ce34ba"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.1-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "8d5fa432b5f178c6828d54e066a1edc0",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4090,
                "upload_time": "2018-10-08T16:43:53",
                "url": "https://files.pythonhosted.org/packages/e3/b3/66b06e8f805e4acdd5996455c47988f1297de84d52b789e15ae7f8f224d6/csvkey-0.0.1-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "271972a4b86fd8c5e05b8de8cbf88372",
                    "sha256": "006e0c0e7a41a3e99cbf306b1fbfe6150229f579ac433be25b04a8f184986f70"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.1.tar.gz",
                "has_sig": false,
                "md5_digest": "271972a4b86fd8c5e05b8de8cbf88372",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2858,
                "upload_time": "2018-10-08T16:43:54",
                "url": "https://files.pythonhosted.org/packages/d1/a1/6ca0b826091f315d81d624fca69636b1c73ae98d9a63c3dfb5b18f485f8b/csvkey-0.0.1.tar.gz"
            }
        ],
        "0.0.2": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "c20afe7bf55ca879858d1149769788cb",
                    "sha256": "5d927337fd79c73bc3f35459fcfc5220e12523078fa019072bec92b5828cbd35"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.2-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "c20afe7bf55ca879858d1149769788cb",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4086,
                "upload_time": "2018-10-08T17:02:18",
                "url": "https://files.pythonhosted.org/packages/19/05/3c0c3ab66350c182b02c3f86c4e2fc269fb7526cb50324b36eaeeb88c829/csvkey-0.0.2-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "c0c6b5c1ffc1ede606b650509867f5f1",
                    "sha256": "9cc1d1a51adf14952a2854cf022f4d0f1e9c56b05cebaaaaaece9695fd1b71d5"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.2.tar.gz",
                "has_sig": false,
                "md5_digest": "c0c6b5c1ffc1ede606b650509867f5f1",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2877,
                "upload_time": "2018-10-08T17:02:19",
                "url": "https://files.pythonhosted.org/packages/7e/d0/027ccea0f427e0d530ae799b7f84d5d8b5b4882224ababa2e8255f95ae33/csvkey-0.0.2.tar.gz"
            }
        ],
        "0.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "033f8333d43c8631833403ce2c5b2ee4",
                    "sha256": "6ba6bcbee85cc0b957a747bad69f36b35d1abe7bc1831d5f84833e2dd2bca0ea"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.3-py3-none-any.whl",
                "has_sig": false,
                "md5_digest": "033f8333d43c8631833403ce2c5b2ee4",
                "packagetype": "bdist_wheel",
                "python_version": "py3",
                "requires_python": null,
                "size": 4104,
                "upload_time": "2018-10-08T17:14:33",
                "url": "https://files.pythonhosted.org/packages/82/bb/70dae2dabf053bbc29b3ac065d839fce27ebd63eeb7b325b9397a4a44e3f/csvkey-0.0.3-py3-none-any.whl"
            },
            {
                "comment_text": "",
                "digests": {
                    "md5": "5e1f35b2d44015519cdfceda4e74cdcb",
                    "sha256": "0ae3612b7066066ea541832a4500c48ab2b023d72dfa0a964b478f80303f4eb0"
                },
                "downloads": -1,
                "filename": "csvkey-0.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "5e1f35b2d44015519cdfceda4e74cdcb",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 2921,
                "upload_time": "2018-10-08T17:14:34",
                "url": "https://files.pythonhosted.org/packages/94/03/7fbe2996fc8426c5595eff5709f643331cc74d47a73a1d7274dfc5ac60d7/csvkey-0.0.3.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "033f8333d43c8631833403ce2c5b2ee4",
                "sha256": "6ba6bcbee85cc0b957a747bad69f36b35d1abe7bc1831d5f84833e2dd2bca0ea"
            },
            "downloads": -1,
            "filename": "csvkey-0.0.3-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "033f8333d43c8631833403ce2c5b2ee4",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 4104,
            "upload_time": "2018-10-08T17:14:33",
            "url": "https://files.pythonhosted.org/packages/82/bb/70dae2dabf053bbc29b3ac065d839fce27ebd63eeb7b325b9397a4a44e3f/csvkey-0.0.3-py3-none-any.whl"
        },
        {
            "comment_text": "",
            "digests": {
                "md5": "5e1f35b2d44015519cdfceda4e74cdcb",
                "sha256": "0ae3612b7066066ea541832a4500c48ab2b023d72dfa0a964b478f80303f4eb0"
            },
            "downloads": -1,
            "filename": "csvkey-0.0.3.tar.gz",
            "has_sig": false,
            "md5_digest": "5e1f35b2d44015519cdfceda4e74cdcb",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 2921,
            "upload_time": "2018-10-08T17:14:34",
            "url": "https://files.pythonhosted.org/packages/94/03/7fbe2996fc8426c5595eff5709f643331cc74d47a73a1d7274dfc5ac60d7/csvkey-0.0.3.tar.gz"
        }
    ]
}