Append values in a new column

8 次查看（过去 30 天）
Ioannis Doumanis
Ioannis Doumanis 2021-12-7
评论： Cris LaPierre 2021-12-20
Hello all
The code below overwrites the previous values in the column Delay and inserts only the last ones (20). There should be a way to append the array instead of overwriting it but I dont know how. Any help will be appreciated
if contains(baseFileName,"A01")
x{k} = readtable(fullFileName,opts)
bigtable = vertcat(x{:})
bigtable(:,'Delay') = {10}
elseif contains(baseFileName,"A02")
x{k} = readtable(fullFileName,opts)
bigtable = vertcat(x{:})
bigtable(:,'Delay') = {20}
end

请先登录，再回答此问题。

回答（2 个）

Cris LaPierre
Cris LaPierre 2021-12-7
If your tables have the same variable names (order does not matter), then just use square brackets.
newTable = readtable(fullFileName,opts)
bigtable = [bigtable;newTable];
  5 个评论
显示 3更早的评论
Ioannis Doumanis
Ioannis Doumanis 2021-12-8
I am reading a specific data sample (300 samples) from several csv files. I want the samples the one after the other. I tried bigtable.Delay(1:6000) = 10; and still does not work. The table is filled with 0s instead of 10s and 20s. Currently I get correctly only the result (30) of the last condition of sth switch statement.
Cris LaPierre
Cris LaPierre 2021-12-20
Consider sharing your data files. You can attach them using the paperclip icon.

请先登录，再进行评论。

Ioannis Doumanis
Ioannis Doumanis 2021-12-8
I also tried this. I still get 0s for the first two conditions. I am not sure why
delayvalues = [delayvalues; delay];
for k = 1 : length(theFiles)
baseFileName = theFiles(k).name;
fullFileName = fullfile(theFiles(k).folder, baseFileName);
% add column at the end of the table
switch true
case (contains(baseFileName,"A01"))
x{k} = readtable(fullFileName,opts)
bigtable = vertcat(x{:})
delay = 10;
bigtable(1:6000,'Delay') = delayvalues(1);
case (contains(baseFileName,"A02"))
x{k} = readtable(fullFileName,opts)
bigtable = vertcat(x{:})
delay = 20;
bigtable(6000:12000,'Delay') = delayvalues(2);
case (contains(baseFileName,"A03"))
x{k} = readtable(fullFileName,opts)
bigtable = vertcat(x{:})
delay = 30;
bigtable(12000:18000,'Delay') = delayvalues(3);
otherwise
% do nothing
end

类别

在 Help Center 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by