Pandas: replace substring in string

by

Use replace with dict for replacing and regex=True:

df['url'] = df['url'].replace({'icashier.alipay.com': 'aliexpress.com'}, regex=True)
print (df)
                                          url
0  aliexpress.com/catalog/2758186/detail.aspx
1  aliexpress.com/catalog/2758186/detail.aspx
2  aliexpress.com/catalog/2758186/detail.aspx
3                                      vk.com

More Related Contents:

  1. Renaming column names in Pandas
  2. How to replace text in a string column of a Pandas dataframe?
  3. Replacing few values in a pandas dataframe column with another value
  4. replace() method not working on Pandas DataFrame
  5. Replace all occurrences of a string in a pandas dataframe (Python)
  6. Removing prefix from column names in Pandas
  7. How to replace negative numbers in Pandas Data Frame by zero
  8. Replace invalid values with None in Pandas DataFrame
  9. Efficiently replace values from a column to another column Pandas DataFrame
  10. Pandas conditional creation of a series/dataframe column
  11. Truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
  12. How to unnest (explode) a column in a pandas DataFrame, into multiple rows
  13. Remove unwanted parts from strings in a column
  14. Comparing two dataframes and getting the differences [duplicate]
  15. set difference for pandas
  16. Nested dictionary to multiindex dataframe where dictionary keys are column labels
  17. Python pandas: how to specify data types when reading an Excel file?
  18. Pandas filling missing dates and values within group
  19. Use groupby in Pandas to count things in one column in comparison to another
  20. How can I remove all non-numeric characters from all the values in a particular column in pandas dataframe?
  21. Combining two Series into a DataFrame in pandas
  22. pandas unique values multiple columns
  23. How to find which columns contain any NaN value in Pandas dataframe
  24. Converting a column within pandas dataframe from int to string
  25. Pandas – dataframe groupby – how to get sum of multiple columns
  26. pandas: combine two columns in a DataFrame
  27. Pandas query function not working with spaces in column names
  28. Remove NaN values from pandas dataframe and reshape table [duplicate]
  29. DataFrame object has no attribute append
  30. Python Pandas : pandas.to_datetime() is switching day & month when day is less than 13

Leave a Comment