Read text file without header and separate columns
101 次查看(过去 30 天)
显示 更早的评论
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 个评论
采纳的回答
Rik
2020-4-29
编辑:Rik
2020-4-29
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 个评论
Walter Roberson
2020-5-6
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
更多回答(1 个)
B
2022-4-21
编辑:Rik
2022-4-21
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 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!