Create a Pandas dataframe with your Redshift data
Project description
This package will help you to create Pandas dataframe with your Redshift data with just 2 lines of Python codes.
How to use
-
Install this package with pip CLI.
$ pip install red2df
-
Make Redshift db cursor with your Redshift information.
from red2df import RedshiftToDf DB_NAME = "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(DB_NAME, USER, PASSWORD, HOST)
-
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 | +----+-----------------------+ """
-
You also can save the result of query in csv. Please give
save_csv=True
option when you runcreate_df()
.- The parameters of
create_df()
:sql
[str] : SQL query you want to runsave_csv
[bool] : Save the result of the given query in csv if True. Default is Falsefile_path
[str] : Path of csv file. Default is './df.csv'.
- The parameters of
Please feel free to email me if there is any problem - hyunie@tumblbug.com
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
red2df-1.0.3.tar.gz
(3.1 kB
view hashes)