Description:

pandasrs 0.1.6

[](https://circleci.com/gh/SamuraiT/pandas-rs)# pandas-rspandas-rs is oirginally designed for RedShift butalso 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 forPostgreSQL.# requirementTo connect PostgreSQL and RedShift, you have to have the PostgreSQL client.### Mac~~~brew updatebrew install postgresql~~~# installation~~~pip install pandas-rs~~~# UsageAs I mentioned, above pandas-rs works for PostgreSQL as well.First export password via shell(recommended)~~~shellexport REDSHIFT_OR_POSTGRESQL_PASSWORD='password'~~~~~~pyimport pandas_rs as rsimport os # use only if you will access password through environment variablesrs.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 greeting0 hello PostgreSQL or redshift~~~

License

For personal and professional use. You cannot resell or redistribute these repositories in their original state.

Share

• Share on Facebook
• Share on Twitter