This Jupyter Notebook retrieves real-time drug shortage data for GLP-1 drugs using the FDA Drug Shortages API. The program eliminates the need to manually download and clean CSV files by connecting directly to the API.
- Retrieves current drug shortage data from the FDA Drug Shortages API
- Focuses specifically on GLP-1 class medications
- Automatically stores data in a local SQLite database
- Compares new records with existing entries
- Updates only rows where data has changed
This selective update process ensures the database remains current while minimizing redundant processing and unnecessary writes.
Explore the interactive Tableau dashboards here:
GLP-1 Drug Availability
Streamlined Drug Shortage Tracking with Python and SQLite
https://jcsanalytics.com/index.php/articles/streamlined-drug-shortage-tracking-with-python-and-sqlite