擅长:python、mysql、java
<p>因为它们只是csv文件,所以不需要excel库。在</p>
<pre><code>#!/usr/bin/env python
import argparse, csv
if __name__ == '__main__':
parser = argparse.ArgumentParser(description='merge csv files on field', version='%(prog)s 1.0')
parser.add_argument('infile', nargs='+', type=str, help='list of input files')
parser.add_argument(' col', type=int, default=0, help='Column to grab')
parser.add_argument(' row', type=int, default=0, help='Row to grab')
parser.add_argument(' out', type=str, default='temp.csv', help='name of output file')
args = parser.parse_args()
data = []
for fname in args.infile:
with open(fname, 'rb') as df:
reader = csv.reader(df)
for index, line in enumerate(reader):
if index == args.row:
data.push(line[args.column])
del reader
writer = csv.writer(open(args.out, "wb"), dialect='excel')
writer.writerows(data)
del writer
</code></pre>