%2019/9/19
%fish
%1.raw中保存了所有日期的源格式
%19??去毛刺?分段?取連續?去
%?去掉數組中多余空間
clear;???%?清除變量
clc;?????%?清理桌面
clear?all?;???
filename1?=?‘文件1.xlsx‘;??%excel存放路徑
filename2?=?‘文件2.xlsx‘;??%excel存放路徑
filename3?=?‘文件3.xlsx‘;??%excel存放路徑
sheet1?=?1;
sheet2?=?1;
sheet3?=?1;
xlRange1?=?‘A2:C185726‘;
xlRange2?=?‘A2:C145826‘;
xlRange3?=?‘A2:C164915‘;
[num1?text1?raw1]?=?xlsread（filename1sheet1xlRange1）;??
[num2?text2?raw2]?=?xlsread（filename2sheet2xlRange2）;??
[num3?text3?raw3]?=?xlsread（filename3sheet3xlRange3）;??

for?S_Num_ii=1:1:3
????if??S_Num_ii==1
????????S_Num?=length（raw1（:2?））;???%?需要處理總數
????????Speed=num1（1:S_Num1）??;???????????????????%速度數值???
????????time=raw1（1:S_Num1）??;???????????????????%?時間
????elseif??S_Num_ii==2
????????S_Num?=length（raw2（:2?））;???%?需要處理總數
????????Speed=num2（1:S_Num1）??;???????????????????%速度數值???
????????time=raw2（1:S_Num1）??;???????????????????%?時間
????else
????????S_Num?=length（raw3（:2?））;???%?需要處理總數
????????Speed=num3（1:S_Num1）??;?????%速度數值???
????????time=raw3（1:S_Num1）??;??????%?時間
????end

%%?1.?標記0與0之間的片段位置??
%??2019-09-20?00:38:45?
Zero_index?=?find（Speed（:1）?==?0?）;?????%?0的位置為索引值????零的位置??
Zero_length=length（Zero_index）????;??????%?零的個數
Zero_section?=?zeros（Zero_length1）;???????????%?大小初為S_Num???零的區間號
Zero_section_i=1;
Err_one=1;
for?Zero_index_i?=?1:1:Zero_length-1
??????????index_val1?=?Zero_index（Zero_index_i1）;
??????????index_val2?=?Zero_index（Zero_index_i+11）;
??????????index_val??=?index_val2-index_val1;
??????????if???index_val>Err_one
?????????????Zero_section（Zero_section_i1）=index_val1;??????????????????????????%?標記大于的值的?索引值
?????????????Zero_section_i?=?Zero_section_i+1;
?????????????Zero_section（Zero_section_i1）=index_val2;??????????????????????????%?標記大于的值的?索引值
?????????????Zero_section_i?=?Zero_section_i+1;
??????????end
end
%%??2.標記所之間的毛刺數的位置
%??2019-09-20?07:14:10?-??2019-09-20?10:26:00
Zero_section_length=find（Zero_section（:1）?==?0）;??????%?片段數據大小
Exceptional_Speed_Data?=?zeros（Zero_length1）;???%?毛刺數據??建立數組
Exceptional_Speed_Data_i?=1??;????????????????????%??數組的元素
Exceptional_Data_Point?=?1;?????%異常數據的點
More_Than_index_10?=?11?;????????%0之間大于10的數
for??Exceptional_Data_Point_i?=?1:1:Zero_section_length（11）-2
?????First_Zero_Position??=?Zero_section（Exceptional_Data_Point_i1）;?????%?到第一為零的位置
?????Second_Zero_Position?=?Zero_section（Exceptional_Data_Point_i+11）;???%?到第二為零的位置
?????if?isempty（find（Speed（First_Zero_Position:Second_Zero_Position1）?>=?More_Than_index_10?1?）?）??%如果為空數組返回值為1???????????
??????????????for??First_Zero_Position_i?=?First_Zero_Position:1:Second_Zero_Position
??????????????????if?Speed（First_Zero_Position_i1）?~=?0?????%排除零
????????????????????????Exceptional_Speed_Data（Exceptional_Speed_Data_i1）?=?First_Zero_Position_i;??%?第一個毛刺數據的位置
????????????????????????Exceptional_Speed_Data_i=Exceptional_Speed_Data_i+1;?????
??????????????????end???
??????????????end?
?????end
end
Excep

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????文件???????25136??2019-09-23?18:09??Speed_time.m
?????文件????15951016??2019-09-19?09:17??文件1.xlsx
?????文件????12524014??2019-09-19?09:17??文件2.xlsx
?????文件????13981121??2019-09-19?09:18??文件3.xlsx
?????文件??????122093??2019-09-20?11:56??汽車行駛工況構建0914.docx