How to delete some value in string columns python

Question

How can I delete this number in my "Kecamatan" Columns

Please do not link or embed external images of source code or data. Images make it difficult to efficiently assist you as they cannot be copied and offer poor usability as they cannot be searched. See: Why not upload images of code/errors when asking a question? If you need assistance formatting a small sample of your DataFrame as a copyable piece of code for SO see How to make good reproducible pandas examples. — Henry Ecker
– Henry Ecker ♦, Commented Mar 2, 2022 at 4:05

Park · Accepted Answer · 2022-02-18 01:00:43Z

1

You can replace the leading digits and dot using regular expression, as follows:

import pandas as pd

df = pd.DataFrame({
    'Kecamatan': ['010. Donomulyo', '020. Kalipare', '030. Pagak', '040. Bankur']
})

df['Kecamatan'] = df['Kecamatan'].str.replace(r'\A[0-9. ]+', '', regex=True)

print(df)

>>>df
   Kecamatan
0  Donomulyo
1   Kalipare
2      Pagak
3     Bankur

answered Feb 18, 2022 at 1:00

Park

2,5441 gold badge19 silver badges25 bronze badges

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

Collectives™ on Stack Overflow

How to delete some value in string columns python

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related