id          time       event city
    A   2016/12/1   3:25     X    M
    A   2016/12/1   9:03     X    M
    A    2016/1/2   9:03     X    M
    A  2016/12/12   9:05     Y    M
    A    2016/1/1   9:34     Z    M
    B   2016/12/1   9:36     X    N
    B   2016/12/2  12:18     Y    N
    B   2016/12/2  12:58     X    N

id  X_num   X_day   Y_num   Y_day   Z_num   Z_day   X_Dec_day   city
A     3       2       1       1       1       1        1         M
B     2       2       1       1       0       0        2         N