Resolve left_join

Resolves any duplicate columns that results after left_join due to shared columns between data frames. Rule: Keeps old values if all newly joined values are NA. Keeps new values otherwise (even if some entries are empty)

Usage

resolve_join(df)

Arguments

df

data frame with duplicate columns ending in .x and .y

Value

data frame with one remaining column for duplicates