RDS connection with python application

rdsMySQL2df.py

import pymysql
import pandas as pd
from sqlalchemy import create_engine

engine = create_engine('mysql+pymysql://kestin_chang:<password>@<RDS-endpointURL>:3306/<DBname>')

# Pandas read_sql function
df = pd.read_sql_query('SELECT * FROM <TABLE NAME> LIMIT 10',engine)

# Print result
print(df.head())