pandahouse

Pandas interface for Clickhouse HTTP API


Keywords
clickhouse, dataframe, pandas
License
BSD-3-Clause
Install
pip install pandahouse==0.2.6

Documentation

Build Status Gitential Efficiency Gitential Efficiency Gitential Efficiency

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)