Skip to main content

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:

  1. Installation

Make sure you have numpy and tabulate installed

pip install numpy
pip install tabulate

Install dbTable through PyPI (This’ll automatically install numpy and tabulate)

pip install dbTable

You can also install the built distribution in the dist/ folder, or for portable cases, just download the dbTable.py file, and place it in your project folder

  1. Load dbTable into your interpreter/project

import dbTable
  1. Make a connection to a database

db = Database('test.db') # Replace with your database or use ":memory:" to load an in-memory database
  1. Select a table:

table1 = db['table1']
  1. Exporting / Importing

To convert a dbTable to any other form, use:

new_df = db['table1'].to_df() # Returns a Pandas DataFrame Object
new_table = db['table1'].to_table() # Returns a UCB Datascience Table
new_ndarray = db['table1'].to_numpy_array() # Returns a Numpy Array

To save a DataFrame, UCB Table, or Numpy Array, use:

db.store_table(new_df,'newtablename')

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

dbTable-0.0.4.tar.gz (10.9 kB view details)

Uploaded Source

Built Distributions

dbTable-0.0.4-py3-none-any.whl (11.2 kB view details)

Uploaded Python 3

dbTable-0.0.4-py2.py3-none-any.whl (11.2 kB view details)

Uploaded Python 2 Python 3

File details

Details for the file dbTable-0.0.4.tar.gz.

File metadata

  • Download URL: dbTable-0.0.4.tar.gz
  • Upload date:
  • Size: 10.9 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? No

File hashes

Hashes for dbTable-0.0.4.tar.gz
Algorithm Hash digest
SHA256 c6bb2a66639288017eb4ae85d72c706ae6e4e5e71ae310b8b40996db18b4b895
MD5 9f53f709b2ad45c48827bc025f36c118
BLAKE2b-256 a387033c3c92be77d937c2a787486b121198a85144bc3714c4ed676e3e6ca009

See more details on using hashes here.

File details

Details for the file dbTable-0.0.4-py3-none-any.whl.

File metadata

File hashes

Hashes for dbTable-0.0.4-py3-none-any.whl
Algorithm Hash digest
SHA256 a4566b9854d591076c108b88472e57e405c261f4b56cdfe00a0c89adee81118b
MD5 9febb7ea0e78a9ccbc306962ec4395b2
BLAKE2b-256 9d4565dc44f5ea8ee23be6789982361e58301c6081150c1a62c7423355dbca6d

See more details on using hashes here.

File details

Details for the file dbTable-0.0.4-py2.py3-none-any.whl.

File metadata

File hashes

Hashes for dbTable-0.0.4-py2.py3-none-any.whl
Algorithm Hash digest
SHA256 a40d9feb8479e332b7f5bbe649fafbc8f310b68323fdebdc81261c9f8f31aba1
MD5 7edb10681569febb8dc9d7dccec18c06
BLAKE2b-256 a9556c303117b11ec1207f6e9fd3919905c628e50a4f6f0552f8cea94bdb24f3

See more details on using hashes here.

Supported by

AWS AWS Cloud computing and Security Sponsor Datadog Datadog Monitoring Fastly Fastly CDN Google Google Download Analytics Microsoft Microsoft PSF Sponsor Pingdom Pingdom Monitoring Sentry Sentry Error logging StatusPage StatusPage Status page