Combine two DataFrames that duplicate data

Asked Jan 22 '18 at 18:35

Active Jan 22 '18 at 18:56

Viewed 38 times

edited as previous question was not clear enough

I want to combine two DataFrames with no overlapping data, and just duplicate the data for each record.

letters = [['a', 'b', 'c'], ['d', 'e', 'f']]

numbers = [[1, 2, 3], [4, 5, 6]]

letters = pd.DataFrame(letters)
    0  1  2
0   a  b  c
1   d  e  f


numbers = pd.DataFrame(numbers)
    0  1  2
0   1  2  3
1   4  5  6

I want to combine these two DataFrames to look like this.

a b c 1 2 3
a b c 4 5 6
d e f 1 2 3
d e f 4 5 6

I've tried all of the join types ('inner', 'outer, etc), merges, and concats that I'm familiar with.

edited Jan 22 '18 at 18:50

asked Jan 22 '18 at 18:35

ac2001

Are they single column DataFrames? – ayhan Jan 22 '18 at 18:38
No, they are multi-column – ac2001 Jan 22 '18 at 18:41
So what happens to the other columns? From which DataFrame do they take the values? – ayhan Jan 22 '18 at 18:43
i wanted them to duplicate as well. I will edit the question - it was not clear enough. – ac2001 Jan 22 '18 at 18:44
You may want to checkout [how to create a good example](https://stackoverflow.com/help/mcve) in order to get good responses. – Alex Jan 22 '18 at 18:47
3

ayhan - thanks for pointing out this cartesian product example (I did not know what to search for). I will take a look. – ac2001 Jan 22 '18 at 18:55

Combine two DataFrames that duplicate data

0 Answers0