How to find a specific number in a specific column in an excel file and how many times it occurs
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Hi, I have been looking around for a solution to this problem, I have an excel file and it contains the number -1100 in the column with header "T". I want to find out how many times this number occurs in this given column. So I tried
[~, ~, data] = xlsread('test.xlsx');
data = string(data); % convert to string for easy comparision
rowsIndex = data(:, 1) == "T" && data(:, 2) == "-1100";
requiredRows = data(rowsIndex, :);
but this does not work. How can I find the number of times it occurs in the T column?
Thanks
2 comentarios
Respuesta aceptada
VBBV
el 31 de En. de 2024
D = readtable('test.xlsx');
rowsIndex = D.T == -1100;
requiredRows = D(rowsIndex, :)
4 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!