delete particular string values in the column

Question

I have column which contains 4000 unique values(rows). I want to delete values such as 'I__ND_LD(1),I__ND_LD(2),P__ND_LN(1),I__XF_XF(4)'.these values are unique in numbers in the brackets. for example. 'I__ND_LD(1) starts with 1 and end with 'I__ND_LD(70).

By this code,I can remove only one character using above function. I want to remove all the values as mentioned in the problem.

eda[~eda.Devices.str.Contains("^I__ND_LD(1)")]

Is there any other technique through which i can remove all these values, also we have different number of 'I__ND_LD' and 'P__ND_LN(1). I want to implement this in the function so that I can just pass the values and it delete all the values in the column.

Vishnudev Krishnadas · Answer 1 · 2019-09-05T19:31:53.330

1

to_remove = ['abc\(\d+\)', 'bca']
eda[~eda.devices.str.contains('|'.join(to_remove), regex=True)]

edited Sep 05 '19 at 19:31

answered Sep 05 '19 at 19:22

Vishnudev Krishnadas

10,679
2
23
55

I can remove single value using this. i have like abc(1),abc(2) tilll abc(70) and something like withe bca as well. – anmol Sep 05 '19 at 19:30
Use regex in the list, something like the updated answer @anmol – Vishnudev Krishnadas Sep 05 '19 at 19:32
It would be specific in your case and I can't tell you directly. If you need regex assistance the check this [link](https://stackoverflow.com/questions/22937618/reference-what-does-this-regex-mean). – Vishnudev Krishnadas Sep 05 '19 at 19:39

delete particular string values in the column

1 Answers1