Modifying Dataframe column value

Question

I have my pandas dataframe contain data in the following format:

SAC1001.K
KAM10120.B01.W001
CLT004.09C
ASMA104
AJAY101.A.KAS.101

I wish to modify the column using string manipulation so, that the result is

SAC1001.K
KAM10120.B01
CLT004.09C
ASMA104
AJAY101.A

How this can be done? Regex looks to be one way but, not sure of it. Any other elegant way to do it? Please guide

MaxU - stand with Ukraine · Accepted Answer · 2017-08-10 19:22:38Z

2

In [109]: df
Out[109]:
                 col
0          SAC1001.K
1  KAM10120.B01.W001
2         CLT004.09C
3            ASMA104
4  AJAY101.A.KAS.101

In [110]: df['col'] = df['col'].str.replace(r'(\..*?)\..*', r'\1')

In [111]: df
Out[111]:
            col
0     SAC1001.K
1  KAM10120.B01
2    CLT004.09C
3       ASMA104
4     AJAY101.A

answered Aug 10, 2017 at 19:22

MaxU - stand with Ukraine

212k37 gold badges402 silver badges436 bronze badges

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

Comments

Mr Tarsa · Accepted Answer · 2017-08-10 19:34:34Z

1

Here is another way without regex but maybe with too many str

df['col'].str.split('.').str[:2].str.join('.')

answered Aug 10, 2017 at 19:34

Mr Tarsa

6,6613 gold badges29 silver badges45 bronze badges

Collectives™ on Stack Overflow

Modifying Dataframe column value

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related