How to remove the commas from string with no spaces for int conversion

Question

I'm trying to remove the commas from this data set so they can be converted to int and be summed up all but I can't seem to find any way to do it without introducing spaces to the number values.

 parse = g.readlines()[8:]
 for x in parse:
    val0 = x.strip(',')
    val = val0.split(" ")
    i15.append(val[1])

this is my current code trying to remove the commas.

Does this answer your question? [Python parse comma-separated number into int](https://stackoverflow.com/questions/2953746/python-parse-comma-separated-number-into-int) — DarrylG, Oct 28 '22 at 12:35

score 0 · Answer 1 · edited Oct 28 '22 at 12:33

0

parse = g.readlines()[8:]
for x in parse:
    val0 = x.replace(',' , '')
    val = val0.split(" ")
    i15.append(val[1])

Try this

edited Oct 28 '22 at 12:33

quamrana

37,849
12
53
71

answered Oct 28 '22 at 12:31

Muzubul Rehman

95
11

['ARMM', '\t', '\t60342768\t62928933\t72664072\n'] returns me this list – noobiecoder Oct 28 '22 at 12:36
@noobiecoder.can you ping the entire code. so i could check. – Muzubul Rehman Oct 28 '22 at 12:41

score 0 · Answer 2 · answered Oct 28 '22 at 12:37

0

Assumption: Panda Data frame has been used

You can use below code to solve your problem

df1['columnname'] = df1['columnname'].str.replace(',', '')

Hope this solve your problem

answered Oct 28 '22 at 12:37

Mitul

42
6

score 0 · Answer 3 · answered Oct 28 '22 at 12:50

I think in first You need to correctly parse data before you will append it to your array where you want to have it as a String or Int or any other type.

Below my solution for your problem:

lines = g.readlines()
for line in lines:
  x = line[2:].strip('').replace('  ', ' ').replace(',' , '').split(' ') // extract numbers from string assuming that first two characters are always characters that identify the data in a row
  for elem in x:
    if elem.isnumeric(): // append only elements that have numeric values
      i.append(int(elem))

How to remove the commas from string with no spaces for int conversion

3 Answers3