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)

Release files for pandahouse 0.2.7

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for pandahouse 0.2.7
File	Size	Uploaded
pandahouse-0.2.7.tar.gz	21.0 kB	Feb 14, 2018	Details

Release files / pandahouse-0.2.7.tar.gz

Download URL	pandahouse-0.2.7.tar.gz
Size	21.0 kB
Tags	Source
SHA-256 checksum How to use checksums	`d1c03c365e95ce0b6cb0ade7763b3f2c9f33a57cc3e1d0a1887f2e973331c08a`
BLAKE2b-256 checksum How to use checksums	`787c1a98a3791690428fb3d0346ad4f214102ab66c8026f3ea2b80beb22a160a`
Upload date	Feb 14, 2018
Uploaded using Trusted Publishing? What is trusted publishing?	No