I have a file in.txt.
name="XYZ_PP_0" number="0x12" bytesize="4" info="0x0000001A"
name="GK_LMP_2_0" number="0xA5" bytesize="8" info="0x00000000bbae321f"
name="MP_LKO_1_0" number="0x356" bytesize="4" info="0x00000234"
name="PNP_VXU_1_2_0" number="0x48A" bytesize="8" info="0x00000000a18c3ba3"
name="AVU_W_2_3_1" number="0x867" bytesize="1" info="0x0b"
From this file i need to search for number="0x867"
and check if it's info value matches to the expected given info value which is 0x0a. if it matches print matches else doesn't matches.
then next i need to search for number="0x12"
and store it's info value i.e info="0x0000001A"
and then search for number="0x356"
and store it's info value info="0x00000234"
to another variable. this value should be equal to previous info value 0x00000004 (i.e 0x0000001A 0x00000004 = 0x0000001E).
if resulted value matches to info="0x00000234"
then print number="0x12" info value 0x00000012 0x00000004 matches to info value of number="0x356".
else print resulted value not matching
This is my current attempt:
with open("in.txt", "r") as infile:
XYZ = False
MP = False
AVU = False
for line in infile:
if 'number="0x12"' and 'info="0x0000001A"' in line:
XYZ = True
continue
if 'number="0x356"' and 'info="0x00000234"' in line:
MP = True
continue
if 'number="0x867"' and 'info="info="0x0b"' in line:
AVU = True
continue
if (XYZ == True):
print("matches")
else:
print("not matches")
but this code will simply checks if the line is present in file or not. it won't check the conditions mentioned above.
Is there a way i can search for the number in the text file and store it's info value to variable?
CodePudding user response:
You have to escape the double quotes, or you can use single quotes so that you string can have double quotes in it like this:
'number="0x12"'
Also, in your if condition the first part is wrong. Here is the loop:
xyz_list = ['number="0x12"', 'info="0x0000001A"']
mp_list = ['number="0x356"', 'info="0x00000234"']
avu_list = ['number="0x867"', 'info="0x0b"']
for line in infile:
if all(x in line for x in xyz_list):
XYZ = True
continue
if all(x in line for x in mp_list):
MP = True
continue
if all(x in line for x in avu_list):
AVU = True
continue
The all() function will check substrings in the line and returns true if all exist.
CodePudding user response:
Try to convert the .txt file into dataframe and apply the conditions using the pandas datframe
import pandas as pd
df = pd.read_fwf('myfile.txt')
or
df = pd.read_csv('myfile.txt', sep=" ")
or
df = pd.read_csv('myfile.txt', ,delimiter="\t")
or
df = pd.read_csv('myfile.txt', sep=" ", header=None, names=["Pos", "Lang", "Perc"])