#@title Python setup {form-width: "20%"}
from colabtools import f1, dremel, adhoc_import
from typing import Any, Text
from IPython.display import display

import numpy as np
import os
import pandas as pd
import warnings
import altair as alt
import matplotlib.pyplot as plt
import seaborn as sns
alt.data_transformers.enable('default', max_rows=None)
from tqdm import tqdm
from google3.pyglib import gfile
from google3.research.colab.lib import tabbar
from google3.analysis.common.pandas import capacitor
fix_ipython.set_message_size_limit(1e14) # 200 MB
from colabtools import interactive_table
interactive_table.DEFAULT_MAX_COLUMNS = 200
interactive_table.DEFAULT_MAX_ROWS = 530000
dremel.SetMinCompletionRatio(1.0)
dremel.SetLanguage('GoogleSQL')
dremel.SetAccountingGroup('ads-search-conversion-modeling')
dremel.SetMaterializeOwnerGroup('ads-search-conversion-modeling');
dremel.SetMaterializeOverwrite(1);
import plotnine as p9
pd.options.display.float_format = '{:,.2f}'.format
alt.data_transformers.enable('default', max_rows=None)
from google.colab.data_table import DataTable
DataTable.max_columns = 50