How can I export my quiz results to a csv file using python 3?

Question

I want the results to be in the format Date, Question, Name and Score

file = open("results.csv", "a")
file.write('Date, Question, Name, Score\n' + date + ',' question + ',' + name + ',' + score + '\n')
file.close()

When I run this code i keep getting the error: TypeError: Can't convert 'int' object to str implicitly

Padraic Cunningham · Accepted Answer · 2015-02-09T10:31:18.147

1

You have to cast to any ints to string string before you can concat it to another and write to file.

str(score) #  <-

 file.write('Date, Question, Name, Score\n' + date + ',' question + ',' + name + ',' + str(score) + '\n')

Or use str.format:

with open("results.csv", "a") as f: # with closes your files automatically
    f.write('Date, Question, Name, Score\n {}, {}, {}, {}'.format(date, question, name ,score))

You may also find the csv module useful

edited Feb 09 '15 at 10:31

answered Feb 09 '15 at 10:24

Padraic Cunningham

176,452
29
245
321

@JD245, no worries, add a link to the csv module that you may find useful – Padraic Cunningham Feb 09 '15 at 10:31
How would I do that? – JD245 Feb 09 '15 at 10:37
@JD245, there is a nice easy to follow tut here http://pymotw.com/2/csv/ – Padraic Cunningham Feb 09 '15 at 10:39

score 1 · Answer 2 · answered Feb 09 '15 at 10:24

1

Then convert it explicitly to str:

file.write('Date, Question, Name, Score\n' + str(date) + ',' question + ',' + name + ',' + str(score) + '\n')

answered Feb 09 '15 at 10:24

runDOSrun

10,359
7
47
57

How can I export my quiz results to a csv file using python 3?

2 Answers2