Pandas interface for Clickhouse HTTP API
Project description
Pandahouse
Note: this is a fork. You probably want to use https://github.com/kszucs/pandahouse
Pandas interface for ClickHouse HTTP API
Install
pip install pandahouse
Usage
Writing a dataframe to ClickHouse
connection = {"host": "http://clickhouse-host:8123",
"database": "test"}
affected_rows = to_clickhouse(df, table="name", connection=connection)
Reading arbitrary ClickHouse query to pandas
df = read_clickhouse("SELECT * FROM {db}.table", index_col="id",
connection=connection)
Project details
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
Close
Hashes for intelecy-pandahouse-0.3.2.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 8ddfeecaebec827e6bb2ac7ab404d8a918de5d75ae560abd6d05f79822fb6f30 |
|
MD5 | 63ca070c97c958343965ff8edf187656 |
|
BLAKE2b-256 | 9ecc83962e8e1b24d2d780007a815898284b0db1ed3b343a1fa07c9f4efd1849 |
Close
Hashes for intelecy_pandahouse-0.3.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 630dc7a8e733b0f61fc63eba6a066fc72bdbd42fb9b8425f807516bb02590c34 |
|
MD5 | 6c20dbae40397818b46f0922bb9ca488 |
|
BLAKE2b-256 | 2d71f58f0df24ef5efb4ffb1d626c8bcda6293fab938e7c415c42c94d42d86af |