csvbase-client


Namecsvbase-client JSON
Version 0.1.1 PyPI version JSON
download
home_pagehttps://github.com/calpaterson/csvbase-client
SummaryThe command line client for csvbase
upload_time2024-04-10 06:36:08
maintainerNone
docs_urlNone
authorCal Paterson
requires_pythonNone
licenseNone
keywords csv data processing
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage No coveralls.
            <div align="center">
    <img alt="csvbase logo" src="https://github.com/calpaterson/csvbase/raw/main/csvbase/web/static/logo/128x128.png">
</div>

# csvbase-client

The command line client and pandas integration for [csvbase](https://csvbase.com/).

## Status

Semantic versioning is followed, see the [changelog](https://github.com/calpaterson/csvbase-client/blob/main/CHANGELOG.md).

## Usage

### Get a table

In pandas:

```python
>>> import pandas as pd
>>> pd.read_csv("csvbase://meripaterson/stock-exchanges")
>>> pd.read_csv("csvbase://meripaterson/stock-exchanges")
     csvbase_row_id      Continent                   Country                                     Name   MIC Last changed
0                 1         Africa                   Lesotho                                    HYBSE   NaN   2019-03-25
1                 2           Asia                Kazakhstan    Astana International Financial Centre  AIXK   2018-11-18
2                 3         Africa              South Africa                                    ZAR X  ZARX   2018-11-18
3                 4  South America                 Argentina             Bolsas y Mercados Argentinos   NaN   2018-04-02
4                 5  North America  United States of America                  Delaware Board of Trade   NaN   2018-04-02
..              ...            ...                       ...                                      ...   ...          ...
246             247  North America  United States of America                 Long-Term Stock Exchange  LTSE   2020-09-14
247             248  North America  United States of America  Miami International Securities Exchange  MIHI   2020-09-24
248             249  North America  United States of America                        Members' Exchange   NaN   2020-09-24
249             250         Africa                  Zimbabwe            Victoria Falls Stock Exchange   NaN   2020-11-01
250             251           Asia                     China                   Beijing Stock Exchange   NaN   2021-12-27

[251 rows x 6 columns]
```

From the command line

```bash
csvbase-client table get meripaterson/stock-exchanges
csvbase_row_id,Continent,Country,Name,MIC,Last changed
1,Africa,Lesotho,HYBSE,,2019-03-25
2,Asia,Kazakhstan,Astana International Financial Centre,AIXK,2018-11-18
3,Africa,South Africa,ZAR X,ZARX,2018-11-18
[ full file omitted ]
```

### Set (aka "upsert") a table:

```bash
csvbase-client table set meripaterson/stock-exchanges stock-exchanges.csv
```

Nothing is output upon success and exit code is 0.

## Installing

### Executable

Download these from the github [release page](https://github.com/calpaterson/csvbase-client/releases/).

### Pip + PyPI

```bash
pip install csvbase-client
```

### Docker

```bash
docker pull calpaterson/csvbase-client
```

Then when you run:

```bash
# mount your own xdg-cache directory as a volume inside the container
docker run -v "${XDG_CACHE_HOME:-$HOME/.cache}":/root/.cache calpaterson/csvbase-client
```

            

Raw data

            {
    "_id": null,
    "home_page": "https://github.com/calpaterson/csvbase-client",
    "name": "csvbase-client",
    "maintainer": null,
    "docs_url": null,
    "requires_python": null,
    "maintainer_email": null,
    "keywords": "csv data processing",
    "author": "Cal Paterson",
    "author_email": "cal@calpaterson.com",
    "download_url": "https://files.pythonhosted.org/packages/cb/89/da135b35c2fff39b40acc812bf2897376ce3b91510f43cf0ff6949fedcce/csvbase-client-0.1.1.tar.gz",
    "platform": null,
    "description": "<div align=\"center\">\n    <img alt=\"csvbase logo\" src=\"https://github.com/calpaterson/csvbase/raw/main/csvbase/web/static/logo/128x128.png\">\n</div>\n\n# csvbase-client\n\nThe command line client and pandas integration for [csvbase](https://csvbase.com/).\n\n## Status\n\nSemantic versioning is followed, see the [changelog](https://github.com/calpaterson/csvbase-client/blob/main/CHANGELOG.md).\n\n## Usage\n\n### Get a table\n\nIn pandas:\n\n```python\n>>> import pandas as pd\n>>> pd.read_csv(\"csvbase://meripaterson/stock-exchanges\")\n>>> pd.read_csv(\"csvbase://meripaterson/stock-exchanges\")\n     csvbase_row_id      Continent                   Country                                     Name   MIC Last changed\n0                 1         Africa                   Lesotho                                    HYBSE   NaN   2019-03-25\n1                 2           Asia                Kazakhstan    Astana International Financial Centre  AIXK   2018-11-18\n2                 3         Africa              South Africa                                    ZAR X  ZARX   2018-11-18\n3                 4  South America                 Argentina             Bolsas y Mercados Argentinos   NaN   2018-04-02\n4                 5  North America  United States of America                  Delaware Board of Trade   NaN   2018-04-02\n..              ...            ...                       ...                                      ...   ...          ...\n246             247  North America  United States of America                 Long-Term Stock Exchange  LTSE   2020-09-14\n247             248  North America  United States of America  Miami International Securities Exchange  MIHI   2020-09-24\n248             249  North America  United States of America                        Members' Exchange   NaN   2020-09-24\n249             250         Africa                  Zimbabwe            Victoria Falls Stock Exchange   NaN   2020-11-01\n250             251           Asia                     China                   Beijing Stock Exchange   NaN   2021-12-27\n\n[251 rows x 6 columns]\n```\n\nFrom the command line\n\n```bash\ncsvbase-client table get meripaterson/stock-exchanges\ncsvbase_row_id,Continent,Country,Name,MIC,Last changed\n1,Africa,Lesotho,HYBSE,,2019-03-25\n2,Asia,Kazakhstan,Astana International Financial Centre,AIXK,2018-11-18\n3,Africa,South Africa,ZAR X,ZARX,2018-11-18\n[ full file omitted ]\n```\n\n### Set (aka \"upsert\") a table:\n\n```bash\ncsvbase-client table set meripaterson/stock-exchanges stock-exchanges.csv\n```\n\nNothing is output upon success and exit code is 0.\n\n## Installing\n\n### Executable\n\nDownload these from the github [release page](https://github.com/calpaterson/csvbase-client/releases/).\n\n### Pip + PyPI\n\n```bash\npip install csvbase-client\n```\n\n### Docker\n\n```bash\ndocker pull calpaterson/csvbase-client\n```\n\nThen when you run:\n\n```bash\n# mount your own xdg-cache directory as a volume inside the container\ndocker run -v \"${XDG_CACHE_HOME:-$HOME/.cache}\":/root/.cache calpaterson/csvbase-client\n```\n",
    "bugtrack_url": null,
    "license": null,
    "summary": "The command line client for csvbase",
    "version": "0.1.1",
    "project_urls": {
        "Bug Tracker": "https://github.com/calpaterson/csvbase-client/issues",
        "Changelog": "https://github.com/calpaterson/csvbase-client/blob/main/CHANGELOG.md",
        "Documentation": "https://github.com/calpaterson/csvbase-client/wiki",
        "Homepage": "https://github.com/calpaterson/csvbase-client",
        "Source Code": "https://github.com/calpaterson/csvbase-client"
    },
    "split_keywords": [
        "csv",
        "data",
        "processing"
    ],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "3432665ace40e2f7bf0b38322a192d2470d1cc5e4eff929e10f91d462388171f",
                "md5": "26a748325c47076092ef4c92114b5d76",
                "sha256": "4cabfdf01aa0a48189ce1411c68a364178b8172acb68cc3fc86f3b321f54ca76"
            },
            "downloads": -1,
            "filename": "csvbase_client-0.1.1-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "26a748325c47076092ef4c92114b5d76",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": null,
            "size": 28091,
            "upload_time": "2024-04-10T06:36:06",
            "upload_time_iso_8601": "2024-04-10T06:36:06.678028Z",
            "url": "https://files.pythonhosted.org/packages/34/32/665ace40e2f7bf0b38322a192d2470d1cc5e4eff929e10f91d462388171f/csvbase_client-0.1.1-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "cb89da135b35c2fff39b40acc812bf2897376ce3b91510f43cf0ff6949fedcce",
                "md5": "15449437d08c7d9ce6feb621e2f35f9d",
                "sha256": "c510b08c3a5e2657e26497d349047d3f1c96f89ee30f6e243779ab45e30e6a19"
            },
            "downloads": -1,
            "filename": "csvbase-client-0.1.1.tar.gz",
            "has_sig": false,
            "md5_digest": "15449437d08c7d9ce6feb621e2f35f9d",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 26779,
            "upload_time": "2024-04-10T06:36:08",
            "upload_time_iso_8601": "2024-04-10T06:36:08.557343Z",
            "url": "https://files.pythonhosted.org/packages/cb/89/da135b35c2fff39b40acc812bf2897376ce3b91510f43cf0ff6949fedcce/csvbase-client-0.1.1.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2024-04-10 06:36:08",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "calpaterson",
    "github_project": "csvbase-client",
    "travis_ci": false,
    "coveralls": false,
    "github_actions": true,
    "tox": true,
    "lcname": "csvbase-client"
}
        
Elapsed time: 3.11218s