BPSI

David Belchior MSc Thesis at Instituto Superior Técnico

(supervised by Rui Henriques)

About this project

This project aims to make an extensive profiling of the prescription (including contentious occasions) and usage of psychiatric drugs in Portugal since 2016.

Current stage

As of 17th September 2023:

• Only the general profiling metrics are available, ranging between 2016 and 2019.
  • The data between 2020 and 2022 will be ready to examine very soon!
• The contentious prescription exploration is currently ongoing.

Requirements

• Python 3+
• Python is Python 3 (alias for python3 command)
• Python-Venv (to create the virtual environment)
• Pip 3+ (to install packages for Python)
• PostgreSQL 14+ (DBMS)
• The dependencies in the requirements.txt file (installable via the quick_start.sh script)

Environment setup instructions

• Make sure the aforementioned packages are installed

  • Example for Debian-based Linux distributions:

    sudo apt install python3 python-is-python3 python3.10-venv pip postgresql

• Run the quick_start.sh script:

  ./quick_start.sh

  • The script will create the virtual environment and the system's dependencies, along with the database with all data and migrations.
  • To comply with data privacy regulations, only a bogus data sample will be available (coming soon!) for demonstration purposes.

Run the backend

cd bpsiapp
python manage.py runserver

Generate visualisation graphs

• Prescription metrics

  cd graphs
  python prescriptions.py
  

  • Available metrics
    • By year, age group, gender and drug name/class only
      • Number of patients
    • By year, drug name, drug class, district, municipality (only when combined with district), NUTS III, NUTS II, NUTS I, age group and gender
      • Prescribed/Dispensed boxes
      • Prescribed/Dispensed DDDs
      • MSRP/Government copayment
      • Prescription count
  • CLI coming soon!

• More metrics coming soon!