Replace all occurrences of a string in a pandas dataframe (Python)

by

You can use replace and pass the strings to find/replace as dictionary keys/items:

df.replace({'\n': '<br>'}, regex=True)

For example:

>>> df = pd.DataFrame({'a': ['1\n', '2\n', '3'], 'b': ['4\n', '5', '6\n']})
>>> df
   a    b
0  1\n  4\n
1  2\n  5
2  3    6\n

>>> df.replace({'\n': '<br>'}, regex=True)
   a      b
0  1<br>  4<br>
1  2<br>  5
2  3      6<br>

Note that this method returns a new DataFrame instance by default (it does not modify the original), so you’ll need to either reassign the output:

df = df.replace({'\n': '<br>'}, regex=True)

or specify inplace=True:

df.replace({'\n': '<br>'}, regex=True, inplace=True)

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. Pandas: replace substring in string
  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. How to drop rows of Pandas DataFrame whose value in a certain column is NaN
  11. Annotate bars with values on Pandas bar plots
  12. How to make separator in pandas read_csv more flexible wrt whitespace, for irregular separators?
  13. Why isn’t my Pandas ‘apply’ function referencing multiple columns working? [closed]
  14. Convert the string 2.90K to 2900 or 5.2M to 5200000 in pandas dataframe
  15. Conditionally fill column values based on another columns value in pandas
  16. python pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  17. Removing the timestamp from a datetime in pandas dataframe
  18. vectorize conditional assignment in pandas dataframe
  19. Pandas DataFrame merge summing column
  20. Binning a column with pandas
  21. How can I replicate rows of a Pandas DataFrame?
  22. How to get/set a pandas index column title or name?
  23. Python pandas integer YYYYMMDD to datetime
  24. Pandas: drop columns with all NaN’s
  25. In Python pandas, start row index from 1 instead of zero without creating additional column
  26. Calculate summary statistics of columns in dataframe
  27. Check if certain value is contained in a dataframe column in pandas [duplicate]
  28. Python: Adding hours to pandas timestamp
  29. Pandas: Join dataframe with condition
  30. UnicodeDecodeError when reading CSV file in Pandas

Leave a Comment