Search code examples
pythonpandasseries

How to cross join (cartesian product) two Series?

Consider the following two series.

Let x be:

x
a   10
b   20
c   30
Name: x_value

And let y be:

y
d   100
e   200
Name: y_value

Ideally, the result would have a MultiIndex along with the cartesian product of the series' cross values:


      x_value y_value
x  y
a  d    10      100
   e    10      200
b  d    20      100
   e    20      200
c  d    30      100
   e    30      200

I have seen similar questions (e.g. cartesian product in pandas) about cross merge, but I haven't found anything about Series so far (let alone a MultiIndex of initial indices approach).

The part that seems troublesome to me is how I'd get to work with Series, instead of DataFrames.

Solution

  • pd.merge() works on Series, but it doesn't keep the index.

    df = pd.merge(x, y, how='cross')
df

       x_value  y_value
0       10      100
1       10      200
2       20      100
3       20      200
4       30      100
5       30      200

    You can just make the MultiIndex yourself:

    df.index = pd.MultiIndex.from_product([x.index, y.index], names=['x', 'y'])
df

         x_value  y_value
x y                  
a d       10      100
  e       10      200
b d       20      100
  e       20      200
c d       30      100
  e       30      200