CODEWITHSUNDEEP
pythonpandasdataframe
Rivendel
Rivendel

Reputation: 31

Removing the first and only the first '-' in the values of a string column

               1          2
0    ADRC-111-01    ADRC111
1  ADRC-11955-01  ADRC11955
2  ADRC-18133-01  ADRC18133
3    SWAN0023-03   SWAN0023

In Column 1, I wish to get rid of the first - sign, regardless of how many are in the the cell. There are one or two - in each entry.

Desired output:

              1          2
0    ADRC111-01    ADRC111
1  ADRC11955-01  ADRC11955
2  ADRC18133-01  ADRC18133
3    SWAN002303   SWAN0023

Upvotes: 0

Views: 49

Answers (1)

user17242583
user17242583

Reputation:

Use .str.replace with n=1:

df['1'] = df['1'].str.replace('-', '', n=1)

Output:

>>> df
              1          2
0    ADRC111-01    ADRC111
1  ADRC11955-01  ADRC11955
2  ADRC18133-01  ADRC18133
3    SWAN002303   SWAN0023

Upvotes: 2

Related Questions