Note: this is a fork. You probably want to use https://github.com/kszucs/pandahouse
Pandas interface for ClickHouse HTTP API
pip install pandahouseWriting a dataframe to ClickHouse
connection = {"host": "http:https://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)