Umer Saeed

test

3g-utilization

gz-files

# 2G RF Utilization

- Calculate RF Utilization on following Levels;
 - Network Hourly
 - Network Busy Hour
 - Cell Hourly
 - Cell Busy Hour


2g-rf-utilization

bh-kpis-month-level-bd39d

da-kpis-month-level

bh-kpis-month-level

# Miscellaneous_Operations

- Percentage Number Handling in Pandas
- Conditional Filtering in Python list using regex

miscellaneous-operations

# Calculate Cluster BH using Hourly Data

Enter some description

calculate-cluster-bh

# Genex Cloud ACP UMTs Engineering Parameters

Enter some description

genexcloud-acp-umts-engr-parameters

# Center Region 4G IOI KPI Summary

Enter some description

center-region-4g-ioi-kpi-summary

# Center Region 3G IOI KPI Summary

Enter some description

center-region-3g-ioi-kpi-summary

# Center Region 2G IOI KPI Summary

Enter some description

center-region-2g-ioi-kpi-summary

# Traffic Analysis

Enter some description

traffic-analysis

# BSS Drops and TCH Availability Rate

Enter some description

bss-drops

# Frequency Export For IFOS

RF Export (Frequency Export Files) are the input of this project.

frequency-export

# LAC and TAC Convert Hex to Dec
Enter some description

lac-tac-convrt-hex-to-dec

# 3G Worst Cells

- Unzip, concat , Del Files from the system and Export Multi Sheet using loop.

3g-worst-cell

# 3G IPPool KPIs Summary

-  Get the Max IPPool KPIs Values from the Hourly Data.
-  Calculate the number of intervals breach the Target KPI.
-  Calculate the number of days for Max Values.

3gippool-kpis-summary

# 3G IPPM KPIs Summary

-  Get the Max IPPM KPIs Values from the Hourly Data.
-  Calculate the number of intervals breach the Target KPI.
-  Calculate the number of days for Max Values.

3g-ippm-kpis-summary

# 2G CGID Logs Analysis
- Data Use in this code for NIC tool.
- Path Must be same because NE Name is not available in this data.

2g-cgid-logs-analysis

# ZTE RF Export

Merge ZTE RF Export Files, and also export the files in excel using loop.

zte-3g-export

# External Interference
- Following code performed the following functions
 1. Convert the Multi rows CI to single row and count the Cell Count against each cell group.
 2. Compare the Two External Interference Trackers.
 

external-interference-tracker-final-output

# 2G Cell On Cluster BH

Calculate 2G Cell on Cluster BH.

2g-cell-on-cluster-bh

# 3G RF Export Audit

3G RF Export Audit (GCELL) 

3g-rf-export-audit

# Daily Conformance

Calculate Daily Conformance with conditional formatting.

daily-conformance

# Quarterly Conformance

Calculate Quarterly Conformance with conditional formatting.