How do I delete a text value from all observations in a column with Python?

Question

data looks like;

    day value
1    X1   52
2    X2   62
3    X3   44
4    X4   30
5    X9   10

I want to delete 'X' from all observations below the day variable in this dataset. So just keep the numbers. how can I do that?

Code for R= str.remove.all(data$day, "X")

what about python code for same operation?

https://stackoverflow.com/questions/13682044/remove-unwanted-parts-from-strings-in-a-column might be the answer youre looking for — Jason Chia, Nov 12 '19 at 16:44
Does this answer your question? [Edit csv column using python](https://stackoverflow.com/questions/47204277/edit-csv-column-using-python) — Mark, Nov 12 '19 at 18:26

score 0 · Answer 1 · answered Nov 12 '19 at 17:03

0

problem solved.thanks

 data['day'] =data['day'].map(lambda x: x.lstrip('X'))

answered Nov 12 '19 at 17:03

databenderr

1 Answers1