205 lines
6.4 KiB
Python
205 lines
6.4 KiB
Python
# coding: utf8
|
|
|
|
import time
|
|
import csv
|
|
from datetime import datetime
|
|
import sys
|
|
from pprint import pprint
|
|
|
|
FILE = 'VFGDSP202110_Summarised_data_usage_per_ICCID.CSV'
|
|
FILE2 = 'Standard_Pairing_File___2021-11-15T93331674Z.CSV'
|
|
FILE3 = 'VFGDSP202110_Summarised_SMS_usage_per_IMSI.CSV'
|
|
|
|
#usrmonth = input("Month to be processed: ")
|
|
#usrmonth = int(usrmonth)
|
|
usrmonth = int(5)
|
|
|
|
dictionary = {}
|
|
|
|
|
|
def add_dict(ICCID, IMSI):
|
|
|
|
dict = dictionary.get(ICCID)
|
|
print("Dict: ",dict)
|
|
print("Got IMSI: ", IMSI,"to add to dict: ",ICCID)
|
|
|
|
print("OK")
|
|
dict[ICCID] += IMSI
|
|
|
|
def add_dict2(ICCID, IMSI):
|
|
dict = dictionary.get(ICCID)
|
|
print("Dict: ",dict)
|
|
print("Got IMSI: ", IMSI,"to add to dict: ",ICCID)
|
|
|
|
print("OK")
|
|
dict['IMSI'] = IMSI
|
|
print('updated', dict)
|
|
|
|
def add_dictsms(id, pricesms):
|
|
dict = dictionary.get(id)
|
|
|
|
print("increasing sms dict key for dict: ",dict," for :",pricesms)
|
|
dict["smscount"] += pricesms
|
|
|
|
def add_dictsmsprice(ICCID3, pricesms):
|
|
dict2 = dictionary.get(ICCID2)
|
|
print("section 3, add to sms")
|
|
print(dict2)
|
|
print("increasing sms dict key for dict: ",dict2 , " for :", pricesms)
|
|
dict["x"] == pricesms
|
|
|
|
|
|
# MAIN
|
|
|
|
print("Start")
|
|
with open(FILE, newline='', encoding="utf-8") as csvfile:
|
|
reader = csv.DictReader(csvfile, delimiter=',')
|
|
for row in reader:
|
|
|
|
# print(row)
|
|
#if row['Telefonní číslo'] == '':
|
|
#continue # skip empty MSISDN
|
|
|
|
#if row['Začátek fakturačního období'] == '':
|
|
#continue
|
|
|
|
#my_string = row['Začátek fakturačního období']
|
|
# my_string = '2021-09-06'
|
|
#print("start date: ", my_string)
|
|
|
|
#try:
|
|
#my_date = datetime.strptime(my_string, "%d.%m.%Y")
|
|
#except:
|
|
#print("An exception occurred, current my_string is: ", my_string)
|
|
#sys.exit(1)
|
|
|
|
# print(row['BILLED_PERIOD_START'])
|
|
# print(my_date.month)
|
|
|
|
#if usrmonth != my_date.month:
|
|
#print("skipping bad date")
|
|
#continue # skip bad dates
|
|
|
|
#MSISDN = int(row['Telefonní číslo'])
|
|
print(row['ICCID'])
|
|
ICCID = int(row['ICCID'])
|
|
price = row['Sum Total Kbytes'].replace(',', '.')
|
|
price = price.replace(' ', '')
|
|
print(price)
|
|
price = (2.23*float(price))/1024
|
|
|
|
|
|
# only if not exist create new record in dictionary for ID
|
|
if not ICCID in dictionary:
|
|
print("Creating dictionary: ", ICCID)
|
|
dictionary[ICCID] = {'IMSI': 0,'data': price, 'sms': 0.00000, 'other': 0.00000, 'smscount': 0}
|
|
|
|
|
|
print("Start section 2")
|
|
with open(FILE2, newline='', encoding="utf-8") as csvfile2:
|
|
reader2 = csv.DictReader(csvfile2, delimiter=',')
|
|
for row in reader2:
|
|
print(row['IMSI'])
|
|
IMSI = int(row['IMSI'])
|
|
ICCID2 = ICCID3 = int(row['ICCID'])
|
|
ICCID3 = int(ICCID2)
|
|
|
|
|
|
if ICCID2 in dictionary:
|
|
print("Adding IMSI: ",IMSI ,"to dictionary: ", ICCID2)
|
|
add_dict2(ICCID2, IMSI)
|
|
print("sec2 end")
|
|
|
|
print("Start section 3")
|
|
i = 0
|
|
x = 0
|
|
with open(FILE3, newline='', encoding="utf-8") as csvfile3:
|
|
reader3 = csv.DictReader(csvfile3, delimiter=',')
|
|
for row in reader3:
|
|
|
|
smspay = int(row['Nr. of SMS payload'])
|
|
smsmo = int(row['Nr. of SMS MO'])
|
|
imsi = int(row['IMSI'])
|
|
print("IMSI: ",imsi)
|
|
print("smspay: ",smspay)
|
|
print("smsmo: ", smsmo)
|
|
|
|
price = smspay * smsmo * 1.28
|
|
|
|
for key,value in dictionary.items():
|
|
print(key, value)
|
|
print("iterations: ", x)
|
|
print("succesfuly paired: ", i)
|
|
x += 1
|
|
if type(value) is dict:
|
|
for key, val in value.items():
|
|
|
|
|
|
#print(key,"→", val)
|
|
if val == imsi:
|
|
print("succesfuly paired: ", i)
|
|
i += 1
|
|
print("got it, IMSI: ", imsi," is paired to ICCID:", ICCID2)
|
|
#add_dictsms(ICCID2, pricesms)
|
|
print(dictionary[ICCID2])
|
|
#sys.exit()
|
|
|
|
# just get the dictionary key by matching IMSI
|
|
#dictionary = {'george': 16, 'amber': 19}
|
|
|
|
|
|
|
|
|
|
|
|
#sys.exit()
|
|
|
|
|
|
|
|
|
|
#print("Adding SMSprice: ",price ,"to dictionary: ", x)
|
|
#add_dictsmsprice(x, price)
|
|
|
|
|
|
|
|
# print("Start section 3")
|
|
# with open(FILE3, newline='', encoding="utf-8") as csvfile3:
|
|
# reader3 = csv.DictReader(csvfile3, delimiter=',')
|
|
# for row in reader3:
|
|
# print(row['ICCID'])
|
|
|
|
|
|
|
|
|
|
# try:
|
|
# print(dictionary[436761890319959]) #one with both types
|
|
# except:
|
|
# print("Required unit is not in our set")
|
|
# sys.exit(1)
|
|
|
|
# print(len(dictionary.keys()))
|
|
|
|
# for key, value in dictionary.items():
|
|
# print(key, ' : ', value)
|
|
|
|
|
|
print("Count of units: ", len(dictionary.keys()))
|
|
|
|
with open('export_vfgdsp202110v1.csv', 'w') as f:
|
|
for key in dictionary.keys():
|
|
f.write("%s,%s\n" % (key, dictionary[key]))
|
|
|
|
csv_columns = ['takhleuztoneudelam', 'IMSI','data', 'sms', 'other', 'smscount']
|
|
try:
|
|
with open('export_vfgdsp_202110v1.csv', 'w') as csvfile:
|
|
w = csv.DictWriter(sys.stdout, csv_columns)
|
|
for key, val in sorted(dictionary.items()):
|
|
row = {'takhleuztoneudelam': key}
|
|
row.update(val)
|
|
|
|
writer = csv.DictWriter(csvfile, fieldnames=csv_columns)
|
|
writer.writerow(row)
|
|
|
|
except IOError:
|
|
print(f"I/O error: {IOError}")
|
|
|