This is a fraud detection case project in financial transactions for Conectio firm. The objective is to identify suspicious patterns from purchase data by applying data cleansing, pre-processing and exploratory data analysis techniques.
The dataset was provided via a MySQL database connection. The data was first explored directly in MySQL (checking for duplicates, null values, etc.), and then imported into the project in VSCode, where it was exported as CSV for further processing with Python.
- Data preprocessing (cleansing, normalization, and outlier handling).
- Exploratory analysis (EDA) to identify unusual behavior.
- Implementation of rules and metrics to flag potentially fraudulent transactions.
- Export of results in CSV format for further analysis in external tools such as Excel or BI.
• Python: Pandas, mysql.connector. • SQL: MySQL.