I have two dataframes that I want to combine by replicating every value from one DF to each row on the other, like the example below:
DataFrame 1:
| col 1 | col 2 |
|---|---|
| data 1 | value1 |
| data 2 | value2 |
DateFrame 2:
| col X | col Z |
|---|---|
| xxxx | 12345 |
| zzzz | 54321 |
| qqqq | 67890 |
What I want (end Result):
| col 1 | col 2 | col X | col Z |
|---|---|---|---|
| data 1 | value1 | xxxx | 12345 |
| data 1 | value1 | zzzz | 54321 |
| data 1 | value1 | qqqq | 67890 |
| data 2 | value2 | xxxx | 12345 |
| data 2 | value2 | zzzz | 54321 |
| data 2 | value2 | qqqq | 67890 |