Writing a CSV file

Language Help Python
1

Hi there,
I wanted to ask whether the order in which we write the fields=[…] matter when writing a csv file?
Here is the example:

access_log = [{‘time’: ‘08:39:37’, ‘limit’: 844404, ‘address’: ‘1.227.124.181’}, {‘time’: ‘13:13:35’, ‘limit’: 543871, ‘address’: ‘198.51.139.193’}, {‘time’: ‘19:40:45’, ‘limit’: 3021, ‘address’: ‘172.1.254.208’}, {‘time’: ‘18:57:16’, ‘limit’: 67031769, ‘address’: ‘172.58.247.219’}, {‘time’: ‘21:17:13’, ‘limit’: 9083, ‘address’: ‘124.144.20.113’}, {‘time’: ‘23:34:17’, ‘limit’: 65913, ‘address’: ‘203.236.149.220’}, {‘time’: ‘13:58:05’, ‘limit’: 1541474, ‘address’: ‘192.52.206.76’}, {‘time’: ‘10:52:00’, ‘limit’: 11465607, ‘address’: ‘104.47.149.93’}, {‘time’: ‘14:56:12’, ‘limit’: 109, ‘address’: ‘192.31.185.7’}, {‘time’: ‘18:56:35’, ‘limit’: 6207, ‘address’: ‘2.228.164.197’}]

import csv
with open(“logger.csv”,“w”) as logger_csv:
field =[ “time”, “limit”,“address”] # THIS GIVES ME AN ERROR EVEN THOUGH THE ACCESS_LOG IS IN THIS ORDER!?!?
log_writer = csv.DictWriter(logger_csv, fieldnames=field)
log_writer.writeheader()
for i in access_log:
log_writer.writerow(i)
======= END OF CODE ==========
IN SHORT,
THIS LINE -----field =[ “time”, “limit”,“address”] ---- # THIS GIVES ME AN ERROR EVEN THOUGH THE ACCESS_LOG IS IN THIS ORDER??? BUT, fields =[‘time’,‘address’,‘limit’] WORKS ??? WHY IS THAT???

2

Could you please check the following FAQ for details of how to format code for the forums, it’s harder to understand without it.

What error are you receiving from this line?

3

This is the error that I am receiving: " Did you write the contents of access_log to logger.csv as a CSV?"

4

Is this part of a lesson, if so please include the link.

That error doesn’t look like it’s anything to do with Python itself and is more likely a background test checking the contents of the file (if the file is in a different order than it expected then the test may be failing).