Replacing few values in a pandas dataframe column with another value

by

The easiest way is to use the replace method on the column. The arguments are a list of the things you want to replace (here ['ABC', 'AB']) and what you want to replace them with (the string 'A' in this case):

>>> df['BrandName'].replace(['ABC', 'AB'], 'A')
0    A
1    B
2    A
3    D
4    A

This creates a new Series of values so you need to assign this new column to the correct column name:

df['BrandName'] = df['BrandName'].replace(['ABC', 'AB'], 'A')

More Related Contents:

  1. Renaming column names in Pandas
  2. How to replace text in a string column of a Pandas dataframe?
  3. replace() method not working on Pandas DataFrame
  4. Pandas: replace substring in string
  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. Filter pandas DataFrame by substring criteria
  11. Binning a column with Python Pandas
  12. Compare two DataFrames and output their differences side-by-side
  13. Selecting a row of pandas series/dataframe by integer index
  14. Shuffle DataFrame rows
  15. Remove duplicates from dataframe, based on two columns A,B, keeping row with max value in another column C
  16. Concatenate a list of pandas dataframes together
  17. How to drop duplicates based on two or more subsets criteria in Pandas data-frame
  18. NLTK-based text processing with pandas
  19. How to show all columns’ names on a large pandas dataframe?
  20. Shift column in pandas dataframe up by one?
  21. In Pandas, does .iloc method give a copy or view?
  22. Convert Pandas Series to DateTime in a DataFrame
  23. Python – Delete duplicates in a dataframe based on two columns combinations?
  24. Scraping dynamic data selenium – Unable to locate element
  25. Python Pandas: Convert “.value_counts” output to dataframe
  26. Remove substring from column based on another 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