# LTE CAPACITY REPORT

Based on gsm and wcdma exemple let's build LTE capacity report

## Required Input

- File : LTE BH report with columns :
  - PERIOD_START_TIME
  - MRBTS/SBTS name
  - LNBTS name
  - LNCEL name
  - DN
  - Cell Avail excl BLU
  - E-UTRAN Avg PRB usage per TTI DL
- Number of last day for the analysis
- Number of days for threshold
- Availability threshold
- PRB usage per TTI DL threshold
- Max difference between PRB usage over cells of the same BTS

### TASK

- Pivot KPI in BH report per KPI (Cell Avail excl BLU, E-UTRAN Avg PRB usage per TTI DL)
- Calculate Average and Max of PRB usage per TTI DL
- Calculate Average and Max of Cell Avail excl BLU
- Count number of Days with Cell Avail excl BLU below Availability threshold
- Count number of Days with PRB usage per TTI DL exceeded PRB usage per TTI DL threshold
- Create separate DF per sector and band based on LNCEL name
  - _1_L800: column_name = Sector_1_L800
  - _2_L800: column_name = Sector_2_L800
  - _3_L800: column_name = Sector_3_L800
  - _1_L1800: column_name = Sector_1_L1800
  - _2_L1800: column_name = Sector_2_L1800
  - _3_L1800: column_name = Sector_3_L1800
  - _1_L2300: column_name = Sector_1_L2300
  - _2_L2300: column_name = Sector_2_L2300
  - _3_L2300: column_name = Sector_3_L2300
  - _1_L2600: column_name = Sector_1_L2600
  - _2_L2600: column_name = Sector_2_L2600
  - _3_L2600: column_name = Sector_3_L2600
  - _1S_L1800: column_name = Sector_1S_L1800
  - _2S_L1800: column_name = Sector_2S_L1800
  - _3S_L1800: column_name = Sector_3S_L1800
- Merge DFs per sector LNBTS name
- Concat dfs per Bands