python list to csv file with each item in new line

Question

I am trying to write a function that takes in a list of strings and writes each String in the list as a separate row in a csv file, but I am not getting any output. Could you please help me understand what I am doing wrong. Here is my code:

 import sys 
 import os
 import csv

 list= ['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']

 def write_to_csv(list_of_emails):
     with open('emails.csv', 'w', newline='') as csvfile:
         writer = csv.writer(csvfile, delimiter = ',')
         writer.writerows(list_of_emails)

write_to_csv(list)

RoadRunner · Accepted Answer · 2018-06-29 11:43:26Z

4

If your just writing each string on a seperate line, you can just keep it simple and just write each item with a \n:

lst= ['[email protected]', '[email protected]', '[email protected]']

def write_to_csv(list_of_emails):
    with open('emails.csv', 'w') as csvfile:
        for domain in list_of_emails:
            csvfile.write(domain + '\n')

write_to_csv(lst)

Which Outputs:

[email protected]
[email protected]
[email protected]

You also shouldn't use list as a variable name, since it shadows the builtin function list.

edited Jun 29, 2018 at 11:43

answered Jun 29, 2018 at 11:36

RoadRunner

26.4k6 gold badges46 silver badges77 bronze badges

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

Comments

Ingrid · Accepted Answer · 2018-06-29 12:03:50Z

4

Why don't you try doing it with pandas instead. It's super easy. :)

lst = ['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']

First, import package

import pandas

Then, create dataframe

df = pandas.DataFrame(data={"email": lst})

Then, export to csv :)

df.to_csv("./mycsv.csv", sep=',',index=False)

Done :) let me know if this one works for you!

edited Jun 29, 2018 at 12:03

answered Jun 29, 2018 at 11:36

Ingrid

769 bronze badges

Comments

jpp · Accepted Answer · 2018-06-29 11:31:17Z

2

You can use delimiter='\n' with csv.writer.writerow (notice, not writerows). In addition, newline='' is not required as an argument to open.

import sys 
import os
import csv

L = ['[email protected]', '[email protected]', '[email protected]']

def write_to_csv(list_of_emails):
    with open('emails.csv', 'w') as csvfile:
        writer = csv.writer(csvfile, delimiter='\n')
        writer.writerow(list_of_emails)

write_to_csv(L)

answered Jun 29, 2018 at 11:31

jpp

166k37 gold badges301 silver badges363 bronze badges

Comments

Rakesh · Accepted Answer · 2018-06-29 11:34:31Z

0

You need to use writerow

Ex:

import sys 
import os
import csv

l= ['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']

def write_to_csv(list_of_emails):
    with open('emails.csv', 'w', newline='') as csvfile:
        writer = csv.writer(csvfile, delimiter = '\n')
        writer.writerow(list_of_emails)

write_to_csv(l)

edited Jun 29, 2018 at 11:34

answered Jun 29, 2018 at 11:28

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

Comments

Yayati Sule · Accepted Answer · 2018-06-29 11:41:23Z

You can change the code as follows:

import sys 
import os
import csv

listOfLines= [['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']]

def write_to_csv(list_of_emails):
   with open('emails.csv', 'w', newline='') as csvfile:
       writer = csv.writer(csvfile, delimiter = ',')
       writer.writerows(list_of_emails)

write_to_csv(listOfLines)

The function writer.writerows() takes a list of lists, in our case [['[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]', '[email protected]']], where every sub-list inside the original list is treated as a single line of the CSV file. You also should not use reserved keywords like list for variable names. list,dict are functions used to create Lists and Dictionaries respectively. May be in your code it did not throw any error, but for scripts that are larger than the current piece of code in question, the interpreter throws errors for the same and such errors become harder to debug

Collectives™ on Stack Overflow

python list to csv file with each item in new line

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related