Getting error All table variables must have the same number of rows.

30 visualizaciones (últimos 30 días)
Ehtisham
Ehtisham el 23 de Mayo de 2024
Movida: Voss el 23 de Mayo de 2024
All table variables must have the same number of rows. while runing the code am getting this error. Need your help
  4 comentarios
Voss
Voss el 23 de Mayo de 2024
You can't make a table out of those because they have different number of rows, just like the error message says.
Some of them are empty (0x1) and some are scalars (1x1). That's the problem.
Think about what size they should be, based on your given data, and then figure out why they're not the size they should be.
Ehtisham
Ehtisham el 23 de Mayo de 2024
Editada: Voss el 23 de Mayo de 2024
% Ensure all variables have the same length
min_length = min(length(Rpeak_C), length(Tpeak_C), length(L_C), length(Rss_C), length(Ratio_Rpeak_C_Rss_C), length(Delta_C));
% Truncate variables to match the shortest length
Rpeak_C = Rpeak_C(1:min_length);
Tpeak_C = Tpeak_C(1:min_length);
L_C = L_C(1:min_length);
Rss_C = Rss_C(1:min_length);
Ratio_Rpeak_C_Rss_C = Ratio_Rpeak_C_Rss_C(1:min_length);
Delta_C = Delta_C(1:min_length);
% Create the table
PhaseC = table(Rpeak_C, Tpeak_C, L_C, Rss_C, Ratio_Rpeak_C_Rss_C, Delta_C, ...
'VariableNames', {'RpeakC', 'T-peakC', 'L_C', 'RssC', 'RpeakC/RssC', 'Delta_C'});
% Write the table to a CSV file
ligandRemovalFilename = 'PhaseC.csv';
writetable(PhaseC, ligandRemovalFilename)
Used that min length but now giving the Too many arguments error.

Iniciar sesión para comentar.

Respuestas (1)

Voss
Voss el 23 de Mayo de 2024
Movida: Voss el 23 de Mayo de 2024
If you want to truncate the variables to the size of the smallest one, use size(_,1) which is number of rows, instead of length(_), which is size of the longest dimension.
% Ensure all variables have the same number of rows
min_length = min([size(Rpeak_C,1), size(Tpeak_C,1), size(L_C,1), size(Rss_C,1), size(Ratio_Rpeak_C_Rss_C,1), size(Delta_C,1)]);
% Truncate variables to match the shortest
Rpeak_C = Rpeak_C(1:min_length,:);
Tpeak_C = Tpeak_C(1:min_length,:);
L_C = L_C(1:min_length,:);
Rss_C = Rss_C(1:min_length,:);
Ratio_Rpeak_C_Rss_C = Ratio_Rpeak_C_Rss_C(1:min_length,:);
Delta_C = Delta_C(1:min_length,:);
%Create a separate table for steady state after ligand removal
PhaseC = table( Rpeak_C,Tpeak_C,L_C, Rss_C, Ratio_Rpeak_C_Rss_C,Delta_C, ...
'VariableNames', {'RpeakC' ,'T-peakC' ,'L_C','RssC','RpeakC/RssC','Delta_C',});
% Write the steady state after ligand removal table to a separate CSV file
ligandRemovalFilename = 'PhaseC.csv';
writetable(PhaseC, ligandRemovalFilename);
Note that will produce an empty table in this case.
However, a better solution would be to fix the problem at the source: figure out why variables that should have the same number of rows (if indeed they should) in fact have different numbers of rows.

Categorías

Más información sobre Time Series en Help Center y File Exchange.

Productos


Versión

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by