How can I merge text to numeric data?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Benjamin Horsley
il 13 Feb 2021
Commentato: Benjamin Horsley
il 13 Feb 2021
I have two variables:
A = [1 2 3 4 5 6 7 8 9 10]';
B = ["L", "R"]';
How can I merge A and B where B is of the same height (number of rows) as A? In other words, I want to have a second colum of alternating "L" and "R" .
Appreciate any help. Thanks.
0 Commenti
Risposta accettata
KALYAN ACHARJYA
il 13 Feb 2021
Modificato: KALYAN ACHARJYA
il 13 Feb 2021
A = [1 2 3 4 5 6 7 8 9 10]';
B = ["L", "R"]';
r=length(A)/length(B);
B_update=repmat(B,[r,1])
t=table(A,B_update)
Result:
t =
10×2 table
A B_update
__ ________
1 "L"
2 "R"
3 "L"
4 "R"
5 "L"
6 "R"
7 "L"
8 "R"
9 "L"
10 "R"
2 Commenti
Walter Roberson
il 13 Feb 2021
Note that it is not possible to have a numeric array that combines numbers and text, which is why the above solution puts the data into a table.
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Characters and Strings in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!