Metadata-Version: 2.0
Name: dbTable
Version: 0.0.3
Summary: A library to provide Table data constructs over SQLite Databases
Home-page: https://github.com/dibyaghosh/dbTable
Author: Dibya Ghosh
Author-email: dibya.ghosh@berkeley.edu
License: MIT
Keywords: datascience data science numpy database sqlite table column
Platform: UNKNOWN
Classifier: Development Status :: 3 - Alpha
Classifier: Intended Audience :: Developers
Classifier: Intended Audience :: Science/Research
Classifier: Topic :: Database :: Front-Ends
Classifier: Topic :: Database
Classifier: Topic :: Scientific/Engineering :: Mathematics
Classifier: Topic :: Scientific/Engineering
Classifier: Topic :: Scientific/Engineering :: Information Analysis
Classifier: License :: OSI Approved :: MIT License
Classifier: Programming Language :: Python :: 3
Classifier: Programming Language :: Python :: 3.2
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
Classifier: Programming Language :: Python :: 3 :: Only
Requires-Dist: numpy
Requires-Dist: tabulate
Provides-Extra: dev
Requires-Dist: datascience; extra == 'dev'
Requires-Dist: pandas; extra == 'dev'

dbTable
^^^^^^^

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

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

2) Load dbTable into your interpreter/project

::

    import dbTable

3) Make a connection to a database

::

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

4) 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`_

.. _DOCUMENTATION: http://dibya.xyz/dbTable/documentation.html

