How to import data and remove headers

146 ビュー (過去 30 日間)
Rebecca Harding
Rebecca Harding 2020 年 10 月 5 日
コメント済み: Seth Furman 2020 年 10 月 30 日
Hello,
I am trying to import a log file although I'm having problems running the script due to the headers in the file
EMuJoy --- Joystick movement and emotion measuring
Version 1.0
Date: Wed Jan 09 13:12:16 GMT 2019
TIME,X-COORD,Y-COORD,TRIGGER
*** Music Start ***1547039542802;-0.890625;0.2199004975124379;64
1547039542818;-0.9010416666666666;0.2875621890547264;64
1547039542832;-0.9041666666666667;0.30746268656716413;64
How do I remove the first lines of text so I can just analyse the numbers, and do I need to save a new file before I can import the data?
EDIT: Apologies I'm a bit of a newbie, the original file isn't a text file but text version is attached. My script so far is:
for i = 1:length(DataFolder)
filename = DataFolder(i).name;
%if contains(filename, '.emujoy') %takes only emujoy files from folder
%extracts raw data from logfile
Logs = importdata([DataFolderPath,'\',filename]);
if class(Logs) == 'double'
Log_Data = Logs;
else
Log_Data = Logs.data;
end
Time_Vec = Log_Data(:,1);%Time (in computer clock)
X_Vec = Log_Data(:,2);%Valence
Y_Vec = Log_Data(:,3);%Arousal
Trigger_Vec = Log_Data(:,4);%Triggers
Would I need to remove the headerlines before or after importing the data?
Thanks in advance!
  3 件のコメント
Image Analyst
Image Analyst 2020 年 10 月 5 日
Sindar
Sindar 2020 年 10 月 5 日
importdata has headerline options

サインインしてコメントする。

回答 (1 件)

Ayush Gupta
Ayush Gupta 2020 年 10 月 8 日
The data from the text file can be imported using importdata function in MATLAB. To ignore the header of the file we can use the headerlinesIn option which defines after how many lines it will read the data. To refer to the documentation of importdata and see some examples to understand its working, refer here.
  1 件のコメント
Seth Furman
Seth Furman 2020 年 10 月 30 日
Consider also using readtable which lets you account for header lines in your file.

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeData Import and Analysis についてさらに検索

製品


リリース

R2020b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by