A python script to convert a spreadsheet(in CSV format) to a question-answer type document(where the heading of each column is the question and each row is an answer), generally useful to generate readable documents from surveys or similar spread sheets

csvToReadableReport.py

#a script to convert a spreadsheet to a  question-answer type document(where the heading of each column is the question and each row is an answer), generally useful to generate readable documents from surveys or similar spread sheets


import csv
with open('survey.csv', 'rb') as csvfile:
    reader = csv.reader(csvfile)
    csv_as_list = list(reader)


titles=csv_as_list[0];

for i in range(1,len(csv_as_list)):
    print "==================================================================";
    for j in range(len(csv_as_list[i])):
        print "\n"+titles[j]+"\n"
        if(csv_as_list[i][j].strip()==""):
            print "NA\n"
        else:
            print csv_as_list[i][j]+"\n"