Metadata-Version: 1.1
Name: pandas-rs
Version: 0.1.6
Summary: pandas extension for PostgreSQL and AWS RedShift (Not Officail library)
Home-page: https://github.com/SamuraiT/pandas-rs
Author: Tatsuro Yasukawa
Author-email: t.yasukawa01@gmail.com
License: UNKNOWN
Description: [![Circle CI](https://circleci.com/gh/SamuraiT/pandas-rs.svg?style=svg)](https://circleci.com/gh/SamuraiT/pandas-rs)
        
        # pandas-rs
        
        pandas-rs is oirginally designed for RedShift but
        also works for PostgreSQL. Inspired by [pandas-td](https://github.com/treasure-data/pandas-td)
        
        I may should have made the package name as pandas-pg, since It also works for
        PostgreSQL.
        
        # requirement
        To connect PostgreSQL and RedShift, you have to have the PostgreSQL client.
        
        ### Mac
        
        ~~~
        brew update
        brew install postgresql
        ~~~
        
        # installation
        
        ~~~
        pip install pandas-rs
        ~~~
        
        
        # Usage
        
        As I mentioned, above pandas-rs works for PostgreSQL as well.
        First export password via shell(recommended)
        
        ~~~shell
        export REDSHIFT_OR_POSTGRESQL_PASSWORD='password'
        ~~~
        
        ~~~py
        import pandas_rs as rs
        import os # use only if you will access password through environment variables
        
        rs.create_engine(
            dbname='dev',
            user='test',
            password=os.environ['REDSHIFT_OR_POSTGRESQL_PASSWORD'],
            host='foobar.redshift.exmple',
            port='5439'
        )
        
        
        print(rs.read_sql("""select 'hello PostgreSQL or redshift' greeting"""))
        ~~~
        
        result
        
        ~~~py
                 greeting
        0  hello PostgreSQL or redshift
        ~~~
        
Keywords: pandas,PostgreSQL,RedShift,sql
Platform: UNKNOWN
Classifier: Programming Language :: Python
Classifier: Programming Language :: Python :: 3
Classifier: Development Status :: 4 - Beta
Classifier: Environment :: Other Environment
Classifier: Intended Audience :: Developers
Classifier: License :: OSI Approved :: MIT License
Classifier: Topic :: Software Development :: Libraries :: Python Modules
