我的文件就像Heading1,Heading2,Heading3,Heading4,Heading5
阿尔法,贝塔,伽马,脸,人类
狗,骆驼,马,狮子
#################摘要###############################
Heading6 = V8CA02TB Heading7 = 8R1 Heading8 = ENVS2F12SLB2 Heading9 = mkern2 Heading10 = 1654774930624 Heading11 = 09 13:42:10 2022
我想做这样的文件
Heading1,Heading2,Heading3,Heading4,Heading5,Heading6,Heading7,Heading8,Heading9,Heading10,Heading11
阿尔法,贝塔,伽玛,脸,人类,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624,09 13:42:102022
猫,狗,骆驼,马,狮子,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624,09 13:42:10 2022
我必须在多个文件上这样做,然后将所有文件合并到一个文本文件中。
任何帮助都将不胜感激。
发布于 2022-07-20 05:52:09
这将解析您的格式。
with open('x.data') as fin:
header = None
rows = []
extra = []
for line in fin:
if len(line) < 5:
continue
if not header:
header = line.strip().split(',')
elif 'Summary' in line:
break
else:
rows.append( line.strip().split(',') )
for line in fin:
line = line.strip()
if not line:
continue
left,_,right = line.partition(' = ')
header.append( left )
extra.append( right )
with open('out.data', 'w') as fout:
print( ','.join(header), file=fout )
for row in rows:
print( ','.join(row+extra), file=fout )输出:
A,B,C,D,E,F,G,H,I,J,K
Alpha, Beta, Gama, Face, Human,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624, 09 13:42:10 2022
Cat, Dog, Camel, Horse, Lion,V8CA02TB,8R1,ENVS2F12SLB2,mkern2,1654774930624, 09 13:42:10 2022即使没有Python,合并多个文件也很容易。
https://stackoverflow.com/questions/73046439
复制相似问题