African Economic and Bank Survey
# Survey Data Analysis
## Features
- **Data Cleaning:** Remove duplicates, standardize columns, combine multiple bank-related questions.
- **Analysis:** Pivot tables by **country** and **gender**, Chi-square tests, 95% confidence intervals.
- **Dashboard:** One-page summary of insights.
## Files
- `raw_survey_data.csv` – Original survey dataset.
- `cleaned_data.xlsx` – English-only, cleaned, combined dataset.
- `analysis_summary.xlsx` – Pivot tables, statistical results, charts.
- `scripts/` – Python scripts for data processing and analysis.
- **One-Pager :** View Canva One-Pager
- **Colab Notebook:** Open in Google Colab
## Usage
1. Open the **Colab notebook** to run the analysis or modify for new survey data.
2. View the **Canva one-pager** for a quick visual summary.
3. Explore **Excel files** for detailed pivot tables and statistics.
## Recommendations
- Automate cleaning and analysis with Python scripts for future surveys.
- Apply insights to tailor marketing, service, and interface strategies based on **gender** and **country** differences.