Thanks for stopping by to let us know something could be better!

PLEASE READ: If you have a support contract with Google, please create an issue in the support console instead of filing on GitHub. This will ensure a timely response.

Please run down the following list and make sure you've tried the usual "quick fixes":

• Search the issues already opened: https://github.com/googleapis/python-bigquery-dataframes/issues
• Search StackOverflow: https://stackoverflow.com/questions/tagged/google-cloud-platform+python

If you are still having issues, please be sure to include as much information as possible:

Environment details

• OS type and version:
• Python version: python --version
• pip version: pip --version
• bigframes version: pip show bigframes

Steps to reproduce

1. ?
2. ?

Code example

df = bpd.read_gbq("select gameId, year, homeTeamName, awayTeamName, duration_minutes from bigquery-public-data.baseball.schedules")
df1 = df[df["homeTeamName"] == "Rays"]
df2 = df[df["homeTeamName"] == "White Sox"]
df3 = df1.merge(df2, on=["awayTeamName"], how="inner")
df3.shape # return wrong result (0, 9), correct result is (302, 9)

Stack trace

# example

Making sure to follow these steps will guarantee the quickest resolution possible.

Thanks!