Pyhton程序 请教提取两列数据,与之比较与另两个个数的大小

 import pandas
c=0
L=[]
file=open('F:\FCD\write\one.txt')
for line in file:
    L.append(line.split(','))
data=DataFrame(L)
a=data[4]
b=data[5]
for i in a:
    for u in b:
        if u<'22.5':
            if i<'114':
                c=c+1
print(c)

指的是**一行中** a<114 并且 b<22.5,这一行同时满足这两个条件,显示这样数据的总数
请问下这个并列选择关系哪里写错了呢?我用and显示是一样的结果,但都是错误的

不知道怎么上传文本,随便截取了点数据下来,凑合着用下...
20110101,49,H ,粤B000H6 ,114.123581,22.576834,81,225,1,1
20110101,119,H ,粤B000H6 ,114.117783,22.576651,80,225,1,1
20110101,127,H ,粤B000H6 ,114.116081,22.576616,85,225,1,1
20110101,149,H ,粤B000H6 ,114.111366,22.576532,71,225,1,1
20110101,249,H ,粤B000H6 ,114.100235,22.570766,93,225,1,1
20110101,257,H ,粤B000H6 ,114.098618,22.569866,88,225,1,1
20110101,319,H ,粤B000H6 ,114.093948,22.568117,81,225,1,1
20110101,449,H ,粤B000H6 ,114.082802,22.560682,50,180,1,1
20110101,49,H ,粤B000H6 ,114.123581,22.576834,81,225,1,1
20110101,119,H ,粤B000H6 ,114.117783,22.576651,80,225,1,1
20110101,127,H ,粤B000H6 ,114.116081,22.576616,85,225,1,1
20110101,149,H ,粤B000H6 ,114.111366,22.576532,71,225,1,1
20110101,249,H ,粤B000H6 ,114.100235,22.570766,93,225,1,1
20110101,257,H ,粤B000H6 ,114.098618,22.569866,88,225,1,1
20110101,319,H ,粤B000H6 ,114.093948,22.568117,81,225,1,1
20110101,449,H ,粤B000H6 ,114.082802,22.560682,50,180,1,1
20110101,520,H ,粤B000H6 ,114.081032,22.558434,41,225,1,1
20110101,550,H ,粤B000H6 ,114.075684,22.558216,84,225,1,1
20110101,620,H ,粤B000H6 ,114.069733,22.558132,62,225,1,1
20110101,650,H ,粤B000H6 ,114.06823,22.558117,2,225,1,1

把a,b当作两个数组就可以了,如下:
...
for i in range(len(a)):
if a[i]<xx and b[i]<xx:
c=c+1
print(c)


one.txt方便发一下吗,我帮你运算你一下

你这样直接发上来,缩进也不知道对不对,不好帮你找问题的哦~

如果你是要求a[i]<114 && b[i]<22.5这样的总数的话,那么代码显然时错误的。比如说a=[100,112,120] ,b=[22,20,10].那么按照你的代码c=3+3+0=6.
实际上c应该是1+1=2.不知到有没有理解错你的意思。

代码没看出问题来,但是按照你粘贴出来的数据, C明显是个0
也可以写为:
for i in range(len(a)):
if float(a[i]) < 114 and float(b[i]) < 22.5:
c = c+1

emmm首先你这个写肯定是不对的,data=DataFrame(L)应该写为data=pandas.DataFrame(L),其次,你不能用两个循环来写,你那个循环是错的,,我也不知道该怎么和你讲清楚OTATO反正他就是错的啦,
然后我改了一下,发现很尴尬,因为你给我的示例数据就没有一条是符合筛选条件的

我手动改了一下数据,是对的
import pandas
c=0
L=[]
data40=[]
data50=[]
file=open('C:\Users\Administrator\Desktop\1.txt')
for line in file:
L.append(line.split(','))
data=pandas.DataFrame(L)
for i in data[4]:
data40.append(i)
for j in data[5]:
data50.append(j)

d = zip(data40, data50)
d = dict(d)
k=0
for a,b in d.items():
if(float(a)<140 and float(b)<22.5):
k+=1


import pandas
c=0
L=[]
data40=[]
data50=[]
file=open('C:\Users\Administrator\Desktop\1.txt')
for line in file:
L.append(line.split(','))
data=pandas.DataFrame(L)
for i in data[4]:
data40.append(i)
for j in data[5]:
data50.append(j)

d = zip(data40, data50)
d = dict(d)
k=0
for a,b in d.items():
if(float(a)<140 and float(b)<22.5):
k+=1