Splitting a line with different separators in python

Question

I have a text file containing some data stored in three columns. The first column is separated from the second by a comma (,) and a tab (\t) and the same for the separation between the second and the third. However, the last column is terminated with a comma and a newline command (\n). Here is an example:

0.782470450031, 0.0, 0.0, 0.775811285325, 0.025, 0.0, 0.768594334758, 0.05, 0.0, 0.761101295788, 0.075, 0.0,

I would like to read this file and transform it into an array. If the columns were only separated by a comma I would just do:

f=open(filename,'r') data=[map(float,line.split(',')) for line in f] data=np.array(data)

But I am not exactly sure how to do this in this case.

Thanks in advance for your help!

Don't even worry about the extra white space, tabs, etc. The float conversion will discard all of that for example float('\t12.5\t\n') will produce the float 12.5. — Cory Kramer
– Cory Kramer, Commented Jul 16, 2015 at 15:08

Maroun · Accepted Answer · 2015-07-16 15:05:01Z

1

Use a regex:

re.split(r',\t', line)

If this is CSV file, you don't need regex, there are many tools that does that for you.

answered Jul 16, 2015 at 15:05

Maroun

96.3k30 gold badges195 silver badges249 bronze badges

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

Comments

Avinash Raj · Accepted Answer · 2015-07-16 15:05:57Z

0

I did use re module.

data=[map(float,re.split(r',\t*', line)) for line in f] data=np.array(data)

answered Jul 16, 2015 at 15:05

Avinash Raj

175k32 gold badges247 silver badges289 bronze badges

Collectives™ on Stack Overflow

Splitting a line with different separators in python

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related