Python Streamlit Water Quality Tool Development

TITLE:
Develop Water Quality Calculator - WQI, IWQI, Irrigation Indices + Gibbs/Piper Diagrams - Python Streamlit

DESCRIPTION:

I need a Python Streamlit web tool to assess drinking and irrigation water quality based on WHO 2022, FAO, and Egypt Law 48/1982.

Tasks:

Input: Excel template with 25 parameters - pH, EC, TDS, TH, Turbidity, Ca, Mg, Na, K, HCO3, CO3, Cl, SO4, NO3, NO2, NH4, PO4, BOD, COD, DO, F, Fe, Mn, Al, Pb
Calculate Drinking WQI (Weighted Arithmetic Method) with WHO standards, classification 0-25 Excellent to >100 Unsuitable
Calculate Irrigation IWQI (Meireles 2010) - weights EC 0.211, Na 0.204, HCO3 0.202, Cl 0.194, SAR 0.189
Calculate 9 irrigation indices: SAR, %Na, RSC, Kelly Ratio (KR), MAR, Permeability Index (PI), Potential Salinity (PS), SSP, CAI - with meq conversions
Health Risk: HQ, HI, CR per USEPA
Generate diagrams for 30 monitoring points: Gibbs (TDS vs Na/(Na+Ca) and Cl/(Cl+HCO3)), Piper (diamond), USSL (SAR vs EC), Wilcox (%Na vs EC) - must show 3 zones: Upstream fresh (blue), Middle mixed (orange), Downstream brackish (red)
Case Study: El-Salam Canal & Bahr El-Baqar Drain, Port Said - 30 points provided
Output: Dashboard with 5 tabs + Export PDF Technical Report + Excel results + Charge Balance Error