Question

It s difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.

Closed 12 years ago.

我的矩阵如下。

           31348   439352   6077    4619722    60825
31348      1        0.304   0.126    0.12      0.162
439352     0.304    1       0.101    0.095     0.316
6077       0.126    0.101   1        0.473     0.219
4619722    0.12     0.095   0.473    1         0.256
60825      0.162    0.316   0.219    0.256     1

Now i have to write python script to extract pairs which are having >0.2 the result should be as follows

439352, 31348  0.304
60825, 439352  0.316

.....

人人都能告诉我如何这样做。

预收

NI

Answer 1

mylist = []

with open( test.csv ) as f:
    keys = f.readline()
    keys = keys.split()

    for line in f:
        a = line.split()
        mylist.append(a[1:])

for idx1, item in enumerate(mylist):
    for idx2, number in enumerate(item):
        if float(number) > 0.2:
            print "%7s, %7s  --> %7s" %(keys[idx1], keys[idx2], number)

生产:

  31348,   31348  -->       1
  31348,  439352  -->   0.304
 439352,   31348  -->   0.304
 439352,  439352  -->       1
 439352,   60825  -->   0.316
   6077,    6077  -->       1
   6077, 4619722  -->   0.473
   6077,   60825  -->   0.219
4619722,    6077  -->   0.473
4619722, 4619722  -->       1
4619722,   60825  -->   0.256
  60825,  439352  -->   0.316
  60825,    6077  -->   0.219
  60825, 4619722  -->   0.256
  60825,   60825  -->       1

该代码假定矩阵的x和 y指数相同(如你的例子)。否则,你需要编制两个不同的关键清单。

<>说明: 我的测试.csv文件只是一份文本文件,我复印了你的矩阵(实际上不是文件)。如果你有 com子分离的价值观,那么你就应当相应修改分法。

友情链接