A library to provide Table data constructs over SQLite Databases
Project description
dbTable is a innovative library built on the Python SQLite Library that allows you to manipulate views on tables in Databases, select data from them, and modify them in many ways. This library abstracts out all SQL queries with native Python syntax, and has built-in lazy computation as well. Furthermore, this library provides an interface to load tables from SQLite into in-memory table structures like Pandas DataFrames or Numpy Array for further analysis.
Check out the full documentation at DOCUMENTATION
Quickstart Guide:
Installation
Install dbTable through PyPI
pip install dbTable
You can also download source code and prebuilt distributions from the Github repository. For portable cases, just download the dbTable.py file, and place it in your project folder
Load dbTable into your interpreter/project
import dbTable
Make a connection to a database
db = Database('test.db') # Replace with your database or use ":memory:" to load an in-memory database
Select a table:
table1 = db['table1']
Here’s a sampling of modifications and filters you can do with dbTable
table2 = table1.select(['col1','col2']) # Selecting columns from database table3 = table2.where(table2['col1']> 20) # Filters table4 = table3.sort('col2',descending=False) # Sort data grouped_table = table4.group(table4['col1']) table4['col2'] = table4['col1']*10 # Modify columns table4['col3'] = table4['col1']+table4['col2'] table4['col3'] *= 2
Have fun!
Check out the full documentation at DOCUMENTATION
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distributions
Hashes for dbTable-0.0.3-py2.py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 636b2da3728152ea91bbe2df5bf4d15d8b82993bee775d1ee91c4ce1db84ebe2 |
|
MD5 | a9dd21e0cbabb81381bdde91ddca2722 |
|
BLAKE2b-256 | 0d158e4275e39e9dd7052a0f4afa621303edb489b23d941f090ed2babb63451a |