Skip to content

Instantly share code, notes, and snippets.

@YiLi225

YiLi225/readExternalSQL.py

Last active February 7, 2022 22:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save YiLi225/f9244ea41ae805c2859dfc0c5c052404 to your computer and use it in GitHub Desktop.
Save YiLi225/f9244ea41ae805c2859dfc0c5c052404 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
readExternalSQL.py
## Read in external SQL file
sqlFile = open(r'...\OnlineRetailPull.sql', 'r')
myQuery = sqlFile.read()
OnlineRetailData = pd.read_sql_query(myQuery, engine)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment