How chandrika-sudo/pricetruth works
This repository is a product-price intelligence analysis project: it cleans a Flipkart catalog, simulates price history, derives discount-integrity and deal-trust metrics, and presents results through a Streamlit dashboard and analysis scripts. The main workflow runs from raw catalog data through cleaned and scored datasets to interactive exploration. Separate branches provide category/business summaries, score validation, and a sample price-history chart. Some scripts and SQL files were not excerpted, so their internal behavior and connections are not inferred.
Main entry points: catalog_with_trust_score.csv Scored Catalog · generate_price_history.py History and Scoring · price_history_analysis.py History Chart Analysis · business_analysis2.py SQL Analysis Runner
Components 17
Catalog Preparation
- Raw Catalog
data/raw/flipkart_com-ecommerce_sample.csv - Catalog Cleaning
src/clean_data.py - Clean Catalog
data/processed/catalog_clean.csv
Price Integrity
- History and Scoring
src/generate_price_history.py - Simulated History
data/processed/price_history.parquet - Scored Catalog
data/processed/catalog_with_trust_score.csv
Insights and Exploration
- Price Dashboard
src/dashboard.py - History Chart Analysis
src/price_history_analysis.py - Sample History Chart
data/processed/sample_price_history.html
Business Analysis
- Baseline Analysis
src/baseline_analysis.py - Category Summary
src/business_analysis1.py - SQL Analysis Runner
src/business_analysis2.py - Category Analysis Query
sql/category_analysis.sql - Discount Integrity Query
sql/discount_integrity.sql - Business Analysis
src/business_analysis3.py - Trust Score Validation
src/validate_trust_score.py
Other components
- Analyst
Connections 17
- Analyst → Catalog Cleaning: runs preparation
- Catalog Cleaning → Raw Catalog: reads
src/clean_data.py - Catalog Cleaning → Clean Catalog: writes
src/clean_data.py - History and Scoring → Clean Catalog: reads
src/generate_price_history.py - History and Scoring → Simulated History: writes
src/generate_price_history.py - History and Scoring → Scored Catalog: writes
src/generate_price_history.py - Analyst → Price Dashboard: explores
src/dashboard.py - Price Dashboard → Scored Catalog: loads
src/dashboard.py - Price Dashboard → Simulated History: loads
src/dashboard.py - History Chart Analysis → Scored Catalog: loads
src/price_history_analysis.py - History Chart Analysis → Simulated History: loads
src/price_history_analysis.py - History Chart Analysis → Sample History Chart: writes
src/price_history_analysis.py - Category Summary → Scored Catalog: queries
src/business_analysis1.py - SQL Analysis Runner → Category Analysis Query: executes
src/business_analysis2.py - SQL Analysis Runner → Discount Integrity Query: executes
src/business_analysis2.py - SQL Analysis Runner → Scored Catalog: queries
src/business_analysis2.py - Trust Score Validation → Scored Catalog: validates
src/validate_trust_score.py