Kaggle Talking Data用户行为分析

July 21 2016

首先看任选一个用户,查看其行为轨迹

mysql> select * from events where device_id = '29182687948017175' order by timestamp;
+----------+-------------------+---------------------+-----------+----------+
| event_id | device_id         | timestamp           | longitude | latitude |
+----------+-------------------+---------------------+-----------+----------+
|  1491059 | 29182687948017175 | 2016-05-01 00:17:33 | 121.38    | 31.24    |
................
|  2258465 | 29182687948017175 | 2016-05-01 08:50:45 | 121.38    | 31.24    |
|  2773333 | 29182687948017175 | 2016-05-01 09:05:09 | 0.00      | 0.00     |
|   406579 | 29182687948017175 | 2016-05-01 09:05:22 | 121.38    | 31.24    |
|  1533091 | 29182687948017175 | 2016-05-01 10:01:15 | 121.38    | 31.24    |
|   627197 | 29182687948017175 | 2016-05-01 10:07:38 | 0.00      | 0.00     |
|  1963736 | 29182687948017175 | 2016-05-01 10:22:34 | 121.38    | 31.24    |
|   627207 | 29182687948017175 | 2016-05-01 10:32:27 | 121.38    | 31.24    |
|  1577612 | 29182687948017175 | 2016-05-01 11:22:17 | 0.00      | 0.00     |
|   552018 | 29182687948017175 | 2016-05-01 14:30:34 | 0.00      | 0.00     |
|  2671602 | 29182687948017175 | 2016-05-01 17:58:19 | 121.38    | 31.24    |
.....................
|  1134324 | 29182687948017175 | 2016-05-03 02:59:26 | 121.39    | 31.24    |
|   217601 | 29182687948017175 | 2016-05-03 06:55:14 | 0.00      | 0.00     |
|  1137651 | 29182687948017175 | 2016-05-03 06:58:10 | 0.00      | 0.00     |
|   785639 | 29182687948017175 | 2016-05-03 07:09:42 | 121.38    | 31.24    |
|   687909 | 29182687948017175 | 2016-05-03 19:34:59 | 121.38    | 31.24    |

|  1125897 | 29182687948017175 | 2016-05-03 19:35:28 | 121.39    | 31.23    |
|  1755187 | 29182687948017175 | 2016-05-03 19:37:32 | 121.38    | 31.24    |
|  3118718 | 29182687948017175 | 2016-05-03 19:52:04 | 121.39    | 31.23    |
|  1683017 | 29182687948017175 | 2016-05-03 20:13:08 | 121.39    | 31.23    |
|   693184 | 29182687948017175 | 2016-05-03 22:08:09 | 121.38    | 31.24    |
|   475318 | 29182687948017175 | 2016-05-03 23:30:24 | 121.38    | 31.24    |
|  1301628 | 29182687948017175 | 2016-05-04 00:19:30 | 121.38    | 31.24    |
|   757288 | 29182687948017175 | 2016-05-04 00:29:10 | 121.39    | 31.23    |
........................
|  3054110 | 29182687948017175 | 2016-05-04 06:00:38 | 121.39    | 31.23    |
|  1522517 | 29182687948017175 | 2016-05-04 06:15:30 | 121.38    | 31.24    |
|  1053963 | 29182687948017175 | 2016-05-04 06:23:00 | 121.39    | 31.23    |
|   936286 | 29182687948017175 | 2016-05-04 19:18:15 | 121.38    | 31.24    |
........................
|   623581 | 29182687948017175 | 2016-05-05 07:53:00 | 121.39    | 31.24    |
|  2846760 | 29182687948017175 | 2016-05-05 07:54:39 | 121.38    | 31.25    |
|  2343133 | 29182687948017175 | 2016-05-05 16:02:12 | 121.16    | 31.00    |
|  2001697 | 29182687948017175 | 2016-05-05 16:03:31 | 121.16    | 31.00    |
|  2782996 | 29182687948017175 | 2016-05-05 16:03:41 | 121.16    | 31.00    |
|  1543043 | 29182687948017175 | 2016-05-05 16:07:45 | 121.16    | 31.00    |
|   184478 | 29182687948017175 | 2016-05-05 19:14:09 | 0.00      | 0.00     |
|  1405281 | 29182687948017175 | 2016-05-05 19:20:26 | 0.00      | 0.00     |
|  1809575 | 29182687948017175 | 2016-05-05 19:20:37 | 0.00      | 0.00     |
|  2352386 | 29182687948017175 | 2016-05-05 20:04:51 | 0.00      | 0.00     |
|   361483 | 29182687948017175 | 2016-05-05 20:08:49 | 0.00      | 0.00     |
|   472815 | 29182687948017175 | 2016-05-05 21:05:14 | 121.38    | 31.24    |
|  1053281 | 29182687948017175 | 2016-05-05 21:05:17 | 121.38    | 31.24    |
...................
|  2639070 | 29182687948017175 | 2016-05-06 07:03:04 | 121.38    | 31.24    |
|  2103890 | 29182687948017175 | 2016-05-06 07:55:27 | 121.38    | 31.25    |
|  1307329 | 29182687948017175 | 2016-05-06 07:58:00 | 121.38    | 31.25    |
|   430970 | 29182687948017175 | 2016-05-06 07:58:26 | 121.38    | 31.25    |
|   897470 | 29182687948017175 | 2016-05-06 09:52:33 | 121.16    | 31.00    |
|  2330346 | 29182687948017175 | 2016-05-06 09:54:22 | 121.16    | 31.00    |
|    38980 | 29182687948017175 | 2016-05-06 09:55:04 | 121.16    | 31.00    |
|  2004169 | 29182687948017175 | 2016-05-06 18:29:08 | 121.38    | 31.25    |
|  2350598 | 29182687948017175 | 2016-05-06 19:06:46 | 121.38    | 31.24    |
...................
|  2906005 | 29182687948017175 | 2016-05-07 10:09:26 | 121.38    | 31.24    |
|  1365999 | 29182687948017175 | 2016-05-07 10:13:40 | 121.38    | 31.24    |
|   735122 | 29182687948017175 | 2016-05-07 12:42:49 | 121.38    | 31.25    |
|   581078 | 29182687948017175 | 2016-05-07 15:20:02 | 121.38    | 31.24    |
|  1513092 | 29182687948017175 | 2016-05-07 15:20:21 | 121.38    | 31.24    |
|   514294 | 29182687948017175 | 2016-05-07 18:15:58 | 121.38    | 31.24    |
|  2166807 | 29182687948017175 | 2016-05-07 20:00:26 | 121.38    | 31.24    |
|   534263 | 29182687948017175 | 2016-05-07 20:09:05 | 0.00      | 0.00     |
|  1911116 | 29182687948017175 | 2016-05-07 22:08:17 | 0.00      | 0.00     |
|  1000218 | 29182687948017175 | 2016-05-07 22:09:10 | 121.38    | 31.24    |
|   695256 | 29182687948017175 | 2016-05-07 22:10:30 | 121.38    | 31.24    |
+----------+-------------------+---------------------+-----------+----------+