documentations/lcg_analysis_doc.py

import streamlit as st

st.markdown(
    """
# LCG Capacity Documentation

## 1. Objective
Analyze LCG utilization behavior and detect imbalance/capacity pressure.

## 2. When to use this tool
Use this page for LCG-level dimensioning checks and region-level optimization decisions.

## 3. Input files and accepted formats
- Required: LCG report in `.csv`
- Data recommendation: at least 3 days, daily aggregated, LCG-level export

## 4. Required columns/fields
Input CSV must include columns expected by `load_and_process_lcg_data`.
Outputs include `final_comments` and geographic fields for map plotting.

## 5. Step-by-step usage
1. Open `Capacity Analysis > LCG Capacity Analysis`.
2. Upload LCG CSV report.
3. Set analysis days, threshold days, utilization threshold, and LCG difference threshold.
4. Click `Analyze Data`.
5. Review tables, charts, and map.
6. Download report.

## 6. Outputs generated
- LCG analysis dataframe
- KPI dataframe
- final comment distributions (global and per region)
- map of final comments
- downloadable file: `LCG_Capacity_Report.xlsx`

## 7. Frequent errors and fixes
- Validation warning on days settings.
  - Fix: ensure threshold days <= analysis days and analysis days >= 3.
- Processing error.
  - Fix: verify CSV schema and numeric fields.
- Empty map.
  - Fix: confirm presence of `Longitude`/`Latitude` and non-empty comments.

## 8. Minimal reproducible example
- Input: valid LCG CSV with at least 7 days.
- Action: run default settings.
- Expected result: analysis table, distributions, map, and Excel download.

## 9. Known limitations
- Quality depends on source KPI completeness.
- Thresholds may require tuning by market behavior.
- Map view requires valid coordinates.

## 10. Version and update date
- Documentation version: 1.0
- Last update: 2026-02-23
"""
)