Pandas error when using if-else to create new column: The truth value of a Series is ambiguous

by

What about doing 

>>> df['C'] = np.where(df.B>0., df.A/df.B, 0.)

which reads as :

where df.B is strictly positive, return df.A/df.B, otherwise return 0.

More Related Contents:

  1. How to change the order of DataFrame columns?
  2. Split pandas dataframe based on groupby
  3. Add missing dates to pandas dataframe
  4. Fast punctuation removal with pandas
  5. pandas loc vs. iloc vs. at vs. iat?
  6. Pandas: sum DataFrame rows for given columns
  7. Skip rows during csv import pandas
  8. How to check if any value is NaN in a Pandas DataFrame
  9. How to drop rows from pandas data frame that contains a particular string in a particular column? [duplicate]
  10. pandas dataframe groupby datetime month
  11. Find the end of the month of a Pandas DataFrame Series
  12. vlookup in Pandas using join
  13. Vectorised Haversine formula with a pandas dataframe
  14. Read a small random sample from a big CSV file into a Python data frame
  15. How to concatenate two dataframes without duplicates?
  16. Most efficient way to forward-fill NaN values in numpy array
  17. Memory error when using pandas read_csv
  18. Python Pandas replicate rows in dataframe
  19. Efficiently create sparse pivot tables in pandas?
  20. Can’t drop NAN with dropna in pandas
  21. Legend only shows one label when plotting with pandas
  22. How to remove or hide x-axis labels from a seaborn / matplotlib plot
  23. Computing np.diff in Pandas after using groupby leads to unexpected result
  24. Remove NaN ‘Cells’ without dropping the entire ROW (Pandas,Python3)
  25. How to read a list of parquet files from S3 as a pandas dataframe using pyarrow?
  26. Error: The truth value of a Series is ambiguous – Python pandas
  27. Is it possible to add a string as a legend item in matplotlib
  28. Pivot Tables of Counts in Pandas DataFrame
  29. append dictionary to data frame
  30. ValueError: Shape of passed values is (1, 6), indices imply (6, 6)

Leave a Comment