Differences

This shows you the differences between two versions of the page.

--- cdrs:index [2024/10/08 10:51] – created antonio.andriychuk
+++ cdrs:index [2024/10/08 12:44] (current) – Fixed Overall antonio.andriychuk
@@ Line 8: / Line 8: @@
 import numpy as np
-######## FOR FURTHER SCOPE ########
-#import smtplib
-#from email.mime.text import MIMEText
-#from email.mime.multipart import MIMEMultipart
-#from email.mime.application import MIMEApplication
-#import os
-###################################
 # Creating the Dates used to rename the files at the end of the process
@@ Line 84: / Line 75: @@
-    # redsun_gtt['Minute/Cost'] = round(redsun_gtt.apply(redsun_gtt_destinations, axis=1), 4)
+    redsun_gtt['Minute/Cost'] = round(redsun_gtt.apply(redsun_gtt_destinations, axis=1), 4)
     # Venistar
@@ Line 126: / Line 117: @@
     # Redsun - Cost
-    # column_cost = 'Charge'
+    column_cost = 'Charge'
-    # sum_cost_redsun_gtt = redsun_gtt[column_cost].sum()
+    sum_cost_redsun_gtt = redsun_gtt[column_cost].sum()
-    # redsun_gtt_cost = round(sum_cost_redsun_gtt, 2)
+    redsun_gtt_cost = round(sum_cost_redsun_gtt, 2)
     # Redsun - Reselling
-    # column_cost = 'Minute/Cost'
+    column_cost = 'Minute/Cost'
-    # sum_resell_redsun_gtt = redsun_gtt[column_cost].sum()
+    sum_resell_redsun_gtt = redsun_gtt[column_cost].sum()
-    # redsun_gtt_resell = round(sum_resell_redsun_gtt, 2)
+    redsun_gtt_resell = round(sum_resell_redsun_gtt, 2)
     # Venistar - Cost
@@ Line 147: / Line 138: @@
     # Creating CDR for customers
     cdr_columns = ['Start Time (UTC)', 'Call Duration', 'Calling Number', 'Called Number', 'Destination', 'Minute/Cost']
-    # redsun_gtt = redsun_gtt[cdr_columns]
+    redsun_gtt = redsun_gtt[cdr_columns]
     venistar_gtt = venistar_gtt[cdr_columns]
     rename_columns = {'Start Time (UTC)': 'Date/Time', 'Call Duration': 'Duration', 'Calling Number': 'From', 'Called Number': 'To', 'Destination': 'Service Plan', 'Minute/Cost': 'Minute/Cost'}
-    # redsun_gtt = redsun_gtt.rename(columns=rename_columns)
+    redsun_gtt = redsun_gtt.rename(columns=rename_columns)
     venistar_gtt = venistar_gtt.rename(columns=rename_columns)
-    # redsun_gtt.to_csv(f"GTT/" + f"RedSun - CH-FR Outbound - {month} - {year}.csv", index=False)
+    redsun_gtt.to_csv(f"GTT/" + f"RedSun - CH-FR Outbound - {month} - {year}.csv", index=False)
     venistar_gtt.to_csv(f"GTT/" + f"Venistar - ITA Outbound - {month} - {year}.csv", index=False)
     print("\n \n**** GTT ****")
-#    print(f"\n \nPrysmian FR: \n Minutes: {minutes_pry_fr} \n Cost: {prysmian_fr_cost} \n \n Prysmian BR: \n Minutes: {minutes_pry_br} \n Cost: {prysmian_br_cost}  \n \n \n Cost per Customers \n \n REDSUN \n Carrier Cost: {redsun_gtt_cost} \n Reselling Cost: {redsun_gtt_resell} \n \n VENISTAR \n Carrier Cost: {venistar_gtt_cost} \n Reselling Cost: {venistar_gtt_resell} \n \n \n \n")
+    print(f"\n \nPrysmian FR: \n Minutes: {minutes_pry_fr} \n Cost: {prysmian_fr_cost} \n \n Prysmian BR: \n Minutes: {minutes_pry_br} \n Cost: {prysmian_br_cost}  \n \n \n Cost per Customers \n \n REDSUN \n Carrier Cost: {redsun_gtt_cost} \n Reselling Cost: {redsun_gtt_resell} \n \n VENISTAR \n Carrier Cost: {venistar_gtt_cost} \n Reselling Cost: {venistar_gtt_resell} \n \n \n \n")
-    print(f"\n \nPrysmian FR: \n Minutes: {minutes_pry_fr} \n Cost: {prysmian_fr_cost} \n \n Prysmian BR: \n          Minutes: {minutes_pry_br} \n Cost: {prysmian_br_cost}  \n \n \n Cost per Customers \n \n REDSUN \n Carrier Cost:      0.00 \n Reselling Cost: 0.00 \n \n VENISTAR \n Carrier Cost: {venistar_gtt_cost} \n       Reselling Cost: {venistar_gtt_resell} \n \n \n \n")
 # If anything else is typed, the instruction will continue without GTT
@@ Line 182: / Line 172: @@
 # OUTBOUND
+# Alidays
 alidays = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0299220044")) | (irideos_cdr['A_Subscriber_No'].str.contains("02872384"))].copy())
+#Beeasy
 beeasy_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("038319401")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100131"))].copy())
 beeasidata_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("03821788888")) | (irideos_cdr['A_Subscriber_No'].str.contains("01431990018")) | (irideos_cdr['A_Subscriber_No'].str.contains("01411930123")) | (irideos_cdr['A_Subscriber_No'].str.contains("01411930124")) | (irideos_cdr['A_Subscriber_No'].str.contains("01411930125"))].copy())
+# Careapt
 careapt = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0221079070")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079073")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079919")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079966")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079997"))].copy())
+# E80
 e80_vox = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("12244703031")) | (voxbone_cdr['From'].str.contains("61283111046")) | (voxbone_cdr['From'].str.contains("5117064228"))].copy())
 e80_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("05221770290"))].copy())
+# Farmacie Italiane
 farmacie = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0620190197"))].copy())
+# Fives
 fives_vox = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("33481683023"))].copy())
 fives_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("03311660533"))].copy())
+# Giuffre'
 giuffre = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0221079904")) | (irideos_cdr['A_Subscriber_No'].str.contains("02896174")) | (irideos_cdr['A_Subscriber_No'].str.contains("0733270561"))].copy())
+# Golilla
 golilla = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0221100013")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100099")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100101")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100102"))].copy())
+# Lario Reti Holding
 lrh = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("03411790060")) | (irideos_cdr['A_Subscriber_No'].str.contains("03411790061"))].copy())
+# Nuovo Consorzio Informatico
 nci = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0221100617")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100661")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100671")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100762")) | (irideos_cdr['A_Subscriber_No'].str.contains("0283905328")) | (irideos_cdr['A_Subscriber_No'].str.contains("0283905334")) | (irideos_cdr['A_Subscriber_No'].str.contains("0283905393")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612155")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612155")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612160")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612191")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612280")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220027")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220036")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220063")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220036")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220066")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220083"))].copy())
+# OCME
 ocme_vox = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("14803517247")) | (voxbone_cdr['From'].str.contains("34911981094")) | (voxbone_cdr['From'].str.contains("441480276794")) | (voxbone_cdr['From'].str.contains("442038159512")) | (voxbone_cdr['From'].str.contains("525511638786")) | (voxbone_cdr['From'].str.contains("551141300919")) | (voxbone_cdr['From'].str.contains("61290994319")) | (voxbone_cdr['From'].str.contains("6624304079")) | (voxbone_cdr['From'].str.contains("27120042215"))].copy())
 ocme_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("05211480017")) | (irideos_cdr['A_Subscriber_No'].str.contains("0694502247"))].copy())
+# Omega3C - Microdata
 omega3c = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0289617521")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079505")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289617566")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079508")) | (irideos_cdr['A_Subscriber_No'].str.contains("0282950165")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079965")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079917")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079160")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079582")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079161")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079580")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079682")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079581")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079582")) | (irideos_cdr['A_Subscriber_No'].str.contains("0294757684")) | (irideos_cdr['A_Subscriber_No'].str.contains("0294750682")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079194")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079682")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079690")) | (irideos_cdr['A_Subscriber_No'].str.contains("0294758919")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612129")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289617520")) | (irideos_cdr['A_Subscriber_No'].str.contains("0282952627")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221070166")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079691")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079903")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079504")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079076")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079071")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079075")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079077")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079074")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079509")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079193")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221079909")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100741")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100768")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100909"))].copy())
+# Prysmian
 prysmian_ib = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("34932201492")) | (voxbone_cdr['From'].str.contains("34932713140")) | (voxbone_cdr['From'].str.contains("34932713140"))].copy())
 prysmian_uk = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("442381680800"))].copy())
+# RedSun
 redsun_vox = (voxbone_cdr.loc[(voxbone_cdr['From'].str.contains("390282954720"))].copy())
 redsun_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0510910255")) | (irideos_cdr['A_Subscriber_No'].str.contains("0521832"))].copy())
+# S2C
 s2c_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0110721021")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232000")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221103032")) | (irideos_cdr['A_Subscriber_No'].str.contains("0510910599")) | (irideos_cdr['A_Subscriber_No'].str.contains("0912570202")) | (irideos_cdr['A_Subscriber_No'].str.contains("0510070136"))].copy())
+# Service Credit
 servicecredit = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0221100381")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100337")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232224")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232089")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232067")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192861")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100319")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612172")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192899")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232213")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100228")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612188")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192836")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232047")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195032")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195067")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232097")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100623")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100338")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192887")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100669")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192884")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232208")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612264")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612230")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232210")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195017")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612196")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232203")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612231")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195069")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620192809")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612255")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100608")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612232")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612193")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232002")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612267")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100316")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100232")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220079")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195623")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612245")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232013")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100903")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612238")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698240810")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698240828")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220056")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195049")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100739")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698240812")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100787")) | (irideos_cdr['A_Subscriber_No'].str.contains("0620195938")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698240811")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232046")) | (irideos_cdr['A_Subscriber_No'].str.contains("0221100789")) | (irideos_cdr['A_Subscriber_No'].str.contains("0698232058")) | (irideos_cdr['A_Subscriber_No'].str.contains("0289612176")) | (irideos_cdr['A_Subscriber_No'].str.contains("0299220204")) ].copy())
+# Venistar
 venistar_iri = (irideos_cdr.loc[(irideos_cdr['A_Subscriber_No'].str.contains("0412530036")) | (irideos_cdr['A_Subscriber_No'].str.contains("0412530038")) | (irideos_cdr['A_Subscriber_No'].str.contains("0412530063"))].copy())
@@ Line 1154: / Line 1177: @@
 print(f"****IRIDEOS****")
 print("\n\n**** TOLL-FREE ****")
-#print(f" \n Cost per Customers \n \n E80 \n Carrier Cost: {e80_green_cost_iri} \n Reselling Cost: {e80_green_resell_iri} \n \n MetanoNord \n Carrier Cost: {metanonord_green_cost} \n Reselling Cost: {metanonord_green_resell} \n \n \n ")
 print(f" \n Cost per Customers \n \n E80 \n Carrier Cost: {e80_green_cost_iri} \n Reselling Cost: {e80_green_resell_iri} \n \n Farmacie \n Carrier Cost: {farmacie_green_cost} \n Reselling Cost: {farmacie_green_resell} \n \n MetanoNord \n Carrier Cost: {metanonord_green_cost} \n Reselling Cost: {metanonord_green_resell} \n \n Oltreta \n Carrier Cost: {oltreta_green_cost} \n Reselling Cost: {oltreta_green_resell} \n \n")
 print(f"\n\n**** OUTBOUND ****")