Capturing LTE worst cell using python(Basic idea)

Hi,
I am attaching one basic python model to pull the worst cell based on certain KPIs(you can add as many KPI as you want to play with)

KPIs:(i took 11 KPIs) for example:

1. A_User Downlink Average Throughput(kbit/s)

2. A_Downlink Resource Block Utilizing Rate(%)

3. A_PDSCH_IBLER(%)

4. L.UL.Interference.Avg(dBm)

5. AvgCQI

6. Avg DL MCS

7. 4G Total traffic (GB)

8. A_DL Retransmission Rate(%)

9. A_RANK2 Ratio(%)

10. A_TA(6+ Km)(%)

11. L.Traffic.User.Avg i give them weights based on what i think is more important than the others. Similarly also define worst thresold for each KPI

Script will capture worst cells using weights and generate the score(I also add additional penalty for the cells whose CQI<7 but have TA sample(>60%) from more than 6km ) just to consider those cells like coverage cells(no site in vicinity).

Similar fashion you can also use this script to see how your KPIs are correlated to each other i add correlation heat map in the end of script.

As i said its very basic idea ....Just play with script by yourself add more components, thoughts and see how it works.

Any query let me know

Cheers!!!