Can I sort a table in regards to whether or not it contains a certain table heading?

2 visualizaciones (últimos 30 días)
I currently have a code that can sort through files picking out csv files for sorting but not all the csv files contain data that needs sorting. To get around this I was hoping to implement an if loop where if table.Properties.VariableNames ==1 it will sort it otherwise it will ignore it but I can't seem to find a way to do this so was wondering if it is possible?

Respuestas (1)

dpb
dpb el 16 de Jul. de 2024
Movida: dpb el 16 de Jul. de 2024
Show us the loop code for context...
Is the condition that there is only one variable in the files that are not to be sorted (by inference from the ==1 above)?
If you're reading the files into a table and the above is the case, then simply
for i=1:nFiles % loop over all files from a dir() or however determine
t=readtable(file(i), ...); % read each in turn
if width(t)>1 % check on number variables,
t=sortrows(t,...); % >1, sort
end
... % do whatever else...
end

Categorías

Más información sobre Shifting and Sorting Matrices en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by