lijunhao189 2018-03-19 02:35 采纳率: 0%
浏览 651
已结题

根据数据最后一个字段正负判断方向,增加字段进行区分方向的不同!?

数据格式如下:
432417e51e7d340a,2018-02-07 09:20:52,120.707309,30.633297,0.0
432417e51e7d340a,2018-02-07 09:25:55,120.71122,30.64435,1.2861781
432417e51e7d340a,2018-02-07 09:26:53,120.707309,30.633297,-1.2861781
432417e51e7d340a,2018-02-07 09:28:27,120.70445,30.63925,0.7170383
432417e51e7d340a,2018-02-07 09:32:21,120.707309,30.633297,-0.7170383
432417e51e7d340a,2018-02-07 09:37:07,120.70445,30.63925,0.7170383
432417e51e7d340a,2018-02-07 09:38:59,120.707309,30.633297,-0.7170383
432417e51e7d340a,2018-02-07 09:40:33,120.707309,30.633297,0.0
432417e51e7d340a,2018-02-07 09:41:17,120.70445,30.63925,0.7170383
432417e51e7d340a,2018-02-07 09:41:58,120.707309,30.633297,-0.7170383
432417e51e7d340a,2018-02-07 09:44:00,120.70445,30.63925,0.7170383
432417e51e7d340a,2018-02-07 09:47:12,120.71122,30.64435,0.56913984
432417e51e7d340a,2018-02-07 09:47:52,120.707309,30.633297,-1.2861781
432417e51e7d340a,2018-02-07 09:49:51,120.715865,30.64935,1.9659712
432417e51e7d340a,2018-02-07 10:09:32,120.72743,30.64796,0.559644
432417e51e7d340a,2018-02-07 10:13:45,120.78822,30.678701,6.7269063
432417e51e7d340a,2018-02-07 10:15:35,120.817392,30.696594,3.4293442
432417e51e7d340a,2018-02-07 10:24:30,120.83463,30.72041,2.899088
432417e51e7d340a,2018-02-07 10:27:14,120.82615,30.70921,-1.4039326
432417e51e7d340a,2018-02-07 10:32:32,120.81779,30.70191,-1.1261663
432417e51e7d340a,2018-02-07 10:34:57,120.83463,30.72041,2.530099
432417e51e7d340a,2018-02-07 10:36:56,120.83463,30.72041,0.0
432417e51e7d340a,2018-02-07 10:37:49,120.84623,30.72688,1.3184185
432417e51e7d340a,2018-02-07 10:38:28,120.852487,30.734512,0.99814034
432417e51e7d340a,2018-02-07 10:39:45,120.86842,30.73819,1.4541836
432417e51e7d340a,2018-02-07 10:40:57,120.853132,30.745325,-0.6269398
432417e51e7d340a,2018-02-07 10:45:49,120.79159,30.691897,-8.345741
432417e51e7d340a,2018-02-07 10:55:17,120.70348,30.64357,-9.178058
432417e51e7d340a,2018-02-07 10:59:44,120.6837,30.63107,1.073965
结果文件格式:
432417e51e7d340a,2018-02-07 09:20:52,120.707309,30.633297,0.0,1
432417e51e7d340a,2018-02-07 09:25:55,120.71122,30.64435,1.2861781,1
432417e51e7d340a,2018-02-07 09:26:53,120.707309,30.633297,-1.2861781,1
432417e51e7d340a,2018-02-07 09:28:27,120.70445,30.63925,0.7170383,1
432417e51e7d340a,2018-02-07 09:32:21,120.707309,30.633297,-0.7170383,1
432417e51e7d340a,2018-02-07 09:37:07,120.70445,30.63925,0.7170383,1
432417e51e7d340a,2018-02-07 09:38:59,120.707309,30.633297,-0.7170383,1
432417e51e7d340a,2018-02-07 09:40:33,120.707309,30.633297,0.0,1
432417e51e7d340a,2018-02-07 09:41:17,120.70445,30.63925,0.7170383,1
432417e51e7d340a,2018-02-07 09:41:58,120.707309,30.633297,-0.7170383,1
432417e51e7d340a,2018-02-07 09:44:00,120.70445,30.63925,0.7170383,1
432417e51e7d340a,2018-02-07 09:47:12,120.71122,30.64435,0.56913984,1
432417e51e7d340a,2018-02-07 09:47:52,120.707309,30.633297,-1.2861781,1
432417e51e7d340a,2018-02-07 09:49:51,120.715865,30.64935,1.9659712,1
432417e51e7d340a,2018-02-07 10:09:32,120.72743,30.64796,0.559644,1
432417e51e7d340a,2018-02-07 10:13:45,120.78822,30.678701,6.7269063,1
432417e51e7d340a,2018-02-07 10:15:35,120.817392,30.696594,3.4293442,1
432417e51e7d340a,2018-02-07 10:24:30,120.83463,30.72041,2.899088,1
432417e51e7d340a,2018-02-07 10:27:14,120.82615,30.70921,-1.4039326,2
432417e51e7d340a,2018-02-07 10:32:32,120.81779,30.70191,-1.1261663,2
432417e51e7d340a,2018-02-07 10:34:57,120.83463,30.72041,2.530099,3
432417e51e7d340a,2018-02-07 10:36:56,120.83463,30.72041,0.0,3
432417e51e7d340a,2018-02-07 10:37:49,120.84623,30.72688,1.3184185,3
432417e51e7d340a,2018-02-07 10:38:28,120.852487,30.734512,0.99814034,3
432417e51e7d340a,2018-02-07 10:39:45,120.86842,30.73819,1.4541836,3
432417e51e7d340a,2018-02-07 10:40:57,120.853132,30.745325,-0.6269398,4
432417e51e7d340a,2018-02-07 10:45:49,120.79159,30.691897,-8.345741,4
432417e51e7d340a,2018-02-07 10:55:17,120.70348,30.64357,-9.178058,4
432417e51e7d340a,2018-02-07 10:59:44,120.6837,30.63107,1.073965,4
字段分别是:用户id,时间,经纬度,行驶距离(正负表示方向),若该用户行驶距离字段连续出现两个相同符号,则该用户行驶方向发生改变。
(若行驶距离字段符号为0按大于零处理)

  • 写回答

2条回答 默认 最新

  • 可乐会唱歌 2018-03-19 03:47
    关注

    最后的方向是相对于初始经纬度的方向吧,那就直接比较经纬度就行了啊

    评论

报告相同问题?

悬赏问题

  • ¥15 求差集那个函数有问题,有无佬可以解决
  • ¥15 【提问】基于Invest的水源涵养
  • ¥20 微信网友居然可以通过vx号找到我绑的手机号
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题