| 256 | assert len(merged2) == 0 |
| 257 | |
| 258 | def test_join_on_inner(self): |
| 259 | df = DataFrame({"key": ["a", "a", "d", "b", "b", "c"]}) |
| 260 | df2 = DataFrame({"value": [0, 1]}, index=["a", "b"]) |
| 261 | |
| 262 | joined = df.join(df2, on="key", how="inner") |
| 263 | |
| 264 | expected = df.join(df2, on="key") |
| 265 | expected = expected[expected["value"].notna()] |
| 266 | tm.assert_series_equal(joined["key"], expected["key"]) |
| 267 | tm.assert_series_equal(joined["value"], expected["value"], check_dtype=False) |
| 268 | tm.assert_index_equal(joined.index, expected.index) |
| 269 | |
| 270 | def test_join_on_singlekey_list(self): |
| 271 | df = DataFrame({"key": ["a", "a", "b", "b", "c"]}) |