Pandas interface for Clickhouse HTTP API
Project description
Pandahouse
Pandas interface for Clickhouse HTTP API
Install
pip install pandahouse
Usage
Writing 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
pandahouse-0.2.7.tar.gz
(21.0 kB
view details)
File details
Details for the file pandahouse-0.2.7.tar.gz
.
File metadata
- Download URL: pandahouse-0.2.7.tar.gz
- Upload date:
- Size: 21.0 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
Algorithm | Hash digest | |
---|---|---|
SHA256 | d1c03c365e95ce0b6cb0ade7763b3f2c9f33a57cc3e1d0a1887f2e973331c08a |
|
MD5 | ac21857c8b2a0e0594b0907387fec9b3 |
|
BLAKE2b-256 | 787c1a98a3791690428fb3d0346ad4f214102ab66c8026f3ea2b80beb22a160a |