title: Python: How to update a value in Google BigQuery in less than 40 seconds?
body: <p>I have a table in <code>Google BigQuery</code> that I access and modify in Python using the <code>pandas</code> functions <code>read_gbq</code> and <code>to_gbq</code>. The problem is that appending 100,000 lines takes about 150 seconds while appending 1 line takes about 40 seconds. I would like to update a value in the table rather than append a line, is there a way to update a value in the table using python that is very fast, or faster than 40 seconds?</p>