python script

I need a python script which fetch data from google big query, then load it in to a data frame, loop through a json file and do some simple matching (if table x contains Y then create a new column with a yes value for matching) After we have the matching result I want to write it back to a new column in Big Query.