df = pd.DataFrame(d)
df.head()
df_new = df.groupby('date').ts.apply(lambda x: pd.DataFrame(x.values[0])
    ).reset_index().drop('level_1', axis=1)
df_new.columns = ['date', 'ts']
df_new.head()
Splitting a List inside a Pandas DataFrame