TypeError: from_arrays() when converting BigQuery to pandas df

Question

I am trying to convert the data that I am fetching from BigQuery into pandas dataframe. My code looks like this:

os.environ["GOOGLE_APPLICATION_CREDENTIALS"]="/Users/Me/Documents/credentials/google_creds.json"

# Establish the client
client = bigquery.Client(

query = """select * from bq_project.bq_table"""
df = client.query(query).to_dataframe()

This is the error: TypeError: from_arrays() takes at least 2 positional arguments (1 given) It errors out on df = client.query(query).to_dataframe() line.

Chique_Code · Accepted Answer · 2021-03-02 15:07:43Z

1

pip install --upgrade pyarrow then reloading jupyter notebook has solved the issue.

answered Mar 2, 2021 at 15:07

Chique_Code

1,5506 gold badges31 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kate Dildy · Accepted Answer · 2021-07-14 23:16:21Z

1

If you use conda for your other downloads, you can also use conda install pyarrow -c conda-forge per the PyPi documentation of the pyarrow package.

Also make sure to restart your kernel!

answered Jul 14, 2021 at 23:16

Kate Dildy

111 bronze badge

Collectives™ on Stack Overflow

TypeError: from_arrays() when converting BigQuery to pandas df

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related