Python: Write output in a csv-file

Question

I have the following text (as string, \t = Tab): Article_1 \t Title of Article \t author of article \n Article_2 \t Title of Art 2 \t author of article 2 \n

I'd like to save this in a csv-file s.t. I can open it in Excel. In fact, it is possible to open the file I got in Excel, but the program writes everything in the first column, but I'd like to have "art_1, art_2, ..." in the first column, the titles in the second and the authors in the third column. How can I do this?

Thanks for any help! :)

Gillespie · Accepted Answer · 2014-10-07 22:12:37Z

1

If you have a string, str, one easy way is just:

with open("file.csv","w") as f:
    f.write(','.join(str.split()))

If you have multiple strings, and they are stored in a list, str_list, you could do this:

with open("file.csv","w") as f:
    for line in str_list:
        f.write(','.join(line.split()))
        f.write('\n')

If the question is how to split one monolithic string into manageable sub-strings, then that's a different question. In that case you'd want to split() on the \t and then go through the list 3 at a time.

There's also a csv python package that provides a clean way of creating csv files from python data structures.

edited Oct 7, 2014 at 22:12

answered Oct 7, 2014 at 22:07

Gillespie

6,6263 gold badges38 silver badges71 bronze badges

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

Comments

Achint · Accepted Answer · 2014-10-07 22:42:41Z

0

In case you want to use the csv module

import csv

with open("csv_file.csv", "wb") as csv_file:
  csv_writer = csv.writer(csv_file, delimiter=",")
  for str in list_of_articles:
    csv_writer.writerow(str.split("\t"))

answered Oct 7, 2014 at 22:42

Achint

8173 gold badges10 silver badges24 bronze badges

Collectives™ on Stack Overflow

Python: Write output in a csv-file

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related