Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- import mysql.connector as sql
- import db_config as config
- # Functions
- def mysql_con(host, database, user, password):
- return sql.connect(host=host, database=database, user=user, password=password)
- # Credentials
- credentials_dict = {'host': config.host, 'database': 'database_name', 'user': config.user, 'password': config.password}
- # Read
- with open('my_query.sql', 'r') as f:
- df = pd.read_sql(f.read(), con=mysql_con(**credentials_dict))
Add Comment
Please, Sign In to add comment