Skip to main content

Pandahouse

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

Pandas interface for ClickHouse HTTP API

Install

pip install pandahouse

Usage

Writing a 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)

Metadata

Release files for intelecy-pandahouse 0.4.1

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Built distribution (wheel)

Table of built distributions (wheels) for intelecy-pandahouse 0.4.1
File Interpreter ABI Platform
intelecy_pandahouse-0.4.1-py3-none-any.whl Python 3 none any Details

Release files / intelecy_pandahouse-0.4.1-py3-none-any.whl

Download URL intelecy_pandahouse-0.4.1-py3-none-any.whl
Size 7.0 kB
Tags Python 3
SHA-256 checksum
How to use checksums
5a3a55417cb5b36767989e9c348980f4664b6f04dc38d02e22e4d0a37dda3c9e
BLAKE2b-256 checksum
How to use checksums
957784055e78b2cf474880acb0e36860bf59c2f6d44d7e16a1dd7c86b7f80707
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via poetry/1.1.14 CPython/3.8.10 Linux/5.13.0-52-generic

Security for intelecy-pandahouse 0.4.1

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page