Skip to main content

pandas extension for PostgreSQL and AWS RedShift (Not Officail library)

Project 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
~~~

Project details


Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Files for pandas-rs, version 0.1.6
Filename, size File type Python version Upload date Hashes
Filename, size pandas-rs-0.1.6.tar.gz (2.8 kB) File type Source Python version None Upload date Hashes View

Supported by

Pingdom Pingdom Monitoring Google Google Object Storage and Download Analytics Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN DigiCert DigiCert EV certificate StatusPage StatusPage Status page