Adding values to a table
40 views (last 30 days)
Show older comments
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
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?"
Accepted Answer
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)
newRow = {datetime('01-Jul-2020') 8};
tab(end+1,:) = newRow
.
0 Comments
More Answers (0)
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!