Import data from txt file in to a 2D array
显示 更早的评论
Hi.
I've this txt file:
I'd like that all number (32) that are between the square barckets will be the first rows of a 2D array (matrix) 24x32 .
Anything like this:
Any idea?
Thanks in advance
采纳的回答
Scott Ronquist
2021-1-29
Hello Cosimo,
I understand you are trying to import the data stored in "acquisizione2-new.txt" into the MATLAB Workspace. This is possible with the Name-Value Pair Arguments available for the readtable function. After importing the data, there is one extra step that is necessary to remove NaN columns in the table output from readtable.
Please try the code given below, hope this helps!
data = readtable("acquisizione2-new.txt",'ReadVariableNames',false,...
'Delimiter',[" ","]","["], 'LineEnding', "]\n",'TrimNonNumeric',true);
% find NaN columns
nanIdx = arrayfun(@(x) all(isnan(data{:,x})), 1:width(data));
% remove NaN columns
data(:,nanIdx) = [];
% convert to numeric array (optional)
dataMatrix = data{:,:};
3 个评论
Cosimo Mercuro
2021-1-30
Hi Scott.
Thank for you reply.
All that you've posted works fine.
Nevertheless there are some things that I've not well understood.
I.e. : dataMatrix = data{:,:}
I don't understand what means {:,:}
Anyway I've used your code to do a thermal acquisition from MLX90640 IR Camera.
Many thanks
Scott Ronquist
2021-1-30
Hi Cosimo,
The output of readtable is a table variable. The values within tables can be accessd in many ways, see this summary table for more details. One of the ways to access the values of a table is to use curly brackets ("{ }"). Using curly brackets on table variables means "extract data and concatenate". Within the curly brackets you must specify 2 things: {rows, columns}. Using a colon, ":", means "all". so "{:,:}" means "extract all rows and columns and concatenate".
A more clear alternative would be to use the table2array function. Using the variables previously defined, note that the following are equivalent:
>> a = data{:,:};
>> b = table2array(data);
>> isequal(a,b)
ans =
logical
1
Glad you were able to extract your data!
Cosimo Mercuro
2021-1-31
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
