How do i replace all instances of a dash (-) with the number zero (0) in the middle of a string in pandas dataframe?

Question

I have a column that has 5 numbers then a dash then another 5 numbers for example 44004-23323. I would like to remove that dash in the middle. I would like the output to be something like this 44004023323 I have tried this code below but its not working.

df['Lane'] = df['Lane'].apply(lambda x: "0" if x == "-" else x)

Can you post `df['Lane']` contents? – RomanPerekhrest Oct 25 '19 at 16:02 — RomanPerekhrest, Oct 25 '19 at 16:02

score 5 · Accepted Answer · answered Oct 25 '19 at 16:03

5

How about .str.replace()?

https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.replace.html

Pandas: replace substring in string

# see documentation for other parameters, such as regex and case
df['Lane'] = df['Lane'].str.replace('-', '0')

answered Oct 25 '19 at 16:03

user_stack_overflow

475
3
7

@JumaHamdan Is the dash always in the middle? This solution will replace all dashes anywhere in the string. – MonkeyZeus Oct 25 '19 at 17:16

score 2 · Answer 2 · answered Oct 25 '19 at 16:03

2

Try this

df['Lane'] = df['Lane'].apply(lambda x: str(x).replace('-','0'))

answered Oct 25 '19 at 16:03

Adam Zeldin

898
4
6

How do i replace all instances of a dash (-) with the number zero (0) in the middle of a string in pandas dataframe?

2 Answers2

Linked