Read and Write Dataframes and Data to a chipmunkdb
Project description
chipmunkdb :chipmunk: python-client
Modify and save dataframes with timeseries or without to an ultra-fast ipc chipmunk database with olap features. (Powered by duckdb)
Installation
pip install chipmunkdb-python-client
Usage
import sys
sys.path.insert(0,'..')
import pandas as pd
import numpy as np
from chipmunkdb.ChipmunkDb import ChipmunkDb
db = ChipmunkDb("localhost")
#receive all collections
collections = db.collections()
# create a dataframe
df = pd.DataFrame(np.array([[1, 2, 3], [4, 5, 6], [7, 8, 9]]),
columns=['a', 'b', 'c'])
print(df)
## save your pandas
db.save_as_pandas(df, "mydf")
## get infos abotu your dataframe
collection = db.collection_info("mydf")
# read your dataframe again
df2 = db.collection_as_pandas("mydf")
print(df2)
# call any query on your data
d = db.query("SELECT * FROM mydf WHERE a=1 LIMIT 100")
print(d)
Info
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for chipmunkdb_python_client-2.0.13.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5ffb6c88eb7236261d674e0a112f7f628e0e868f0fda4930a1d05a45e89a1996 |
|
MD5 | 428db7f62a3cd3f006bfadc5a4b17e38 |
|
BLAKE2b-256 | db13f487ed1f1e9c5b18a659cb5d73ecbde3f4865fce3ee9c4cd71c1322df908 |
Close
Hashes for chipmunkdb_python_client-2.0.13-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 36de86327bf2d21a5a5087632a4ec0c85c5d187db9dce3da02eeaec5d0169010 |
|
MD5 | f5b0736ede3ed3891386b77b04f15119 |
|
BLAKE2b-256 | 1c8e2643650dde71c2e63280e1d80f4c464b0d38ea86c7da8d80412fc5256d9c |