lhiwi/10-academy-week1

“Customer experience analytics for fintech apps: scraping, sentiment analysis, and visualization of Google Play reviews for Ethiopian banks” # Fintech Customer Experience Analytics ## Prerequisites * **Python** 3.10 or higher * **Git** (version control) * **Oracle XE** (or PostgreSQL fallback for database storage) * **VS Code** (with PowerShell or Terminal) --- ## Installation & Setup 1. **Clone the repository**: ```bash git clone github.com cd fintech-customer-experience ``` 2. **Create a virtual environment**: ```bash python -m venv venv # Windows (PowerShell) .\venv\Scripts\Activate.ps1 # Mac/Linux source venv/bin/activate ``` 3. **Install dependencies**: ```bash pip install -r requirements.txt ``` --- ## Project Structure ``` fintech-customer-experience/ ├── src/ # Python modules (scraper, analysis, database loader) ├── scripts/ # Standalone executable scripts ├── notebooks/ # Jupyter notebooks for exploration and preprocessing ├── tests/ # pytest unit tests ├── .github/ │ └── workflows/ # CI/CD (GitHub Actions workflows) ├── .gitignore # Git ignore file ├── requirements.txt # Project dependencies ├── README.md # Project overview (this file) ``` --- ## Branching Strategy We follow a **task-based branching** workflow: * `task-1`: Data Collection & Preprocessing * `task-2`: Sentiment and Thematic Analysis * `task-3`: Database Design and Loading * `task-4`: Insights Visualization and Reporting To create and switch to a task branch: ```bash git checkout -b task-1 ``` Merge completed work into `main` via **Pull Requests**. --- ## Task 1: Data Collection & Preprocessing * Scraped customer reviews from Google Play Store for: * Commercial Bank of Ethiopia (CBE) * Bank of Abyssinia (BOA) * Dashen Bank * Preprocessing steps: * Removed duplicate and incomplete entries * Standardized date formats * **Output**: * `data/bank_reviews_clean.csv` — Cleaned dataset --- ## Task 2: Sentiment and Thematic Analysis * Used `distilbert-base-uncased-finetuned-sst-2-english` fo …