Suggestions For Adding Values To Sub-Strings With Python

Question

I am looking for suggestions as to how to get python to convert an empty space within a sub-string to a dash (-).

In the below dataframe column A has the raw data and need to add a dash to the sub-strings that have a space in them to get column B

Any suggestions how to overcome this?

df.A.str.replace(' ','-') is what you want

anky
– anky

2019-04-25 16:10:32 +00:00
Commented Apr 25, 2019 at 16:10 — anky
– anky, Commented Apr 25, 2019 at 16:10

Sash Sinha · Accepted Answer · 2019-04-25 16:19:20Z

2

How about replace:

>>> import pandas as pd
>>> df = pd.DataFrame(data={'A': ['ADMCAP B', 'ATHENA', 'ATLA DKK', 'BNORDIK CSE']})
>>> df
             A
0     ADMCAP B
1       ATHENA
2     ATLA DKK
3  BNORDIK CSE
>>> df['B'] = df['A'].replace(' ', '-', regex=True)
>>> df
             A            B
0     ADMCAP B     ADMCAP-B
1       ATHENA       ATHENA
2     ATLA DKK     ATLA-DKK
3  BNORDIK CSE  BNORDIK-CSE

Or you could use: df['B'] = df['A'].str.replace(' ', '-')

answered Apr 25, 2019 at 16:19

Sash Sinha

22.8k4 gold badges27 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Suggestions For Adding Values To Sub-Strings With Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related