All Projects → kszucs → Pandahouse

kszucs / Pandahouse

Licence: mit
Pandas interface for Clickhouse database

Programming Languages

python
139335 projects - #7 most used programming language

Projects that are alternatives of or similar to Pandahouse

Dataframe Go
DataFrames for Go: For statistics, machine-learning, and data manipulation/exploration
Stars: ✭ 487 (+286.51%)
Mutual labels:  dataframe, pandas
Pyjanitor
Clean APIs for data cleaning. Python implementation of R package Janitor
Stars: ✭ 647 (+413.49%)
Mutual labels:  dataframe, pandas
Sequoia
A股自动选股程序,实现了海龟交易法则、缠中说禅牛市买点,以及其他若干种技术形态
Stars: ✭ 564 (+347.62%)
Mutual labels:  dataframe, pandas
Pandasvault
Advanced Pandas Vault — Utilities, Functions and Snippets (by @firmai).
Stars: ✭ 316 (+150.79%)
Mutual labels:  dataframe, pandas
Boltzmannclean
Fill missing values in Pandas DataFrames using Restricted Boltzmann Machines
Stars: ✭ 23 (-81.75%)
Mutual labels:  dataframe, pandas
Pystore
Fast data store for Pandas time-series data
Stars: ✭ 325 (+157.94%)
Mutual labels:  dataframe, pandas
Datasheets
Read data from, write data to, and modify the formatting of Google Sheets
Stars: ✭ 593 (+370.63%)
Mutual labels:  dataframe, pandas
vulkn
Love your Data. Love the Environment. Love VULKИ.
Stars: ✭ 43 (-65.87%)
Mutual labels:  clickhouse, pandas
Foxcross
AsyncIO serving for data science models
Stars: ✭ 18 (-85.71%)
Mutual labels:  dataframe, pandas
Dataframe
C++ DataFrame for statistical, Financial, and ML analysis -- in modern C++ using native types, continuous memory storage, and no pointers are involved
Stars: ✭ 828 (+557.14%)
Mutual labels:  dataframe, pandas
Dominando-Pandas
Este repositório está destinado ao processo de aprendizagem da biblioteca Pandas.
Stars: ✭ 22 (-82.54%)
Mutual labels:  pandas, dataframe
Jardin
A pandas.DataFrame-based ORM.
Stars: ✭ 81 (-35.71%)
Mutual labels:  dataframe, pandas
raccoon
Python DataFrame with fast insert and appends
Stars: ✭ 64 (-49.21%)
Mutual labels:  pandas, dataframe
Pandastable
Table analysis in Tkinter using pandas DataFrames.
Stars: ✭ 376 (+198.41%)
Mutual labels:  dataframe, pandas
tableau-scraping
Tableau scraper python library. R and Python scripts to scrape data from Tableau viz
Stars: ✭ 91 (-27.78%)
Mutual labels:  pandas, dataframe
Pdpipe
Easy pipelines for pandas DataFrames.
Stars: ✭ 590 (+368.25%)
Mutual labels:  dataframe, pandas
onelinerhub
2.5k code solutions with clear explanation @ onelinerhub.com
Stars: ✭ 645 (+411.9%)
Mutual labels:  clickhouse, pandas
cognipy
In-memory Graph Database and Knowledge Graph with Natural Language Interface, compatible with Pandas
Stars: ✭ 31 (-75.4%)
Mutual labels:  pandas, dataframe
Modin
Modin: Speed up your Pandas workflows by changing a single line of code
Stars: ✭ 6,639 (+5169.05%)
Mutual labels:  dataframe, pandas
Pandas Ta
Technical Analysis Indicators - Pandas TA is an easy to use Python 3 Pandas Extension with 130+ Indicators
Stars: ✭ 962 (+663.49%)
Mutual labels:  dataframe, pandas

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'}
affected_rows = to_clickhouse(df, table='name', connection=connection)

Reading arbitrary clickhouse query to pandas

.. code:: python

df = read_clickhouse('SELECT * FROM {db}.table', index_col='id',
                     connection=connection)
Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].