# harshabandaru2410/mutual_fund_analysis architecture

> Architecture diagram of the GitHub repository harshabandaru2410/mutual_fund_analysis, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-10-06). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/harshabandaru2410/mutual_fund_analysis
- Repository: https://github.com/harshabandaru2410/mutual_fund_analysis

## Overview

This repository is a mutual-fund data preparation and analytics project. Its visible workflow gathers or examines raw fund data, cleans selected datasets into processed CSVs, loads processed data into SQLite, and offers risk-based fund recommendations. The tree also indicates portfolio-performance analytics and reports, but their implementation and wiring are not shown in the excerpts; those links are therefore omitted. The graph reflects only relationships supported by sampled source, with no README available.

Main entry points: [`data/raw`](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/raw) (Raw datasets), [`data/processed`](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/processed) (Processed datasets), [`recommender.py`](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/recommender.py) (Recommend funds), [`live_nav_fetch.py`](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/live_nav_fetch.py) (Fetch live NAV)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_data["Data preparation"]
  node_live_fetch["Fetch live NAV<br/>[live_nav_fetch.py]"]
  node_raw_data[("Raw datasets")]
  node_ingest_inspect["Inspect CSVs<br/>[data_ingestion.py]"]
  node_nav_clean["Clean NAV history<br/>[data_cleaning.py]"]
  node_performance_clean["Clean performance"]
  node_transactions_clean["Clean transactions"]
  node_processed_data[("Processed datasets")]
end

subgraph group_analytics["Fund analytics"]
  node_amfi_validate["Validate AMFI codes<br/>[validate_amfi.py]"]
  node_fund_explore["Explore fund master"]
  node_analytics_outputs["Analytics outputs"]
  node_eda["EDA entry<br/>[EDA_Analysis.py]"]
  node_advanced_analytics["Advanced analytics"]
  node_performance_analytics["Performance analytics"]
  node_reports["Analysis reports"]
end

subgraph group_storage["Data storage"]
  node_sqlite_loader["Load SQLite tables<br/>[load_to_sqlite.py]"]
  node_sqlite_db[("Bluestock database<br/>[bluestock_mf.db]")]
end

subgraph group_access["Data access"]
  node_recommender["Recommend funds<br/>[recommender.py]"]
end

node_analyst(("Analyst"))
node_mfapi{{"MF API"}}

node_mfapi -->|"provides NAV"| node_live_fetch
node_live_fetch -->|"writes CSVs"| node_raw_data
node_analyst -.->|"runs inspection"| node_ingest_inspect
node_ingest_inspect -->|"reads CSVs"| node_raw_data
node_raw_data -->|"supplies NAV"| node_nav_clean
node_nav_clean -->|"writes cleaned NAV"| node_processed_data
node_raw_data -->|"supplies performance"| node_performance_clean
node_performance_clean -->|"writes cleaned data"| node_processed_data
node_raw_data -->|"supplies transactions"| node_transactions_clean
node_transactions_clean -->|"writes cleaned data"| node_processed_data
node_raw_data -->|"supplies fund and NAV codes"| node_amfi_validate
node_raw_data -->|"supplies fund master"| node_fund_explore
node_analyst -->|"provides risk appetite"| node_recommender
node_recommender -->|"reads performance and Sharpe data"| node_processed_data
node_recommender -->|"prints recommendations"| node_analyst
node_processed_data -->|"supplies CSV tables"| node_sqlite_loader
node_sqlite_loader -->|"writes tables"| node_sqlite_db

click node_live_fetch "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/live_nav_fetch.py"
click node_raw_data "https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/raw"
click node_ingest_inspect "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/data_ingestion.py"
click node_nav_clean "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/data_cleaning.py"
click node_performance_clean "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/scheme_performance_cleaning.py"
click node_transactions_clean "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/investor_transactions_cleaning.py"
click node_processed_data "https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/processed"
click node_amfi_validate "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/validate_amfi.py"
click node_fund_explore "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/fund_master_exploration.py"
click node_analytics_outputs "https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/processed"
click node_eda "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/EDA_Analysis.py"
click node_advanced_analytics "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/Advanced_Analytics.ipynb"
click node_performance_analytics "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/Performance_Analytics.ipynb"
click node_reports "https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/reports"
click node_recommender "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/recommender.py"
click node_sqlite_loader "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/load_to_sqlite.py"
click node_sqlite_db "https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/bluestock_mf.db"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_live_fetch,node_raw_data,node_ingest_inspect,node_nav_clean,node_performance_clean,node_transactions_clean,node_processed_data toneBlue
class node_amfi_validate,node_fund_explore,node_analytics_outputs,node_eda,node_advanced_analytics,node_performance_analytics,node_reports toneAmber
class node_sqlite_loader,node_sqlite_db,node_mfapi toneMint
class node_recommender toneRose
class node_analyst toneIndigo
```

## Components

### Data preparation

- [Fetch live NAV](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/live_nav_fetch.py): `live_nav_fetch.py`
- [Raw datasets](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/raw): `data/raw`
- [Inspect CSVs](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/data_ingestion.py): `data_ingestion.py`
- [Clean NAV history](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/data_cleaning.py): `data_cleaning.py`
- [Clean performance](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/scheme_performance_cleaning.py): `scheme_performance_cleaning.py`
- [Clean transactions](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/investor_transactions_cleaning.py): `investor_transactions_cleaning.py`
- [Processed datasets](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/processed): `data/processed`

### Fund analytics

- [Validate AMFI codes](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/validate_amfi.py): `validate_amfi.py`
- [Explore fund master](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/fund_master_exploration.py): `fund_master_exploration.py`
- [Analytics outputs](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/data/processed): `data/processed`
- [EDA entry](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/EDA_Analysis.py): `EDA_Analysis.py`
- [Advanced analytics](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/Advanced_Analytics.ipynb): `Advanced_Analytics.ipynb`
- [Performance analytics](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/Performance_Analytics.ipynb): `Performance_Analytics.ipynb`
- [Analysis reports](https://github.com/harshabandaru2410/mutual_fund_analysis/tree/main/reports): `reports`

### Data storage

- [Load SQLite tables](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/load_to_sqlite.py): `load_to_sqlite.py`
- [Bluestock database](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/bluestock_mf.db): `bluestock_mf.db`

### Data access

- [Recommend funds](https://github.com/harshabandaru2410/mutual_fund_analysis/blob/main/recommender.py): `recommender.py`

### Other components

- **Analyst**
- **MF API**

## Connections

- MF API → Fetch live NAV: provides NAV (evidence: `live_nav_fetch.py`)
- Fetch live NAV → Raw datasets: writes CSVs (evidence: `live_nav_fetch.py`)
- Analyst → Inspect CSVs: runs inspection
- Inspect CSVs → Raw datasets: reads CSVs (evidence: `data_ingestion.py`)
- Raw datasets → Clean NAV history: supplies NAV (evidence: `data_cleaning.py`)
- Clean NAV history → Processed datasets: writes cleaned NAV (evidence: `data_cleaning.py`)
- Raw datasets → Clean performance: supplies performance (evidence: `scheme_performance_cleaning.py`)
- Clean performance → Processed datasets: writes cleaned data (evidence: `scheme_performance_cleaning.py`)
- Raw datasets → Clean transactions: supplies transactions (evidence: `investor_transactions_cleaning.py`)
- Clean transactions → Processed datasets: writes cleaned data (evidence: `investor_transactions_cleaning.py`)
- Raw datasets → Validate AMFI codes: supplies fund and NAV codes (evidence: `validate_amfi.py`)
- Raw datasets → Explore fund master: supplies fund master (evidence: `fund_master_exploration.py`)
- Analyst → Recommend funds: provides risk appetite (evidence: `recommender.py`)
- Recommend funds → Processed datasets: reads performance and Sharpe data (evidence: `recommender.py`)
- Recommend funds → Analyst: prints recommendations (evidence: `recommender.py`)
- Processed datasets → Load SQLite tables: supplies CSV tables (evidence: `load_to_sqlite.py`)
- Load SQLite tables → Bluestock database: writes tables (evidence: `load_to_sqlite.py`)
