How to import sensor data in matlab?

So I have this data from a sensor. I recently started to learn Matlab. I want to know what is the smartest way to import this data in Matlab because in this data only one column contains four variable time acceleration in x y z. this data is taken at different sampling rates e.g after row 3767 another data starts with different sampling rate. I have no idea where to start. any help would appreciated. thank you in advance

Answer 1

[Kevin Chng]

Hi

The best solution is :

Drag your excel and drop it in MATLAB command window.

It will pop out a app for you to configure your excel input.

startRow = 23;
endRow = 89;
formatSpec = '%14f%20f%21f%f%[^\n\r]';
fileID = fopen('SM-G950F_samsung_dreamltexx.csv','r');
dataArray = textscan(fileID, formatSpec, endRow-startRow+1, 'Delimiter', '', 'WhiteSpace', '', 'TextType', 'string', 'EmptyValue', NaN, 'HeaderLines', startRow-1, 'ReturnOnError', false, 'EndOfLine', '\r\n');
fclose(fileID);
SMG950Fsamsungdreamltexx = table(dataArray{1:end-1}, 'VariableNames', {'Var1','Var2','Var3','Var4'});
clearvars filename startRow endRow formatSpec fileID dataArray ans;

Code above is generated through the application. You may edit the VariableNames yrself in the last two lines.

[madhan ravi]

+1 @Kevin Chng efficient debugger

Answer 2

[naren]

you can do it by creating a asensor module