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.

Source Distribution

pandas-rs-0.1.6.tar.gz (2.8 kB view hashes)

Uploaded source

Supported by

AWS AWS Cloud computing Datadog Datadog Monitoring Facebook / Instagram Facebook / Instagram PSF Sponsor Fastly Fastly CDN Google Google Object Storage and Download Analytics Huawei Huawei PSF Sponsor Microsoft Microsoft PSF Sponsor NVIDIA NVIDIA PSF Sponsor Pingdom Pingdom Monitoring Salesforce Salesforce PSF Sponsor Sentry Sentry Error logging StatusPage StatusPage Status page