将一行字符串分隔成不同的行 [英] Separate a row of strings into separate rows

问题描述

Email,Division,Department

预期输出： / p>

Expected output:

Email,Division,Department

推荐答案

Python Power Unleased：

Python Power Unleased :

import csv,sys
filename = 'a.csv'
with open(filename,'rb') as csvfile:
reader = csv.reader(csvfile,delimiter=',')
try:
    for row in reader:
        if row[1].find(',') == -1:
            line = ','.join(row)
            print line
        else:
            for i in range(0,row[1].count(',')+1):
                line = row[0]+','+row[1].split(',')[i]+','+row[2].split(',')[i]
                print line
except csv.Error as e:
    sys.exit('file %s, line %d: %s' % (filename, reader.line_num, e))

这篇关于将一行字符串分隔成不同的行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！