application_vnd.jupyter.stderr_output_1.png
from plotly.offline import iplot, init_notebook_mode

import advertools as adv

import pandas as pd

import advertools as adv
import pandas as pd
pd.options.display.max_columns = None
from plotly.tools import make_subplots
import plotly.graph_objs as go
from plotly.offline import iplot, init_notebook_mode
init_notebook_mode()
adv.__version__

column_key = pd.read_csv('../input/column_key.csv')
column_key

clubs = pd.read_csv('../input/clubs.csv')

serp_clubs = pd.read_csv('../input/serp_clubs.csv')
serp_clubs['totalResults'] = serp_clubs['totalResults'].astype('int')
serp_clubs['queryTime'] = pd.to_datetime(serp_clubs['queryTime'])

serp_clubs['displayLink'].value_counts()[:10]