KEEMBAR/fintech-review-analysis

Real-world data engineering and NLP challenge analyzing Ethiopian bank app reviews from Google Play Store. Includes scraping, sentiment analysis, and Oracle DB integration. # Fintech Review Analysis ## 📊 Project Overview This project analyzes user reviews of mobile banking apps from three major Ethiopian banks — **Commercial Bank of Ethiopia (CBE)**, **Bank of Abyssinia (BOA)**, and **Dashen Bank** — to uncover key satisfaction drivers and pain points. It simulates the role of a Data Analyst at Omega Consultancy advising fintech clients. ## 🔍 Objectives - Scrape and clean Google Play Store reviews for each bank (400+ reviews each). - Perform sentiment analysis using NLP techniques (VADER / BERT). - Extract themes such as UI issues, bugs, and feature requests. - Store cleaned data in an Oracle database. - Visualize insights and propose actionable recommendations. ## 🛠️ Dependencies ``` google-play-scraper==1.2.7 langdetect==1.0.9 numpy==2.2.6 pandas==2.3.0 pyspellchecker==0.8.3 python-dateutil==2.9.0.post0 pytz==2025.2 schedule==1.2.2 six==1.17.0 tzdata==2025.2 emoji==2.10.1 ``` ## 📈 Results - Successfully collected and cleaned reviews for all three banks - Maintained minimum of 400 reviews per bank - Removed non-English and Amharic text - Prepared clean dataset for sentiment analysis and theme extraction ## Task 2: Sentiment and Thematic Analysis This task focuses on analyzing user reviews to understand sentiment and identify key themes in the feedback for different banks. ### Implementation Details #### 1. Sentiment Analysis - Uses DistilBERT model (distilbert-base-uncased-finetuned-sst-2-english) for sentiment analysis - Processes each review to determine sentiment (positive/negative) and confidence score - Results are saved in the analyzed data files #### 2. Thematic Analysis - Implements keyword extraction using spaCy - Identifies themes based on predefined categories: - Account Access - Transaction Performance - User Interface - Customer Support - Technical Issues - Generates detailed reports with theme statistics and example reviews ### Project Structure ``` fintech-review-analysis/ ├── data/ │ ├── raw/ …