Borrar filtros
Borrar filtros

Adding values to a table

34 visualizaciones (últimos 30 días)
John
John el 7 de Oct. de 2023
Respondida: Star Strider el 7 de Oct. de 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 comentario
Dyuman Joshi
Dyuman Joshi el 7 de Oct. de 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?"

Iniciar sesión para comentar.

Respuesta aceptada

Star Strider
Star Strider el 7 de Oct. de 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
.

Más respuestas (0)

Categorías

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

Productos


Versión

R2023b

Community Treasure Hunt

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

Start Hunting!

Translated by