Saving zip list to csv in Python

Question

How I can write below zip list to csv file in python?

[{'date': '2015/01/01 00:00', 'v': 96.5},
 {'date': '2015/01/01 00:01', 'v': 97.0},
 {'date': '2015/01/01 00:02', 'v': 93.75},
 {'date': '2015/01/01 00:03', 'v': 96.0},
 {'date': '2015/01/01 00:04', 'v': 94.5}

I have this error:

_csv.Error: sequence expected

My code is here:

import csv
res = zip_list
csvfile = "/home/stm/PycharmProjects/isbak_trafik/example.csv"

with open(csvfile, "w") as output:
    writer = csv.writer(output, lineterminator='\n')
    writer.writerows(res)

The dictionaries are not sequences. Use csv.DictWriter. Or write dict.values() — Open AI - Opting Out
– Open AI - Opting Out, Commented Feb 8, 2016 at 8:38

Istvan · Accepted Answer · 2016-02-08 09:00:51Z

2

writer.writerows expects a sequence of values for writing a single row into the CSV file.

Using your original code:

import csv
res =[{'date': '2015/01/01 00:00', 'v': 96.5}, {'date': '2015/01/01 00:01', 'v': 97.0}, {'date': '2015/01/01 00:02', 'v': 93.75}, {'date': '2015/01/01 00:03', 'v': 96.0}, {'date': '2015/01/01 00:04', 'v': 94.5}]
csvfile = "example.csv"
with open(csvfile, "w") as output:
  writer = csv.writer(output, lineterminator='\n')
  for line in res:
    date = line['date']
    value = line['v']
    writer.writerow([date, value])

answered Feb 8, 2016 at 9:00

Istvan

8,83212 gold badges76 silver badges126 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Martin Evans · Accepted Answer · 2016-02-08 09:04:37Z

2

You can switch to using Python's DictWriter for this. You can pass a list of column headers, this ensures that the order of the columns in the output is what you require. Only columns in this list are written to the your output file:

import csv

zip_list = [
    {'date': '2015/01/01 00:00', 'v': 96.5},
    {'date': '2015/01/01 00:01', 'v': 97.0},
    {'date': '2015/01/01 00:02', 'v': 93.75},
    {'date': '2015/01/01 00:03', 'v': 96.0},
    {'date': '2015/01/01 00:04', 'v': 94.5}]

csvfile = "/home/stm/PycharmProjects/isbak_trafik/example.csv"

with open(csvfile, "wb") as output:
    writer = csv.DictWriter(output, fieldnames=['date', 'v'])
    writer.writeheader()
    writer.writerows(zip_list)

This would produce the following output:

date,v
2015/01/01 00:00,96.5
2015/01/01 00:01,97.0
2015/01/01 00:02,93.75
2015/01/01 00:03,96.0
2015/01/01 00:04,94.5

answered Feb 8, 2016 at 9:04

Martin Evans

46.9k17 gold badges88 silver badges104 bronze badges

1 Comment

serenade Over a year ago

Thank you!! @MartinEvans

Johann Hagerer · Accepted Answer · 2016-02-08 12:54:01Z

2

Since I find csv.DictWriter not transparent in what its doing, I would recommend doing the following:

with open(csvfile, "w") as output:
    output.write(';'.join(list(res[0].keys()))+"\n")
    [output.write(';'.join(list(map(str, r.values())))+"\n") for r in res]

edited Feb 8, 2016 at 12:54

answered Feb 8, 2016 at 8:50

Johann Hagerer

1,0872 gold badges10 silver badges28 bronze badges

4 Comments

Johann Hagerer Over a year ago

The last line of the code example is just a trick, so that you can write it in one line. It should not be forgotten that this is not recommended by the PEP8 code style guide.

serenade Over a year ago

Thank you. But as a result, I have just "date" and "v" in my csv. However, I want to take these numeric values to my csv file. Please can you help me ? @GerhardHagerer [{'date': '2015/01/01 00:00', 'v': 96.5}, {'date': '2015/01/01 00:01', 'v': 97.0}, {'date': '2015/01/01 00:02', 'v': 93.75}

Johann Hagerer Over a year ago

Sorry, I corrected the code example. I tested it and it works fine in my Python3 shell

serenade Over a year ago

Thank you for your help! @GerhardHagerer

Collectives™ on Stack Overflow

Saving zip list to csv in Python

3 Answers 3

Comments

1 Comment

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related