[SOLVED] Parsing a table using python

simhumcon · 07-05-2014, 05:39 AM

hi All,

i have this below data from a file :
RxDqLeft RxDqRight RxVLow RxVHigh TxDqLeft TxDqRight TxVLow TxVHigh
--------------------------------------------------------------------------------
N1.C0.D0.R0: -17 15 -23 21 -19 20 -13 14
N1.C0.D0.R1: -17 16 -23 22 -19 19 -15 14
N1.C1.D0.R0: -16 17 -23 23 -12 15 -22 18
N1.C3.D0.R0: -14 14 -23 23 -12 14 -21 18

using python i want to create a script that will check this data whereby, any if any number in line N1.C0.D0.R0 is below then 10, its a failure. i want to the same on all lines. can someone please help me? i have no clue on where to start

schneidz · 07-05-2014, 06:51 AM

what have you tried and where are you stuck ?

simhumcon · 07-05-2014, 06:54 AM

Code:

file_location = "C:\\users\\20609\\Desktop\\lalala.txt"

with open(file_location) as f :
    for line in f :
        if "N" in line :
            polyshape=[]
            var = line.split()
            print var
            var = [int(i) for i in var]
            polyshape.append(var)

this is what i've tried. im trying to read the numbers and make them as a variable so that later i can say : if var < int(10), make it fail

btmiller · 07-05-2014, 10:21 AM

Note this line:

Code:

var = [int(i) for i in var]

However, your target line has a field that is not an integer (the first field namely, or var[0] in your script). So these line will likely raise an exception. You can fix this by using array slicing to refer to only the fields in the array you actually want to process.

schneidz · 07-05-2014, 12:15 PM

this worx for me

Code:

#!/usr/bin/python

with open("simhumcon.txt") as f:
 for line in f :
  print "-----schneidz: line = " + line
  for v in line.split():
   print "-----schneidz: v = " + v
   if "N1.C0.D0.R0:" in v:
    print "-----schneidz: enter if"
    for vx in line[12:].split():
     print "-----schneidz: for loop vx = " + vx
     if int(vx) < 10:
      print "error"

firstfire · 07-06-2014, 04:07 AM

Hi.

You may consider splitting line first on ':' and then splitting second part (to the right of ':') on spaces.

Something like this (no error checking, just dirty quick example)

Code:

line = 'N1.C0.D0.R0: -17 15 -23 21 -19 20 -13 14'
arr = line.split(':')[1].split()
is_all_gt_10 = all(map(lambda x: int(x)>10, arr))  # False

And, yes, list comprehensions are a preferrable way to deal with such things in python, I just personally prefer map etc.