Product Team Enterprise Explore Marketplace Pricing Search Sign in Sign up pyjanitor-devs pyjanitor Public Notifications Fork 139 Star 849 Code Issues 100 82 Pull requests Discussions Actions Projects Wiki Secunty Insights [ENH] Coalesce fix #1042 New issue 8 Merged ericmjl merged commits into dev from coalesce_fix 12 hours ago Conversation Commits Checks Files changed +20 -13 Changes from all commits File filter Conversations Jump to janitor/functions/coalesce.py 17,14 +17,18 06 def coalesce( pd . DataFrame Coalesce cwo more columns data order column names provided _ Given the list column names, coalesce finds and returns the first non-missing value from these columns for every row in the input dataframe all che column values are null for particular row, then the default value will filled Given the variable arguments column names coalesce finds and returns the first non-missing value from these columns for every row in the input dataframe all che column values are null for particular row, then the default value Will be filled target column name not provided, then the first column coalesced This method does not mutate the original DataFrame Example: Using coalesce with columns_ "a" "b" and Example: Use coalesce with columns "a" and 77> import pandas 77> import numpy as