Writing multiple lists to csv Python

Question

Im trying to write a function that writes multiple lists to a singular csv file and i am able to get the column titles to write, but not any of the data. My data is in lists that are similar to this [92,3801,2,22,4] and the second is [3.0,2,23,5] and im looking for guidance on this. Thank you!

import csv
def export_results(number_of_words_sentence,mean_word_per_sentence):
    with open("assignment_7_results.csv", "w", newline="") as Assignment_7_results:
        writer = csv.writer(Assignment_7_results)
        writer.writerow(["Number of Words", "Words/Sentence"])
    # Our .csv file will have two columns, one for the dict keys and one for the dict values
        writer.writerows(number_of_words_sentence)
        writer.writerows(mean_words_per_sentence)

As the name implies, writerows writes rows, not columns. You'll have to zip and iterate over each pair of elements in turn, and call writerow — cs95
– cs95, Commented Oct 22, 2017 at 0:02

cs95 · Accepted Answer · 2017-10-22 00:05:13Z

1

As the name implies, writerows writes rows, not columns. Furthermore, your lists are not equally sized, so you'll need to do something to account for that. The standard way of handling such a thing is using itertools.zip_longest.

from itertools import zip_longest # izip_longest in python2.x

with open("assignment_7_results.csv", "w") as f:
    w = csv.writer(f)
    w.writerow(["Number of Words", "Words/Sentence"])
    for x, y in zip_longest(number_of_words_sentence, mean_word_per_sentence):
        w.writerow([x, y])

answered Oct 22, 2017 at 0:05

cs95

406k106 gold badges744 silver badges797 bronze badges

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

8 Comments

J. McCraiton Over a year ago

I tried adding this to my code and it did not produce an output

cs95 Over a year ago

@J.McCraiton Okay. And? Do you think that piece of information can help me understand what's wrong?

J. McCraiton Over a year ago

Currently it produces the headings and with no columns underneath it. Sorry, should have been a little more descriptive. My bad man.

cs95 Over a year ago

@J.McCraiton I see. That's a little weird. Are you sure your lists are being passed with data?

J. McCraiton Over a year ago

Im 95% sure. I am using lists generated from previous functions that I am able to print out to view the results and inputting those lists as the parameters

|

Rakesh Karkare · Accepted Answer · 2020-06-03 20:17:19Z

0

Try this to store the data in csv file with multiple list of different length. Here I tried to give header same as A and B as list name.

import pandas as pd

A = ['Apple', 'Dog']

B = ['Cat', 'OWL', 'PEACOCK']

dict_1 = {'A': A, 'B': B}

df = pd.DataFrame.from_dict(dict_1, orient='index')

dt = df.transpose()

dt.to_csv('myfile.csv', index=False, header=True,  encoding='utf-8')

answered Jun 3, 2020 at 20:17

Rakesh Karkare

917 bronze badges

Collectives™ on Stack Overflow

Writing multiple lists to csv Python

2 Answers 2

8 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

8 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related