Load the data and create a DataFrame on 'sales' table.
>>> load_example_data("dataframe", "sales")
>>> import random >>> dfsales = DataFrame("sales")
>>> df = dfsales.assign(id = case([(df.accounts == 'Alpha Co', random.randrange(1, 9)), ... (df.accounts == 'Blue Inc', random.randrange(1, 9)), ... (df.accounts == 'Jones LLC', random.randrange(1, 9)), ... (df.accounts == 'Orange Inc', random.randrange(1, 9)), ... (df.accounts == 'Yellow Inc', random.randrange(1, 9)), ... (df.accounts == 'Red Inc', random.randrange(1, 9))])) >>>