a simpler way to add a string variable to a table

I have a table T
Date City Visitors
----------------------
1/1/2020 New York 10
1/2/2020 New York 20
I want to add a variable 'state' that looks like
Date City Visitors State
----------------------
1/1/2020 New York 10 NY
1/2/2020 New York 20 NY
I did
state=strings(height(T),1)
then
state(:) = 'NY'
then I create a table and merged. But is there a simpler way?

2 Commenti

T.newVar(:,1)=state;
Please ensure that state have same length as T, else you may have to use repmat
But then you have to substiute a value 'state'?

Accedi per commentare.

 Risposta accettata

The doc is your friend. You should really learn how to use it.
This example shows a simple way to add a new variable to a table: Calculate and Add Result as Table Variable

Più risposte (0)

Categorie

Tag

Community Treasure Hunt

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

Start Hunting!

Translated by