merge() with how="cross" does not work #8119
Description
What happened:
Running dd.merge(left, right, how="cross") fails with
MergeError: Can not pass on, right_on, left_on or set right_index=True or left_index=True
What you expected to happen:
Minimal Complete Verifiable Example:
left = pd.DataFrame(
{
"key": ["K0", "K1", "K2", "K3"],
"A": ["A0", "A1", "A2", "A3"],
"B": ["B0", "B1", "B2", "B3"],
}
)
right = pd.DataFrame(
{
"key": ["K0", "K1", "K2", "K3"],
"A": ["C0", "C1", "C2", "C3"],
"B": ["D0", "D1", "D2", "D3"],
}
)
dd.merge(left, right, how="cross")Anything else we need to know?:
Environment:
- Dask version: '2021.09.0'
- Python version: 3.7.10
- Operating System: MacOS
- Install method (conda, pip, source): pip