Hi guys.I'm just beginner of python.
I'm just trying to do some analysis on simple input file.
it has 6 columns and i want to consider k,l and m,n if i and j are +
after that checking which value is greater or lower in k,l and m,n
I have included logic header just to explain what I was trying to do
plz take a look at my python script.Plz Suggest me any ideas
Inputfile:
columns k,l,i,m,n,j
30,50,+,100,200,+
210,250,+,100,200,+
150,180,+,100,200,+
80,150,+,100,200,+
150,250,+,100,200,+
100,200,-,100,200,-
200,100,+,200,100,-
100,250,-,50,60,-
logic:
while i and j columns are +,+
if k<m and l<m (30<100 and 50<100)
print all the columns plus "good"
elif k>n and l>n (210>100 and 250>200)
print all the columns with "good"
elif k>m and l<n
print all... with "bad"
elif k>m and l>n
print all.....with "average"
elif k<m and l<n
print all......with "avergae"
outputfile:
columns k,l,i,m,n,j
30,50,+,100,200,+,good
210,250,+,100,200,+,good
150,180,+,100,200,+,bad
80,150,+,100,200,+,average
150,250,+,100,200,+,averge
Python script_raw