Open an AI platform jupyter notebook and load the invoices and vendors data from big query in to separate pandas dataframes.

1. From the invoices dataframe, display the invoice_id, invoice_total and vendor_id columns from records where the invoice_total is less than 100 dollars

2. Join the invoices and vendors dataframes and then group by based on vendor_state and vendor_city and provide sum of invoice_total per vendor_state and vendor_city.

Hint use groupby(['vendor_state', 'vendor_city'])