Modifying a subset of rows in a pandas dataframe

by

Use .loc for label based indexing:

df.loc[df.A==0, 'B'] = np.nan

The df.A==0 expression creates a boolean series that indexes the rows, 'B' selects the column. You can also use this to transform a subset of a column, e.g.:

df.loc[df.A==0, 'B'] = df.loc[df.A==0, 'B'] / 2

I don’t know enough about pandas internals to know exactly why that works, but the basic issue is that sometimes indexing into a DataFrame returns a copy of the result, and sometimes it returns a view on the original object. According to documentation here, this behavior depends on the underlying numpy behavior. I’ve found that accessing everything in one operation (rather than [one][two]) is more likely to work for setting.

More Related Contents:

  1. How to deal with SettingWithCopyWarning in Pandas
  2. GroupBy results to dictionary of lists
  3. Pandas timeseries plot setting x-axis major and minor ticks and labels
  4. How to remove nan value while combining two column in Panda Data frame?
  5. Restart cumsum and get index if cumsum more than value
  6. Remove non-numeric rows in one column with pandas
  7. How to deal with multi-level column names downloaded with yfinance
  8. Replace all occurrences of a string in a pandas dataframe (Python)
  9. Running get_dummies on several DataFrame columns?
  10. ValueError: numpy.dtype has the wrong size, try recompiling
  11. Add months to a date in Pandas
  12. How to add an empty column to a dataframe?
  13. Pandas reading csv as string type
  14. python pandas dataframe, is it pass-by-value or pass-by-reference
  15. Convert pandas DateTimeIndex to Unix Time?
  16. pandas dataframe select columns in multiindex [duplicate]
  17. Selecting/excluding sets of columns in pandas [duplicate]
  18. pandas distinction between str and object types
  19. pandas filtering and comparing dates
  20. pandas group by and find first non null value for all columns
  21. Reverse a get_dummies encoding in pandas
  22. Seaborn Bar Plot Ordering
  23. pandas divide row value by aggregated sum with a condition set by other cell
  24. Updating a value in a pandas dataframe in an iterrows loop
  25. Python Pandas – Read csv file containing multiple tables
  26. Normalize DataFrame by group
  27. Color a scatter plot by Column Values
  28. pandas extract year from datetime: df[‘year’] = df[‘date’].year is not working
  29. pandas.read_csv FileNotFoundError: File b’\xe2\x80\xaa’ despite correct path
  30. Pandas: Selecting rows based on value counts of a particular column

Leave a Comment