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.2.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 0fe91c7a29e2ac732899790a907c86d26d94781758bde4eef766bef321c6869e |
|
MD5 | 0605345fe74d3f674457f433c03ff038 |
|
BLAKE2b-256 | f5ceb2fb15ebbde3b6d8fe7006c5d7fb66bf61659b8c25973ac7a9b0775a44bc |
Close
Hashes for intelecy_pandahouse-0.2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 01eb297a2f1e2cc69f4e556180093e7b799b8f0c1aee20253da149ec4dd9ea4b |
|
MD5 | 4abcda36bed899a8318148cc0037ccd4 |
|
BLAKE2b-256 | 33a9c97bfaaa9144fa0ea2211db6cc58ad9baae32d61010cba8c99985f37ffba |