semvec/pypi-packages huggingface dataset:
intelecy-pandahouse 0.4.1
Pandas interface for Clickhouse HTTP API
License: BSD-3-Clause
Requires Python: >=3.8.0,<4.0.0

Pandahouse
==========

> Note: this is a fork. You probably want to use https://github.com/kszucs/pandahouse

Pandas interface for ClickHouse HTTP API

Install
-------

```bash
pip install pandahouse
```

Usage
-----

Writing a dataframe to ClickHouse

```python
connection = {"host": "http://clickhouse-host:8123",
              "database": "test"}
affected_rows = to_clickhouse(df, table="name", connection=connection)
```

Reading arbitrary ClickHouse query to pandas

```python
df = read_clickhouse("SELECT * FROM {db}.table", index_col="id",
                     connection=connection)
```