Jul-20-2020, 06:04 AM
Hey all. Im working on my python code where I intend to read a particular column from the text file and then print the duplicate entries in that file. My data is in the following format:
I began my coding by using the uniq command
However, this doesnt give the output as long as the entire entry is similar.
I then moved forward to first read a particular column of the text file and then use this entry on that:
Even if this code starts working, it would output only the repetitive ARFCN or CID value and not the whole entry, where as I would require the entire list to be printed.
Output:ARFCN: 1004, Freq: 931.0M, CID: 36231, LAC: 7713, MCC: 410, MNC: 4, Pwr: -35
ARFCN: 1008, Freq: 931.8M, CID: 47103, LAC: 7713, MCC: 410, MNC: 4, Pwr: -48
ARFCN: 6, Freq: 936.2M, CID: 10096, LAC: 10470, MCC: 410, MNC: 1, Pwr: -28
ARFCN: 10, Freq: 937.0M, CID: 30911, LAC: 10470, MCC: 410, MNC: 1, Pwr: -39
ARFCN: 10, Freq: 937.0M, CID: 30912, LAC: 10470, MCC: 410, MNC: 1, Pwr: -39
ARFCN: 49, Freq: 944.8M, CID: 15535, LAC: 52207, MCC: 410, MNC: 3, Pwr: -28
ARFCN: 50, Freq: 954.8M, CID: 15535, LAC: 52207, MCC: 410, MNC: 3, Pwr: -28
ARFCN: 66, Freq: 948.2M, CID: 10001, LAC: 470, MCC: 410, MNC: 6, Pwr: -39
ARFCN: 100, Freq: 955.0M, CID: 667, LAC: 1007, MCC: 410, MNC: 3, Pwr: -30
Now I intend to print line 4 and 5 because values of ARFCN are 10 in both cases. Similarly, I want to print 6 and 7 because the value of CID is same for both.I began my coding by using the uniq command
uniq -d alpha.txt
However, this doesnt give the output as long as the entire entry is similar.
I then moved forward to first read a particular column of the text file and then use this entry on that:
#! /bin/sh clear echo " */\*/\*/\*/\*/\*/\*/\*/\*/\*/\*/\*/\* " echo " D A T A B A S E C O M P A R I S O N " echo " *\/*\/*\/*\/*\/*\/*\/*\/*\/*\/*\/*\/* " echo UNIQUE BTS TOWERS ARE f=open('alpha.txt', "r") lines=f.readlines() result=[] for x in lines: result.append(x.split(' ')[1])However, running thsi returns me an error:
Error: */\*/\*/\*/\*/\*/\*/\*/\*/\*/\*/\*/\*
D A T A B A S E C O M P A R I S O N
*\/*\/*\/*\/*\/*\/*\/*\/*\/*\/*\/*\/*
UNIQUE BTS TOWERS ARE
./ARFCN.sh: 8: ./ARFCN.sh: Syntax error: "(" unexpected
I am using python 3.7.3 on ubuntu 18.04 LTS.Even if this code starts working, it would output only the repetitive ARFCN or CID value and not the whole entry, where as I would require the entire list to be printed.