GitHub - dylanpulver/Database-Querying: A Jupyter notebook designed to connect to any database, data munge using pandas and then deliver the data to a slack channel via API

dylanpulver / Database-Querying Public

Notifications You must be signed in to change notification settings
Fork 0
Star 0

A Jupyter notebook designed to connect to any database, data munge using pandas and then deliver the data to a slack channel via API

0 stars 0 forks Branches Tags Activity

Star

Notifications

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 5 Commits
README		README
querying-notebook.ipynb		querying-notebook.ipynb

Repository files navigation

Jupyter Notebook Querying

The notebook in this repository is a template for easily connecting to any database, 
converting any SQL query to a pandas dataframe, munging the resulting data with pandas, 
converting the resulting pandas dataframe to a csv file, and then sending that csv file directly to a slack channel.

The notebook is broken up into steps with headers.
In order to use the notebook, the following must be specified within the notebook:
database credentials, sql query, csv filename, 
slack channel and slack token (create a new slack app here: https://api.slack.com/apps )