Python在excel中读取特定单元格值 [英] Python read particular cell value in excel

问题描述

我有一个名为123.csv的exel文件，它是运行PROM功能时得到的输出，由两个列case和event组成。我想通过对事件进行分组来修改此输出。更具体地说，我想写一个python脚本，将属于同一个案件的事件合并在一个新的单元格，没有配合我的初始矩阵的长度。任何人都可以给我一些想法吗？
curent and desiret output

I have an exel file named "123.csv" that is the output i get when running a PROM functionality, consisting of two columns "case" and "event". I want to modify this output by grouping events based on case. More specifically i want to write a python script that will group events that belong to the same case to be merged in a new cell, no mate what the length of my initial matrix is.Could anyone please give me some idea? curent and desiret output

import csv

with open('123.csv', 'rb') as csvfile:
    spamreader = csv.reader(csvfile, delimiter=' ', quotechar='|')
    for row in spamreader:
       print ', '.join(row).replace(',',' ').replace('"',' ') 

这是我写的一个部分，但它只读取文件，

this is a part i wrote, but it only reads the file and removes some punctiation

推荐答案

使用简单的csv& defaultdict（python 3）很容易。

It's easy to do with simple csv & defaultdict (python 3)

您的输入是

case,event
101,A
101,X
101,Y
102,B
102,C
103,Z

b $ b

代码：

code:

import collections

with open("csv.csv") as f:
    cr = csv.reader(f,delimiter=",")

    d=collections.defaultdict(lambda : list())
    header=next(cr)   # read title
    for r in cr:
        d[r[0]].append(r[1])  # fill dict

with open("csv2.csv","w",newline="") as f:
    cr = csv.writer(f,delimiter=",")
    cr.writerow(header)  # title
    for k,v in d.items():
        cr.writerow([k,",".join(v)])

输出

case,event
103,Z
101,"A,X,Y"
102,"B,C"

这篇关于Python在excel中读取特定单元格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！