wolderufael/Ethiopian-medical-business-data-warehouse

# Ethiopian Medical Business Data Warehouse This repository contains the data pipeline and transformations for building a data warehouse aimed at analyzing Ethiopian medical businesses. The data collected from public sources, including Telegram channels, is transformed to provide meaningful insights for business analysis, including object detection and business monitoring. ## Table of Contents - Project Overview - Project Structure - Installation - Data Pipeline - YOLO Object Detection - API with FastAPI - Database Schema - Usage - Contributing - License ## Project Overview The **Ethiopian Medical Business Data Warehouse** collects, processes, and analyzes medical data sourced from public channels like Telegram. Object detection using YOLO models is applied to image data, and FastAPI is used to expose the collected data through an API. ## Project Structure ├── .github. │ └── workflow │ └── test.yaml ├── .venv ├── .vscode │ └── settings.json ├── app │ ├── crud.py │ ├── database.py │ ├── main.py │ ├── models.py │ ├── schemas.py ├── medical ├── notebook │ ├── Data_scrapping_and_transformation.ipynb │ ├── Load_yolo_result_to_db.ipynb │ ├── YOLLO object detection.ipynb │ ├──script | ├──data_cleaning_and_transformation.py │ ├──telegram_scrapper.py │ ├── .gitignore ├── README.MD ├── requirements.txt ### Key Features: - Data scraping from Telegram channels - Data transformation and analysis - Object detection using YOLOv5 - FastAPI for exposing data and analysis results ## Installation 1. **Clone the repository**: ```bash git clone github.com cd Ethiopian-medical-business-data-warehouse 2. **Set up Python environment**: Create a virtual environment and activate it: ```bash python -m venv .venv source .venv/bin/activate # For Linux/macOS .venv\Scripts\activate # For Windows 2. **Install the required packages**: Install the dependencies from the `requirements.txt` file: …