Pandahouse ==========

Pandas interface for Clickhouse HTTP API

Install

.. code:: bash

pip install pandahouse

Usage

Writing dataframe to clickhouse

.. code:: python

connection = {'host': 'http://clickhouse-host:8123', 'database': 'test'} affectedrows = toclickhouse(df, table='name', connection=connection)

Reading arbitrary clickhouse query to pandas

.. code:: python

df = readclickhouse('SELECT * FROM {db}.table', indexcol='id', connection=connection)