readtable .txt file, reading string row issue
4 次查看(过去 30 天)
显示 更早的评论
Hi,
I have a text file with several columns and rows. The first coulmn are string while the rest of the columns are just data. I would like to pull the row named "al28" for column 4:end. But I have issue with selectiong the string value and get error.
T = readtable('Test.txt');
T2=T('al28',4:end)
Error using Test
Unrecognized table row name 'al28'.
Thank you for your help
Birsen
0 个评论
采纳的回答
the cyclist
2024-1-25
编辑:the cyclist
2024-1-26
You need to specify that the first column is the row names:
% Specify the file name
file_path = 'Test.txt';
% Read the file into a table
T = readtable(file_path, 'Delimiter', '\t', 'ReadRowNames', true);
T2 = T('al28',4:end)
2 个评论
Dyuman Joshi
2024-1-26
编辑:the cyclist
2024-1-26
% Specify the file name
file_path = 'Test.txt';
% Read the file into a table
T = readtable(file_path, 'Delimiter', '\t', 'ReadRowNames', true);
T2 = T('al28',4:end)
"How can I get the list of the first columns (na24m, mg27, ...)?"
Using the properties of the table -
names = T.Properties.RowNames
"I tried T3=T(:,1) but it pulled the column Var1 not the list of the elements."
You need to access the data stored in the table. One way is to use curly brackets.
Read more here - Access Data in Tables
T3 = T{:,1}
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Whos 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!