Import data from txt file
5 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Ferdinand Grosse-Dunker
il 16 Lug 2019
Commentato: Adam Danz
il 16 Lug 2019
Hi there,
my txt file looks like this: (see attached txt file)
What I try to get is a simple table with lines like this:
frame; timestamp [s]; loc_x; loc_y; loc_z
1007; 52045.728; -135.966; 225.786; -52.285
1008; 52045.745; -135.966; 225.786; -52.285
How can I do this? Thanks
3 Commenti
Rik
il 16 Lug 2019
Do you need code that only works on this file, or should it also handle multiple bodies being tracked?
What have you tried so far on your own?
Risposta accettata
Adam Danz
il 16 Lug 2019
Modificato: Adam Danz
il 16 Lug 2019
This uses readtable() to read in your txt file and it uses regexp() with the 'tokens' flag to pull out relevant data.
%% Import data into table
opts = delimitedTextImportOptions("NumVariables", 1);
opts.DataLines = [1, Inf];
opts.VariableNames = "txt";
test1 = readtable("test1.txt", opts); %file is on path
%% Extract desired data
% Pull out the frame and ts data
tokens = regexp(test1.txt, 'frame (\d+) ts (\d+.\d+)', 'tokens');
frame_ts = cell2mat(cellfun(@str2double,[tokens{:}]','UniformOutput',false));
% Pull out loc coordinates
tokens = regexp(test1.txt, '^loc (-?\d+.\d+) (-?\d+.\d+) (-?\d+.\d+)', 'tokens');
loc = cell2mat(cellfun(@str2double,[tokens{:}]','UniformOutput',false));
% Check that frame_ts and loc have same number of rows.
if size(frame_ts,1) ~= size(loc,1)
error('''frame_ts'' and ''loc'' have different number of rows.')
end
%% Put data into table
T = array2table([frame_ts, loc], 'VariableNames', {'frame', 'timestamp', 'loc_x', 'loc_y', 'loc_z'});
% inspect first few rows
head(T)
Result
format long
>> head(T)
ans =
8×5 table
frame timestamp loc_x loc_y loc_z
_____ _________ ________ _______ _______
1007 52045.728 -135.966 225.786 -52.285
1008 52045.745 -135.966 225.786 -52.285
1009 52045.761 -135.967 225.786 -52.283
1010 52045.778 -135.967 225.786 -52.283
1011 52045.795 -135.967 225.786 -52.283
1012 52045.811 -135.967 225.786 -52.283
1013 52045.828 -135.967 225.786 -52.283
1014 52045.845 -135.967 225.786 -52.283
0 Commenti
Più risposte (1)
Vedere anche
Categorie
Scopri di più su Cell Arrays in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!