Metadata-Version: 1.1
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
Description: 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
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
