File size: 1,607 Bytes
027f03b |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
# 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
|