Python csv转置

Question

我有一个csv文件，看起来像这样：

Name,A 
Age,23
DOB,26th,Jan
Anniversary,15th,May
Name,B 
Age,23
DOB,26th,Jan
Anniversary,15th,May
Name,C 
Age,23
DOB,26th,Jan
Anniversary,15th,May
Name,D 
Age,23
DOB,26th,Jan
Anniversary,15th,May

我想将第一列转换为其余数据的公共标题。我希望它看起来像这样：

Name,Age,DOB,Anniversary
A,23,26th Jan,15th May
B,23,26th Jan,15th May
C,23,26th Jan,15th May
D,23,26th Jan,15th May

我怎样才能做到这一点

Answer 1

可能的答案

with open(file,'r') as f:
    final = []
    counter = 0
    details = []
    for line in f:
        details.append(line.split(',')[1])
        counter += 1
        if counter == 4:
            counter = 0
            final.append(details)
             details = []

现在您可以在finaldict上迭代到文件