How do I split multi-lines (comma-containing) string from txt file on python2

Question

I'm really new on Python so I need your help

I have a text like this:

19 , 22.3 ,22.24 , 79 , 40.764767 ,29.932207  
1 , 24.38 ,24.50 , 586 , 40.762291 ,29.919300  
11 , 23.13 ,23.24 , 105 , 40.763786 ,29.929407  
12 , 22.38 ,23.56 , 71 , 40.765610 ,29.941540  
5 , 23.2 ,24.15 , 173 , 40.763805 ,29.929356

I tried to split:

array = file.read().split(",")

but result was like so

['19 ', ' 22.3 ', '22.24 ', ' 79 ', ' 40.764767 ', '29.932207  \n1 ',
 ' 24.38 ', '24.50 ', ' 586 ', ' 40.762291 ', '29.919300  \n11 ', ' 23.13 ',
'23.24 ', ' 105 ', ' 40.763786 ', '29.929407  \n12 ', ' 22.38 ', '23.56 ', 
' 71 ', ' 40.765610 ', '29.941540  \n5 ', ' 23.2 ', '24.15 ', ' 173 ',
 ' 40.763805 ', '29.929356 \n']

But I want to make it without '\n' because after split operation , I have to return string to int . So how can I make it ?

vks · Accepted Answer · 2017-04-27 15:23:34Z

5

import re
x="""19 , 22.3 ,22.24 , 79 , 40.764767 ,29.932207
1 , 24.38 ,24.50 , 586 , 40.762291 ,29.919300
11 , 23.13 ,23.24 , 105 , 40.763786 ,29.929407
12 , 22.38 ,23.56 , 71 , 40.765610 ,29.941540
5 , 23.2 ,24.15 , 173 , 40.763805 ,29.929356  """
print re.split(r" *, *|\n", x)

You can do it in one go using re.

Output:['19', '22.3', '22.24', '79', '40.764767', '29.932207', '1', '24.38', '24.50', '586', '40.762291', '29.919300', '11', '23.13', '23.24', '105', '40.763786', '29.929407', '12', '22.38', '23.56', '71', '40.765610', '29.941540', '5', '23.2', '24.15', '173', '40.763805', '29.929356 ']

answered Apr 27, 2017 at 15:23

vks

68.1k11 gold badges96 silver badges132 bronze badges

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

Comments

Trolldejo · Accepted Answer · 2017-04-27 15:29:04Z

0

Does this work:

array = [file.read().replace('\n','').split(',')]

edited Apr 27, 2017 at 15:29

answered Apr 27, 2017 at 15:17

Trolldejo

4661 gold badge7 silver badges20 bronze badges

Comments

Dalvenjia · Accepted Answer · 2017-04-27 15:19:08Z

-1

This should work:

array = [line.split(',') for line in file.read().splitlines()

answered Apr 27, 2017 at 15:19

Dalvenjia

2,0731 gold badge15 silver badges17 bronze badges

Comments

kdopen · Accepted Answer · 2017-04-27 15:25:51Z

-1

Your text file has six floats per line.

If you want each line kept separate:

with open("path/to/file", "rt") as f:
    data = [ [float(v.strip()) for v in l.strip().split(',')] 
            for l in f]

If you just want an array containing all the numbers (i.e. ignoring line structure of file)

with open("path/to/file", "rt") as f:
    data = [ float(v.strip()) 
             for l in f 
             for v in l.strip().split(',')]

answered Apr 27, 2017 at 15:25

kdopen

8,2357 gold badges50 silver badges57 bronze badges

Collectives™ on Stack Overflow

How do I split multi-lines (comma-containing) string from txt file on python2

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related