How to implement sql coalesce in pandas

by

Another way is to explicitly fill column D with A,B,C in that order.

df['D'] = np.nan
df['D'] = df.D.fillna(df.A).fillna(df.B).fillna(df.C)

More Related Contents:

  1. How to write this code without using pandas?
  2. How to plot in multiple subplots
  3. Faster way to read Excel files to pandas dataframe
  4. How to reversibly store and load a Pandas dataframe to/from disk
  5. Format y axis as percent
  6. float64 with pandas to_csv
  7. How do I transpose dataframe in pandas without index?
  8. How to select all columns whose names start with X in a pandas DataFrame
  9. Why does pandas apply calculate twice
  10. pandas or python equivalent of tidyr complete
  11. pandas replace multiple values one column
  12. Matplotlib – fixing x axis scale and autoscale y axis
  13. Extracting specific selected columns to new DataFrame as a copy
  14. Get pandas.read_csv to read empty values as empty string instead of nan
  15. Custom transformer for sklearn Pipeline that alters both X and y
  16. Pandas join/merge/concat two dataframes
  17. Assign pandas dataframe column dtypes
  18. pandas replace zeros with previous non zero value
  19. How do I make the width of the title box span the entire plot?
  20. Renaming columns in a Pandas dataframe with duplicate column names?
  21. Ranking order per group in Pandas
  22. How to edit properties of whiskers, fliers, caps, etc. in Seaborn boxplot
  23. Convert list into a pandas dataframe
  24. Change main plot legend label text
  25. How to determine whether a column/variable is numeric or not in Pandas/NumPy?
  26. Python Pandas: Convert “.value_counts” output to dataframe
  27. What are the pros and cons between get_dummies (Pandas) and OneHotEncoder (Scikit-learn)?
  28. Can you format pandas integers for display, like `pd.options.display.float_format` for floats?
  29. computing the mean for python datetime
  30. Pandas explode multiple columns [duplicate]

Leave a Comment