Delete Dynamic column values in Excel Sheet +Numpy

Asked Jan 06 '19 at 16:09

Active Jan 06 '19 at 16:09

Viewed 16 times

Delete Dynamic values from rows in Excel sheet with Numpy

I tried using Numpy to delete

df['Requirement'].replace([',,',','], " ", inplace=True)

DS  Requirement
L1      ,,
L2      ,
L3      ,,,
L4      ,,,,

I have a above excel sheet and converting to DF, So using Numpy I am able to replace all the column values which are (Single Comma , double comma, Triple Comma and So on). Basically I want to make all the column values which having commas. Its all dynamic because it can be 1 comma or N number of comma's

Not getting any idea how to dynamically remove comma from column values.

Can anyone share some idea or I should go with manually check and make empty all desired column values?

asked Jan 06 '19 at 16:09

Sandy

`df['Requirement'] = df['Requirement'].replace([',,',','], " ", regex=True)` – cs95 Jan 06 '19 at 16:11
Or better, just do `df.Requirement = df.Requirement.str.replace(',', '')` – cs95 Jan 06 '19 at 16:22
Nailed it!!!!!! – Sandy Jan 06 '19 at 17:30
You're welcome, do consider upvoting the posts at https://stackoverflow.com/questions/50444346/fast-punctuation-removal-with-pandas because the same information is essentially there. Thanks :) – cs95 Jan 06 '19 at 17:32
Sure..Upvote..I liked regex=True. – Sandy Jan 07 '19 at 05:10

Delete Dynamic column values in Excel Sheet +Numpy

0 Answers0