python - 如何通过文件处理从给定的数据框列中获取唯一对？

Question

来自数据帧的示例数据:

对

(8, 8), (8, 8), (8, 8), (8, 8), (8, 8)
(6, 7), (7, 7), (7, 7), (7, 6), (6, 7)
(2, 12), (12, 3), (3, 4), (4, 12), (12, 12)

    ```
    
        new_col = []
            for e in content.Pairs:
            new_col.append(list(dict.fromkeys(e)))
            content['Unique'] = new_col
    
    ```

预期输出是对列中的唯一对，如下所示:

(8, 8),(6, 7),(7, 6),(7, 7),(2, 12) so on

我在尝试上面的代码时得到的是这个结果:

独特

['8', '']
['6', '7', '']
['2', '12', '3', '4', '']

如果我使用手动数据，那么数据有什么问题，那么它可以工作，为什么不在数据框中呢

Answer 1

您可以使用set方法:

data = (((8, 8), (8, 8), (8, 8), (8, 8), (8, 8)),
  ((6, 7), (7, 7), (7, 7), (7, 6), (6, 7)),
  ((2, 12), (12, 3), (3, 4), (4, 12), (12, 12)))

uniques = []

for col in data:
  for unique in list(set(col)):
    uniques.append(unique)

for x in uniques:
  print(x)

或:

data = (((8, 8), (8, 8), (8, 8), (8, 8), (8, 8)),
  ((6, 7), (7, 7), (7, 7), (7, 6), (6, 7)),
  ((2, 12), (12, 3), (3, 4), (4, 12), (12, 12)))

uniques = []

for col in data:
  uniques += [unique for unique in list(set(col))]

for x in uniques:
  print(x)