import numpy as np

import pandas as pd

from pandas import DataFrame, Series

import random

colors = ['white', 'black','silver']

engineTypes = ['diesel', 'petrol']

makes = ['ford', 'mazda', 'subaru']

years = range(2000,2005)

rowCount = 100

def randomEl(data):

rand_items = [data[random.randrange(len(data))] for item in range(rowCount)]

return rand_items

df = DataFrame({

'color': Series(randomEl(colors)),

'engineType': Series(randomEl(engineTypes)),

'make': Series(randomEl(makes)),

'year': Series(randomEl(years)),

'accidents': Series([int(1000*random.random()) for i in range(rowCount)])

})