Here we have some "Neutral" values that we want to coalesce :
https://stackoverflow.com/questions/74523813/is-there-any-command-to-merge-dataframes-with-different-values-in-a-specific-col
I suspect that there are some more use cases with values coded as 0, -1, Inf etc.
It's a bit more tricky than replacing those with NAs, because if "Neutral" is coalesced with "Neutral" or with "NA" I believe the result should be "Neutral".
Should NAs always be overriden when possible or are they just a normal value that happens to be the default ?
Probably it's always overriden, no need to over engineer since rare cases can always be solved with a bit more data wrangling
Here we have some "Neutral" values that we want to coalesce :
https://stackoverflow.com/questions/74523813/is-there-any-command-to-merge-dataframes-with-different-values-in-a-specific-col
I suspect that there are some more use cases with values coded as
0,-1,Infetc.It's a bit more tricky than replacing those with NAs, because if "Neutral" is coalesced with "Neutral" or with "NA" I believe the result should be "Neutral".
Should NAs always be overriden when possible or are they just a normal value that happens to be the default ?
Probably it's always overriden, no need to over engineer since rare cases can always be solved with a bit more data wrangling