python - 查找并显示具有近似接近条目的行

Question

我正在编写代码来查找 csv 文件中的不重复值，而是近似接近的值。我希望能够找到同一行中差异不超过 1.0 的所有值csv 文件如下所示:

Time    Chan1   Chan2
04:07.0 52.31515503 16.49450684
04:07.1 23.55230713 62.48802185
04:08.0 46.06217957 24.94955444
04:08.0 41.72077942 31.32516479
04:08.0 19.80723572 25.73182678

我想找到彼此相差在 1.0 以内的 Chan1 和 Chan 2 的值。这就是我所拥有的一切:

import nump as np
from matplotlib import *
from pylab import *
filename = raw_input("Enter file name: ")+'.csv'
filepath = 'home/home/david/Desktop/'+filename
col1=[row[2] for row in data]
col2=[row[3] for row in data]

但我不知道从这里去哪里，我不知道我是否应该使用“if”状态，或者是否有任何其他方式来获取我需要的信息。我最终希望程序打印 3 件事:

在 Chan1 和 Chan2 中找到非常接近(接近 <=1.0)值的行，Chan1 和 Chan2。

以下是我刚刚所做的编辑:

import numpy as np
from matplotlib import *
from pylab import *


filename = raw_input("Enter file name: ") + '.csv'
filepath = '/home/david/Desktop/' + filename


data = np.genfromtxt(filepath, delimiter=',', dtype=float)




first=[row[0] for row in data]
rownum1=[row[1] for row in data]
rownum2=[row[2] for row in data]

#if (abs(rownum1-rownum2)<=1):
#       print( first, rownum1, rownum2)

count=0
for row in data:
     count++
     if (abs(row[1]-row[2]) <= 1.0):
            print('The values in row 0 are 1 and 2, are within 1.0 of each other.', format(count, row[1], row[2])

Answer 1

我认为我们可以使用标准库函数解决您的问题。

只是友好的说明:

这3行

first=[row[0] for row in data]
rownum1=[row[1] for row in data]
rownum2=[row[2] for row in data]

将执行 3 x 10.000 循环，您最好在每行读取数据时进行拆分。

请按照 @0O0O0O0 请求复制粘贴错误

try:
    text_file = open("list_number.txt", "r") #File contain your 5 line data, with header removed

    try:
        count = 0
        for row in text_file:
            col = row.split() # switch to row.split(',') if you're using coma delimiter
            count+=1
            if abs(float(col[1]) - float(col[2])) <= 10: # Change to 1
                #print('The values in row %s are %s and %s, are within 10.0 of each other.' % (count, col[1], col[2]))
                print('The values in row {0} are {1} and {2}, are within 10.0 of each other.'.format(count, col[1], col[2]))
    finally:        
        text_file.close()

except IOError as e:
    print("Unable to open file : ", e)