CODEWITHSUNDEEP
pythonarrayspython-3.xstringinteger
noobiecoder
noobiecoder

Reputation: 17

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

enter image description here

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.

enter image description here

 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.

Upvotes: -1

Views: 207

Answers (3)

eRtuSa
eRtuSa

Reputation: 46

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))

Upvotes: 0

Mitul
Mitul

Reputation: 50

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

Upvotes: 0

Muzubul Rehman
Muzubul Rehman

Reputation: 95

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

Try this

Upvotes: 0

Related Questions