csv into multiple columns using split function using python

Question

I am trying to split a specific column of csv into multiple column and then appending the split values at the end of each row.

I wanted to split second column on ',' and '.' and ';' and then append to each row respective values.

import csv
fOpen1=open('Meta_D1.txt')

reader=csv.reader(fOpen1)
mylist=[elem[1].split(',') for elem in reader]
mylist1=[]

for elem in mylist:
    mylist1.append(elem)


#writing to a csv file
with open('out1.csv', 'wb') as fp:
    myf = csv.writer(fp, delimiter=',')
    myf.writerows(mylist1)

Can someone guide me further?

pls show the example of input and expected output. I can't understand what exactly you want. — Yevhen Kuzmovych
– Yevhen Kuzmovych, Commented Nov 29, 2016 at 19:44
are the values in elem[1] always the same length after splitting? — sirfz
– sirfz, Commented Nov 29, 2016 at 19:46
@RajatHanda I can't open the link and don't really want to download anything. So psl include couple lines of example in your question. That would be enough. — Yevhen Kuzmovych
– Yevhen Kuzmovych, Commented Nov 29, 2016 at 19:53

ettanany · Accepted Answer · 2016-11-29 20:13:01Z

1

To split with multiple delimiters, you can use regex:

import re
re.split(';|, |\. ', col_2)

Example from your file:

>>> col_2 = "Braund, Mr. Owen Harris;22"
>>> re.split(';|, |\. ', col_2)
['Braund', 'Mr', 'Owen Harris', '22']

Using this, try the following to achieve your desired output:

import csv
import re

with open('out1.csv', 'wb') as fp:
    with open('Meta_D1.txt', 'r') as f:
        reader = csv.reader(f)
        next(reader)
        for line in reader:
            cols = re.split(';|, |\. ', line[1])
            del line[1]
            line.extend(cols)
            myf = csv.writer(fp, delimiter=',')
            myf.writerow(line)

edited Nov 29, 2016 at 20:13

answered Nov 29, 2016 at 19:38

ettanany

20k9 gold badges49 silver badges64 bronze badges

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

2 Comments

Yevhen Kuzmovych Over a year ago

You are right. But it is basically copying mylist to mylist1. So it is useless to have mylist1.

Rajat Handa Over a year ago

Thank You, @ettanany . This is what I need

Collectives™ on Stack Overflow

csv into multiple columns using split function using python

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related