Conditional Replace Pandas

by

.ix indexer works okay for pandas version prior to 0.20.0, but since pandas 0.20.0, the .ix indexer is deprecated, so you should avoid using it. Instead, you can use .loc or iloc indexers. You can solve this problem by:

mask = df.my_channel > 20000
column_name="my_channel"
df.loc[mask, column_name] = 0

Or, in one line,

df.loc[df.my_channel > 20000, 'my_channel'] = 0

mask helps you to select the rows in which df.my_channel > 20000 is True, while df.loc[mask, column_name] = 0 sets the value 0 to the selected rows where maskholds in the column which name is column_name.

Update:
In this case, you should use loc because if you use iloc, you will get a NotImplementedError telling you that iLocation based boolean indexing on an integer type is not available.

More Related Contents:

  1. How to convert index of a pandas dataframe into a column
  2. Pandas filtering for multiple substrings in series
  3. Keep only date part when using pandas.to_datetime
  4. Strings in a DataFrame, but dtype is object
  5. How to replace text in a string column of a Pandas dataframe?
  6. Replace all elements of Python NumPy Array that are greater than some value
  7. Pandas: convert categories to numbers
  8. Replacing few values in a pandas dataframe column with another value
  9. replace() method not working on Pandas DataFrame
  10. df.append() is not appending to the DataFrame
  11. How to do/workaround a conditional join in python Pandas?
  12. Replace all occurrences of a string in a pandas dataframe (Python)
  13. Combining two Series into a DataFrame in pandas
  14. How to replace negative numbers in Pandas Data Frame by zero
  15. Replace invalid values with None in Pandas DataFrame
  16. pandas replace multiple values one column
  17. how do I calculate a rolling idxmax
  18. Convert pandas data frame to series
  19. Finding the intersection between two series in Pandas
  20. What is the fastest and most efficient way to append rows to a DataFrame?
  21. pandas: replace string with another string
  22. Compute the running (cumulative) maximum for a series in pandas
  23. How do I assign values based on multiple conditions for existing columns?
  24. Set value of one Pandas column based on value in another column
  25. Getting a list of indices where pandas boolean series is True
  26. How to specify the type of pandas series elements in type hints?
  27. Python Pandas iterate over rows and access column names
  28. Why does max() sometimes return nan and sometimes ignores it?
  29. Pandas: Join dataframe with condition
  30. Sorting a pandas series

Leave a Comment