where, groupby, normalized date, encoding