Python: Slice String in a Pandas Dataframe

Question

I'm trying to modify unwanted part of a string in a DataFrame. E.g in column title_0, the value needs to be changed to "INC000000324540".

    title_0 
0   Your Group have a new ticket INC000000324540 please help our customer

The issue I had is the value isn't changed even after using string slice.

appended_df_INC['title_0'].str.slice(start=28, stop=44)

You should show us the code instead of the picture of the code and minimal reproducible example. — osbm
– osbm, Commented Apr 8, 2022 at 9:17

tia.milani · Accepted Answer · 2022-04-08 09:24:34Z

1

with that line you are not assigning the slice column to the original dataframe. The function returns the new column infact the notebook shows it. You have to assign the column to the original df, for example:

df = pd.DataFrame({"x": "LongStringNumber1", "LongStringNumber2"})
df["x"] = df["x"].str.slice(start=5, stop=10)

answered Apr 8, 2022 at 9:24

tia.milani

1381 silver badge5 bronze badges

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

Collectives™ on Stack Overflow

Python: Slice String in a Pandas Dataframe

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