separating columns CSV in python

Question

how to separate this line, I need just the numbers

PD-1358 393;

I would like to increment a variable X and a Y

 X   Y
PD-1358 393;

I am using the CSV command (csv_file, delimiter='-') but I can not separate these numbers. Can anybody help me?

import csv

with open('circulo.txt') as csv_file:
    csv_reader = csv.reader(csv_file, delimiter='-')

    line_count = 0
    for row in csv_reader:

         print(f'\t {row[0]}')

For the moment I've only been able to separate this part

It is not quite clear the expected output and input. Also as mentioned above, please post the code you tried. — niraj
– niraj, Commented Apr 19, 2019 at 1:11

ggrelet · Accepted Answer · 2019-04-19 01:29:40Z

2

Using regex you can simply do:

import re

re.findall(r'\d+', "PD-1358 393")

Result:

['1358', '393']

answered Apr 19, 2019 at 1:29

ggrelet

1,1118 silver badges23 bronze badges

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

Comments

ggrelet · Accepted Answer · 2019-04-19 01:27:00Z

0

Don't know of an easy way to do this, but assuming you've turned the data into a string like so:

s = 'PD-1358 393'

Then create a generator to go to the first instance of a digit:

i = next((index for (index,value) in enumerate(s) if value.isdigit()))

And then split:

s[i:].split()

Returns:

['1358', '393']

edited Apr 19, 2019 at 1:27

ggrelet

1,1118 silver badges23 bronze badges

answered Apr 19, 2019 at 1:25

Ishmael

2353 gold badges8 silver badges17 bronze badges

Comments

James Holmes · Accepted Answer · 2019-04-19 01:30:35Z

0

If you want numbers in the final array:

line = 'PD-1358 393;'

parts = line.split(' ')

numbers = [int(''.join(i for i in part if i.isdigit())) for part in parts]

answered Apr 19, 2019 at 1:30

James Holmes

4093 silver badges6 bronze badges

Collectives™ on Stack Overflow

separating columns CSV in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related