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.

Filename, size & hash SHA256 hash help File type Python version Upload date
pandas-rs-0.1.6.tar.gz (2.8 kB) Copy SHA256 hash SHA256 Source None

Supported by

Elastic Elastic Search Pingdom Pingdom Monitoring Google Google BigQuery Sentry Sentry Error logging AWS AWS Cloud computing DataDog DataDog Monitoring Fastly Fastly CDN SignalFx SignalFx Supporter DigiCert DigiCert EV certificate StatusPage StatusPage Status page