Adding values to a table

40 views (last 30 days)
John
John on 7 Oct 2023
Answered: Star Strider on 7 Oct 2023
Hello everyone,
I'm trying to run through a specific column of a table and add values to the rows in that column.
How do I actually refer to the rows/cells of the table that I want to access? In a low level language like C it would be row[i] but I don't know the equivalent in MATLAB.
I've put the code below with a comment in the for loop explaining what I want to do.
Kind regards,
John
%Creates a table called 'tab' using the data in the coronavirus-cases.csv file.
tab = readtable("coronavirus-cases.csv");
%Creates a table called 'newTabCol' with the height of tab and a width of 1.
newTabCol = zeros(height(tab), 1);
%Adds the column and titles it "Seven Day Average".
tab.SevenDayAverage = newTabCol;
for i = 1: height(tab)
%Set all values in SevenDayAverage to 1.
end
  1 Comment
Dyuman Joshi
Dyuman Joshi on 7 Oct 2023
Why not set the values in the newTabCol array and assign it like you have done (instead of going through the for loop)?
"How do I actually refer to the rows/cells of the table that I want to access?"

Sign in to comment.

Accepted Answer

Star Strider
Star Strider on 7 Oct 2023
One approach (that works) —
DateTime = datetime([2020 01 01]) + calmonths(0:5)';
Incidence = randi(10,6,1);
tab = table(DateTime,Incidence)
tab = 6×2 table
DateTime Incidence ___________ _________ 01-Jan-2020 9 01-Feb-2020 8 01-Mar-2020 9 01-Apr-2020 4 01-May-2020 7 01-Jun-2020 2
newRow = {datetime('01-Jul-2020') 8};
tab(end+1,:) = newRow
tab = 7×2 table
DateTime Incidence ___________ _________ 01-Jan-2020 9 01-Feb-2020 8 01-Mar-2020 9 01-Apr-2020 4 01-May-2020 7 01-Jun-2020 2 01-Jul-2020 8
.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2023b

Community Treasure Hunt

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

Start Hunting!