txt数据格式转换

来源：互联网发布：发泥推荐知乎编辑：程序博客网时间：2024/05/17 02:40

欢迎使用Markdown编辑器写博客

本Markdown编辑器使用[StackEdit][6]修改而来，用它写博客，将会带来全新的体验哦：

Markdown和扩展Markdown简洁的语法
代码块高亮
图片链接和图片上传
LaTex数学公式
UML序列图和流程图
离线写博客
导入导出Markdown文件
丰富的快捷键

源数据格式

这里写图片描述

目标数据格式

这里写图片描述

Code

import calendarimport timefor index in range(25,31):#(4,10)    input_path = "H:\\Map Matching\\2015年5月\\201505"+ str(index) +"\\201505"+str(index)+".txt"    output_path = "H:\\Map Matching\\2015年5月\\201505"+ str(index) +"\\Traj201505"+str(index)+".txt"    output_file = open(output_path, 'a+',encoding='utf-8')    ori_data = open(input_path , "r+")    lines = ori_data.readlines()    output_file.write("VehicleID" + ','+ "UtcTime" + ','+ "Longitude" +','+"Latitude"+                          ',' + "Speed"+ ',' +"Angle" +','+  "TemValue" + '\n')    try:        for line in lines:            data_list = line.split(',')            format_time = time.strptime(data_list[1], "%Y-%m-%d %H:%M:%S")            utc_time = calendar.timegm(format_time)            vehicleId = data_list[0]            speed = data_list[5]            angle = data_list[4]            if len(data_list) == 10:                if data_list[8] == "空车":                    temValue = 0                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ','                                      + speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()                elif data_list[8] == "重车":                    temValue = 1                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()            elif len(data_list) == 9:                if data_list[8] == "空车\n":                    temValue = 0                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ','                                      + speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()                elif data_list[8] == "重车\n":                    temValue = 1                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()            elif len(data_list) == 11:                if data_list[9] == "空车":                    temValue = 0                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()                elif data_list[9] == "重车":                    temValue = 1                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()            elif len(data_list) == 12:                if data_list[10] == "空车":                    temValue = 0                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()                elif data_list[10] == "重车":                    temValue = 1                    output_file.write(vehicleId + ',' + '%.3f' % utc_time + ',' + data_list[2] + ',' + data_list[3] + ',' +                                      speed + ',' + angle + ',' + str(temValue) + '\n')                    output_file.flush()        output_file.close()    except Exception as e:        print(e)

阅读全文

0 0