我试图在下面的代码中添加一个特性,但似乎在某个地方出了问题。在
下面的代码基本上为下面的每个演讲者重复第一个“z”表列(就像excel的换位)。因为“z”后面的列是日期,只需要一个日期列。在
问题是python脚本正确地生成了值,但是需要它插入一个关于日期的列,将此信息重复到所有该日期的值上。在
Python脚本:from itertools chain from import
f = open ("C:\\Test.CSV", "r")
sep = ""
M = []
M = [M + [s.strip () for s in line.split (sep)] for line in f.readlines ()]
f.close ()
i = 0 # title
w = 4 # cols in title
r = 1 # body
z = 4 # fields fix
result = [M [i] [w] + ["date"] + ["Value"]] + list (chain (* [[x [: z] + [y] for y in x [z + 1: ]] for x in M [A:]]))
f = open ("C:\out.csv", 'w')
f.writelines ("\ n" .join ("". join (s) for s in result) + "\ 0")
f.close ()
某物(输入):
^{pr2}$
当前脚本正确执行此操作(立即输出):[[X; y; date1]
[01; 02; 03]
[01; 02; 04]
[01; 02; 05]
[06; 07; 08]
[06; 07; 09]
[06; 07; 10]
[11; 12; 13]
[11; 12; 14]
[11; 12; 15]]
输出为期望输出:[[X; y; date; value; ]
[01; 02; date1; 03]
[01; 02; date2; 04]
[01; 02; date3; 05]
[06; 07; date1; 08]
[06; 07; date2; 09]
[06; 07; date3; 10]
[11; 12; date1; 13]
[11; 12; date2; 14]
[11; 12; date3; 15]]
有人做过这样的事吗?在