|
Last change
on this file since 11107 was
9362,
checked in by uli, 12 years ago
|
|
Update tools to allow new ids in imports. Support for new import col 'old_id'.
|
|
File size:
673 bytes
|
| Line | |
|---|
| 1 | """Add a new column old id with contents from col `student_id` |
|---|
| 2 | """ |
|---|
| 3 | |
|---|
| 4 | ### |
|---|
| 5 | ### CONFIGURATION |
|---|
| 6 | ### |
|---|
| 7 | |
|---|
| 8 | IN_FILE = 'mytry.csv' |
|---|
| 9 | |
|---|
| 10 | # new col name. 'old_id' is expected by fix_import_file.py |
|---|
| 11 | NEW_COL = 'old_id' |
|---|
| 12 | |
|---|
| 13 | ### |
|---|
| 14 | ### CONFIGURATION - END |
|---|
| 15 | ### |
|---|
| 16 | |
|---|
| 17 | |
|---|
| 18 | import csv |
|---|
| 19 | OUT_FILE = '%s_edited.csv' % IN_FILE.split('.')[0] |
|---|
| 20 | reader = csv.DictReader(open(IN_FILE, 'rb')) |
|---|
| 21 | |
|---|
| 22 | for num, row in enumerate(reader): |
|---|
| 23 | if num == 0: |
|---|
| 24 | writer = csv.DictWriter( |
|---|
| 25 | open(OUT_FILE, 'wb'), reader.fieldnames + [NEW_COL,]) |
|---|
| 26 | header = dict([(x, x) for x in writer.fieldnames]) |
|---|
| 27 | writer.writerow(header) |
|---|
| 28 | row[NEW_COL] = row['student_id'] |
|---|
| 29 | writer.writerow(row) |
|---|
| 30 | |
|---|
| 31 | print "RESULT in ", OUT_FILE |
|---|
Note: See
TracBrowser for help on using the repository browser.
