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-1.2.5.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | 7e58ec6037539bd2ea7018c393cc3a931856f18d340528f67ffa29b471c90457 |
|
MD5 | 5fca0780c60cf4c56311e4499aa6288d |
|
BLAKE2b-256 | f9fcd38cd8c90d37590982636004a9ef19d1e4d38aa2bee58a77445b8ea5161f |
Close
Hashes for chipmunkdb_python_client-1.2.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 5f74049a9e4cb95c767cf70bd9e82ff28c56fa4b5528fd7b8e41f7f5d22cf05f |
|
MD5 | ffa71b66d0ee1596cf6792e5727676bd |
|
BLAKE2b-256 | 34bc83300213bbbe4943b31d4ba09a49853fa39a2930728c29aded2a19ab1829 |