1 |
4654
|
aaronmk
|
#!/usr/bin/env python
|
2 |
|
|
# Inserts a new, empty spreadsheet column before the given index.
|
3 |
|
|
|
4 |
|
|
import csv
|
5 |
|
|
import sys
|
6 |
|
|
|
7 |
|
|
def main():
|
8 |
|
|
try: _prog_name, col_num, name = sys.argv
|
9 |
|
|
except ValueError: raise SystemExit('Usage: '+sys.argv[0]
|
10 |
|
|
+' <in col# col_name [| '+sys.argv[0]+' col_2# col_2_name]... >out')
|
11 |
|
|
col_num = int(col_num)
|
12 |
|
|
|
13 |
|
|
# Transform input
|
14 |
|
|
reader = csv.reader(sys.stdin)
|
15 |
|
|
writer = csv.writer(sys.stdout)
|
16 |
|
|
is_header = True
|
17 |
|
|
value = name
|
18 |
|
|
for row in reader:
|
19 |
|
|
row.insert(col_num, value)
|
20 |
|
|
if is_header:
|
21 |
|
|
is_header = False
|
22 |
|
|
value = ''
|
23 |
|
|
writer.writerow(row)
|
24 |
|
|
|
25 |
|
|
main()
|