擅长:python、mysql、java
<p>我认为您需要用Python打开文件,格式化并保存到excel中,然后重新进行分析。
这就是我的意思。
首先打开文件并将每一行放入列表中
然后做一个for循环,将不同的下标和上标转换成可以区分的东西。下面是一个示例代码</p>
<pre><code> import csv
csvfile = open('file.csv')
reader = csv.DictReader(csvfile)
dictList = []
for line in reader: dictList.append(line)
csvfile.close()
# Making the modifications inside our list, which
contains
# a dictionary for each line in the CSV.
for line in dictList:
for key in line:
line[key] = line[key].replace('\\', '\\\\')
line[key] = line[key].replace('#', '\\#')
line[key] = line[key].replace('_', '\\_')
line[key] = line[key].replace('&', '\\&')
# Writing the new lines to a new file.
with open('output.csv', 'w') as outfile:
fieldnames = ['Field 1', 'Field 2', 'Field 3']
writer = csv.DictWriter(outfile,
fieldnames=fieldnames)
writer.writeheader()
for line in dictList:
writer.writerow(line)
</code></pre>