How to save a list as a .csv file with python with new lines?

How to save a list as a .csv file with python with new lines?

use pandas to_csv (http://pandas.pydata.org/pandas-docs/dev/generated/pandas.DataFrame.to_csv.html)

>>> import pandas as pd
>>> df = pd.DataFrame(some_list, columns=[colummn])
>>> df.to_csv(list.csv, index=False)

If you want all the words on different lines you need to set the deliiter to n:

l = [hello,how,are,you]
import  csv

with open(out.csv,w) as f:
    wr = csv.writer(f,delimiter=n)
    wr.writerow(l)

Output:

hello
how
are
you

If you want a trailing comma:

with open(out.csv,w) as f:
    wr = csv.writer(f,delimiter=n)
    for ele in l:
        wr.writerow([ele+,])

Output:

hello,
how,
are,
you,

I would recommend just writing the elements without the trailing comma, there is no advantage to having a trailing comma but may well cause you problems later.

How to save a list as a .csv file with python with new lines?

You can just pass this as the value of a dict with key column to a DataFrame constructor and then call to_csv on the df:

In [43]:

df = pd.DataFrame({column:[hello,how,are,you]})
df
Out[43]:
  column
0  hello
1    how
2    are
3    you
In [44]:

df.to_csv()
Out[44]:
,columnn0,hellon1,hown2,aren3,youn