pdeffebach

Stata has a good API for this via `update` > `update`: update missing values of same-named variables in master with values from using I think Bogumil's idea for this is...

> * duplicate entries in `df2` are present? Throw an error? Interestingly, this will add *both* observations ``` . use df_completion_dups, clear . list +----------+ | id val | |----------|...

Thanks. I will try and work on a proposal that is similar to stata but matches our current infrastructure. This is yet another opportunity to combine the best of stata...

I think another function might be best. Since I was also going to bring up that not only does Stata have an `update` option, it also has a `replace` option....

One only replaces if `missing`, the other overwrites the whole columns. Maybe they could be the same function, though.

Actually, I've just thought of a problem with this approach. Lets say you have df1 and df2 where df2 has many *new* columns you are interested `:age, :marital_status` but also...

In Stata terms this is the `keepusing` keyword argument, where you choose to `keep` certain variables from the `using` (RHS) data set. I'm not sure I totally agree with the...

I'll try this out in my next project and let you know what I think!

Modifying PrettyTables to have multi-column headers is very high on my wishlist of data utilities, particularly for latex, which may be the easiest case.

Just a comment on the API here, I would like as may keyword arguments as possible instead of positional arguments. Given all arguments will be the same type (column selectors)...