How to write data into a CSV file using python?

Question

I'm wrinting trying to write the following data into a csv file.The data is employdetails

name1-surname1-place1

name2-surname2-place2

name3-surname3-place3

name4-surname4-place4

I want the output to be on CSV files one below the other on separate rows.

I have written the below code

reader = csv.reader(file)

op = open(path+"op.CSV", "wb")

String=list[0] + "-" + list[1] + "-" + list[2] + "-" + list[4]
 op.writer(String)

PLEASE HELP.

Thanks in advance.

-KD

CSV can and does have many different characters used as delimiters. For example in some countries , is actual the symbol for decimals. Source — DormeoES
– DormeoES, Commented Oct 17, 2014 at 7:10

xecgr · Accepted Answer · 2014-10-17 07:06:33Z

2

If i've understood your question well, you are looking for this:

>>> import csv
>>> employees = [
...     'name1-surname1-place1',
...     'name2-surname2-place2',
...     'name3-surname3-place3',
...     'name4-surname4-place4',
... ]
>>> with open('out.csv', 'w') as out:
...     writer = csv.writer(out)
...     for e in employees:
...         writer.writerow(e.split("-"))
... 
>>> 
>>> 
host:~$ head out.csv 
name1,surname1,place1
name2,surname2,place2
name3,surname3,place3
name4,surname4,place4

answered Oct 17, 2014 at 7:06

xecgr

5,2033 gold badges22 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How to write data into a CSV file using python?

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related