clickpanda

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

Release history Release notifications | RSS feed

This version

0.1

Jul 25, 2019

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

clickpanda-0.1.tar.gz (26.2 kB view details)

Uploaded Jul 25, 2019 Source

File details

Details for the file clickpanda-0.1.tar.gz.

File metadata

Download URL: clickpanda-0.1.tar.gz
Upload date: Jul 25, 2019
Size: 26.2 kB
Tags: Source
Uploaded using Trusted Publishing? No
Uploaded via: twine/1.13.0 pkginfo/1.5.0.1 requests/2.22.0 setuptools/40.8.0 requests-toolbelt/0.9.1 tqdm/4.32.2 CPython/3.7.3

File hashes

Hashes for clickpanda-0.1.tar.gz
Algorithm	Hash digest
SHA256	`0fff0bb339d7af9d18e9e08a538095d5312112ed9e07c718cc25682e6889d63b`
MD5	`9b7b5d762465324539639864664ac354`
BLAKE2b-256	`8d234fd0848be020b6ef7ba7873e29df7673692089750bcc116dd69546ef17f9`