Financial Crime Analysis
- Create a new python3 virtual environment using
virtualenv -p python3 <env_name>
- Unzip the folder, cd into ques123.
- In your terminal, run
pip install -r requirements.txt
- Now create a postgres database to load the CSV into sql.
- Add the required credentials in teh
db_cred.py
file. - Now run
python create_table.py
- this creates the schema. - To load the data in the tables, run
python load_data.py
- Now to run any query, run
python query.py
https://github.com/harshitcodes/fin_crime/blob/master/find_fraudsters.ipynb
Otherwise, here are the steps:
- Run jupyter-notebook kernel on your terminal with the same env activated using
jupyter-notebook
- Now, you scroll through the notebook.
- Run each cell by pressing
<shift + enter>
keys on your keyboard.
There are two flow diagrams in the folder question4
fraud_prevention_flow.xml
- this is a flow diagram comprising processes and checks in order to prevent and stop crimes.fraud_detection_modeling.xml
- this is a flow diagram to analyse past transactions and model a technique to detect fraudsters better.