| 611 | tm.assert_frame_equal(actual, expected) |
| 612 | |
| 613 | def test_merge_nosort(self): |
| 614 | # GH#2098 |
| 615 | |
| 616 | d = { |
| 617 | "var1": np.random.default_rng(2).integers(0, 10, size=10), |
| 618 | "var2": np.random.default_rng(2).integers(0, 10, size=10), |
| 619 | "var3": [ |
| 620 | datetime(2012, 1, 12), |
| 621 | datetime(2011, 2, 4), |
| 622 | datetime(2010, 2, 3), |
| 623 | datetime(2012, 1, 12), |
| 624 | datetime(2011, 2, 4), |
| 625 | datetime(2012, 4, 3), |
| 626 | datetime(2012, 3, 4), |
| 627 | datetime(2008, 5, 1), |
| 628 | datetime(2010, 2, 3), |
| 629 | datetime(2012, 2, 3), |
| 630 | ], |
| 631 | } |
| 632 | df = DataFrame.from_dict(d) |
| 633 | var3 = df.var3.unique() |
| 634 | var3 = np.sort(var3) |
| 635 | new = DataFrame.from_dict( |
| 636 | {"var3": var3, "var8": np.random.default_rng(2).random(7)} |
| 637 | ) |
| 638 | |
| 639 | result = df.merge(new, on="var3", sort=False) |
| 640 | exp = merge(df, new, on="var3", sort=False) |
| 641 | tm.assert_frame_equal(result, exp) |
| 642 | |
| 643 | assert (df.var3.unique() == result.var3.unique()).all() |
| 644 | |
| 645 | @pytest.mark.parametrize( |
| 646 | ("sort", "values"), [(False, [1, 1, 0, 1, 1]), (True, [0, 1, 1, 1, 1])] |