red2df 1.1.0

Create a Pandas dataframe with your Redshift data

This package will help you to create Pandas dataframe with your Redshift data with just 2 lines of Python codes.

How to use

1. Install this package with pip CLI.

   $ pip install red2df
   

2. Make Redshift db cursor with your Redshift information.

   from red2df import RedshiftToDf
   
   DATABASE = "your DB name"
   USER = "your user name"
   PASSWORD = "your password"
   HOST = "your Redshift endpoint url"
   #PORT = your port number in integer. Default is 5439
   
   #create an instance
   cur = RedshiftToDf(DATABASE, USER, PASSWORD, HOST)
   

3. Run SQL queries and print dataframe.

   df = cur.create_df("your query")
   print(df)
   
   """
   example of result:
   +----+-----------------------+
   |    | user_data__platform   |
   |----+-----------------------|
   |  0 | ANDROID_APP           |
   |  1 | ANDROID_APP           |
   +----+-----------------------+
   """
   

4. You also can save the result of query in csv. Please give save_csv=True option when you call create_df().

   • The parameters of create_df():
     • sql[str] : SQL query you want to run
     • save_csv[bool] : Save the result of the given query in csv if True. Default is False
     • file_path[str] : Path of csv file. Default is './df.csv'.

5. If you want to close your connection, please call close_connection()

   cur.close_connection()
   

Please feel free to email me if there is any problem - [e-mail]