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: -30Now 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: "(" unexpectedI 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.
