Microsoft.Data.Analysis.DataFrame Join should produce a result with a single joined column

[olavt]

Given two DataFame objects it should be easy to perform a simple outer join to achieve these results:

DataFrame1:

Date	ClosePrice
3/1/2022 12:00:00 AM	10.5
3/2/2022 12:00:00 AM	12.4
3/3/2022 12:00:00 AM	11.3

DataFrame2:

Date	ShortPercent
3/1/2022 12:00:00 AM	2.34
3/2/2022 12:00:00 AM	2.36
3/3/2022 12:00:00 AM	3.01
3/4/2022 12:00:00 AM	3.04

Resulting DataFrame:

Date	ClosePrice	ShortPercent
3/1/2022 12:00:00 AM	10.5	2.34
3/2/2022 12:00:00 AM	12.4	2.36
3/3/2022 12:00:00 AM	11.3	3.01
3/4/2022 12:00:00 AM	null	3.04

This does not seem to be possible with the current Merge or Join methods, since they end up with two columns for Date (Date_left and Date_right) in the resulting DataFrame and combining those to a single column seems complex and error prone.

[michaelgsharp]

Thanks for pointing this out @olavt. This is the same issue that you and I were talking about right @luisquintanilla?

[luisquintanilla]

Thanks for pointing this out @olavt. This is the same issue that you and I were talking about right @luisquintanilla?

Yup. That's right. Related to #6128.

[Nils12345678901234567]

I would regard this as a bug, not an enhanment. The Merge and Join methods deos nor work as expected.

[gusmally]

I am surprised that this bug is still open-- this is basic functionality. Implementing this would go a long way in enabling developers to use DataFrames in C#!