python拆分CANLog

通过CANOE 导出的log通常有很多个ID的数据，如何才能找到某一个ID下的特殊的信号？利用python可以简单的进行这个步骤，代码如下：

说明：

　　最终的效果是将log信息，分不同的ID进行拆分，并单独生成文件log_id.csv的文件夹。

　　1. 需要输入输入文件夹

　　2. 生成_out文件夹。

　　3. 没有错误处理

　　4. 采用"[A-F|d]{3}"匹配CAN ID

 1 #log analy about CAN Signal for CANOE
 2 import os
 3 import re
 4 
 5 ID_Info = {}
 6 fold_in = input("Please input Folder In:")
 7 fold_out = fold_in + "_out"
 8 os.mkdir(fold_out)
 9 rep_id = r"[A-F|d]{3}"
10 patt_id = re.compile(rep_id)
11 def Info_Report():
12   '''
13   CAN Log中的信息有固定的位数。
14     0：时间戳
15     1：1/2
16     2：ID
17     3：Rx/Tx
18     4: d
19     5: data Length
20     6: data length number info
21   '''
22   pass
23 
24 def Dev_Folder(folder_in):
25   for fi in os.listdir(folder_in):
26     #打开文件
27     with open(os.path.join(folder_in,fi),"r") as file:
28       #遍历文件行
29       for line in file:
30         #拆分文件，去掉空格，去掉前后逗号
31         a = re.sub('s+',',',line).strip(",")
32         #判断List是否有3个以上的元素，并且第3个是否为ID.
33         if len(a.split(",")) > 2 and patt_id.match(a.split(",")[2]):
34           if a.split(",")[2] in ID_Info.keys():
35             #如果在字典中，直接将信息写入到该文件中
36             pass
37           else:
38           #新建一个文件，关联字典
39             ID_Info[a.split(",")[2]] = open((os.path.join(fold_out + "\" + "Log_" + a.split(",")[2]) + ".csv"),"w")
40           ID_Info[a.split(",")[2]].write(a+"
")
41           #print(a.split(",")[0])
42   for key in ID_Info:
43     ID_Info[key].close()
44 
45 if __name__ == '__main__':
46   Dev_Folder(fold_in)
47

以上拆分为单个的ID了，那么如何找到某一个信号的值呢？可以通过下面的代码进行计算：

 1 '''
 2 CANOE Log
 3 '''
 4 '''
 5 
 6 '''
 7 start_bit = 0
 8 data_length = 0
 9 can_mode = 0
10 
11 def Info_Report():
12   '''
13   Need Input This information about CAN setting.
14   start bit: start_bit
15   Length   : Data_Length
16   start bit mode : LSB(0)/MSB(1)
17   default:LSB(0)
18   '''
19   pass
20 
21 def SetBit(start,length,mode = 0):
22   '''
23   for Get Info or set info
24   '''
25   start_bit = start
26   data_length = length
27   can_mode = mode
28 
29 def Analyse_ID_File(File_Input_Name,File_Output_Name):
30   '''
31   Analyse id for Every ID Signal
32   '''
33   #open file
34   file_out = open(File_Output_Name,"w")
35   with open(File_Input_Name,"r") as file:
36     for line in file:
37       #拆分每一行,放入到list中
38       data_list = line.split(",")
39       data_length = int(data_list[5],16)
40       list_in = data_list[6:6+data_length]
41       data_signal = Find_FromList(list_in)
42       file_out.write(data_list[0]+","+str(data_signal)+"
")
43   file_out.close()
44 
45 def Find_FromList(data_list):
46   dataMerge = ''
47   a,b,c = Find_StartEnd(start_bit,data_length,can_mode)
48   #print(data_list)
49   if len(data_list) > b:
50     for i in range(a,b+1):
51       #print(i)
52       dataMerge = dataMerge + data_list[i]
53       #print(dataMerge)
54     data_Digit = (int(dataMerge,16)>>c) & ((1<<(data_length))-1)
55     return (data_Digit)
56     #print(dataMerge)
57 
58 def Find_StartEnd(start,length,mode):
59   '''
60   This Function return value:
61   byte_little,byte_big,bigbyte_bit
62   '''
63   startbyte = start >> 3
64   startbit = start % 8
65   if mode == 0:
66     litByte = startbyte - ((startbit+length-1)>>3)
67     BigByte = startbyte
68     Endbit = startbit
69   else:
70     pass
71   return (litByte,BigByte,Endbit)
72 
73 if __name__ == '__main__':
74   #print(Find_StartEnd(32,20,1))
75   file_name = input("Please input file You need Analyse:")
76   file_out_name = input("Please input file You need Out(.csv):")
77   start_bit,data_length,can_mode = map(int,input("please input can info(start_bit,data_length,can_mode(0/1),PV为0):").split(","))
78   Analyse_ID_File(file_name,file_out_name)

以上，如果不通过导入每个信号信息含义的话，是可以快速的找到某个信号在整个log中的值得变化的。

　　以上，只支持以LSB开始，计算长度的算法。如果以MSB需要在''Find_StartEnd"函数中增加''mode == 1''的处理。