How harshabandaru2410/mutual_fund_analysis works
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: raw Raw datasets · processed Processed datasets · recommender.py Recommend funds · live_nav_fetch.py Fetch live NAV
Components 19
Data preparation
- Fetch live NAV
live_nav_fetch.py - Raw datasets
data/raw - Inspect CSVs
data_ingestion.py - Clean NAV history
data_cleaning.py - Clean performance
scheme_performance_cleaning.py - Clean transactions
investor_transactions_cleaning.py - Processed datasets
data/processed
Fund analytics
- Validate AMFI codes
validate_amfi.py - Explore fund master
fund_master_exploration.py - Analytics outputs
data/processed - EDA entry
EDA_Analysis.py - Advanced analytics
Advanced_Analytics.ipynb - Performance analytics
Performance_Analytics.ipynb - Analysis reports
reports
Data storage
- Load SQLite tables
load_to_sqlite.py - Bluestock database
bluestock_mf.db
Data access
- Recommend funds
recommender.py
Other components
- Analyst
- MF API
Connections 17
- MF API → Fetch live NAV: provides NAV
live_nav_fetch.py - Fetch live NAV → Raw datasets: writes CSVs
live_nav_fetch.py - Analyst → Inspect CSVs: runs inspection
- Inspect CSVs → Raw datasets: reads CSVs
data_ingestion.py - Raw datasets → Clean NAV history: supplies NAV
data_cleaning.py - Clean NAV history → Processed datasets: writes cleaned NAV
data_cleaning.py - Raw datasets → Clean performance: supplies performance
scheme_performance_cleaning.py - Clean performance → Processed datasets: writes cleaned data
scheme_performance_cleaning.py - Raw datasets → Clean transactions: supplies transactions
investor_transactions_cleaning.py - Clean transactions → Processed datasets: writes cleaned data
investor_transactions_cleaning.py - Raw datasets → Validate AMFI codes: supplies fund and NAV codes
validate_amfi.py - Raw datasets → Explore fund master: supplies fund master
fund_master_exploration.py - Analyst → Recommend funds: provides risk appetite
recommender.py - Recommend funds → Processed datasets: reads performance and Sharpe data
recommender.py - Recommend funds → Analyst: prints recommendations
recommender.py - Processed datasets → Load SQLite tables: supplies CSV tables
load_to_sqlite.py - Load SQLite tables → Bluestock database: writes tables
load_to_sqlite.py