Remove substring from column based on another column

by

So, I tried this and it worked pretty well:

dfTest['bar'] = dfTest.apply(lambda row : row['foo'].replace(str(row['date']), ''), axis=1)

More Related Contents:

  1. How do I select rows from a DataFrame based on column values?
  2. Filter pandas DataFrame by substring criteria
  3. Binning a column with Python Pandas
  4. Aggregation in Pandas
  5. Compare two DataFrames and output their differences side-by-side
  6. Constructing pandas DataFrame from values in variables gives “ValueError: If using all scalar values, you must pass an index”
  7. Can pandas automatically read dates from a CSV file?
  8. Selecting a row of pandas series/dataframe by integer index
  9. pandas dataframe str.contains() AND operation
  10. How do I find the closest values in a Pandas series to an input number?
  11. How do I count the NaN values in a column in pandas DataFrame?
  12. getting the index of a row in a pandas apply function
  13. How to flatten a pandas dataframe with some columns as json?
  14. Tilde sign in pandas DataFrame
  15. Drop columns whose name contains a specific string from pandas DataFrame
  16. Find the unique values in a column and then sort them
  17. how do I calculate a rolling idxmax
  18. Python Pandas How to assign groupby operation results back to columns in parent dataframe?
  19. Pandas won’t fillna() inplace
  20. python Pandas DataFrame copy(deep=False) vs copy(deep=True) vs ‘=’
  21. From password-protected Excel file to pandas DataFrame
  22. How can repetitive rows of data be collected in a single row in pandas?
  23. FastAPI is very slow in returning a large amount of JSON data
  24. Python pandas: how to remove nan and -inf values
  25. Filtering pandas dataframe with multiple Boolean columns
  26. Pandas: Incrementally count occurrences in a column
  27. Python: How to drop a row whose particular column is empty/NaN?
  28. Combine Pandas data frame column values into new column
  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