flatten the the table

csv_flattening.py

import csv

input_file_path = 'ehr_clean.csv'
output_file_name = 'ehr_clean_f.csv'
f = open(input_file_path)
csv_f = csv.reader(f)

rows = []

for row in csv_f:
    rows.append(row)

f.close()

col_names = rows[0]
rows.pop(0)
print col_names
f2 = open(output_file_name, 'w')
f2.write('tid,attr_name,attr_val\n')

index = 1
for r in rows:
    for (idx, el) in enumerate(r):
        line = '{},{},{}\n'.format(str(index), col_names[idx], el)
        f2.write(line)
    index += 1

f2.close()