Read text file without header and separate columns
92 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Dear Matlab Team,
my problem is as follows. I could not find a solution in other forums, but none seem to work for my issue:
I have a text file with a big headliner, which I want to skip. The data I need starts in line 194 and has 50.000 values. There are 3 values in each row, sperated by ",". Basically, what I need is to extract the 50 000 values and put it in matrix with 3 columns for further analyzation.
This is how the file looks like (starting from below "DATA BLOCK..."]
...
[DATA BLOCK 1-1-1]
0.00000,20.47668,0.13959
0.00010,20.46021,0.16467
0.00020,20.47668,0.11914
0.00030,20.48767,0.19208
...
How can I separate this data and create a matrix from it?
Thanks in advance,
Philipp
0 Kommentare
Akzeptierte Antwort
Rik
am 29 Apr. 2020
Bearbeitet: Rik
am 29 Apr. 2020
A = readmatrix(filename,'NumHeaderLines',193);
Edit:
As Walter suggested below: releases older than R2019a are missing the readmatrix function. On R2013b or newer, the readtable function can help out:
A = table2array(readtable(filename,'NumHeaderLines',193, 'readvariablenames', false));
8 Kommentare
Walter Roberson
am 6 Mai 2020
Looks like I misinterpreted what was being requested.
You should be pre-initializing A.
input_folder = 'folder';
files = dir(fullfile(input_folder, '*.txt'));
file_paths = fullfile({files.folder}, {files.name});
nfile = numel(file_paths);
for i = 1 : nfile
data = readmatrix(file_paths{i},'NumHeaderLines',193);
if i == 1
A(:,3*nfile) = 0; %grow array to largest size
else
A(:, i*3-2:i*3) = data;
end
end
Weitere Antworten (1)
B
am 21 Apr. 2022
Bearbeitet: Rik
am 21 Apr. 2022
I think summarizing you've got something like this:
input_folder = 'folder';
files = dir(fullfile(input_folder, '*.txt'));
file_paths = fullfile({files.folder}, {files.name});
nfile = numel(file_paths);
for i = 1 : nfile
data= readmatrix(file_paths{i},'NumHeaderLines',1);% a display of data in a single file
cols=3*(i-1)+(1:3)
A(:,cols)=data; % A is your desired result outpout file
end
0 Kommentare
Siehe auch
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!