How can I merge text to numeric data?
2 views (last 30 days)
Show older comments
Benjamin Horsley
on 13 Feb 2021
Commented: Benjamin Horsley
on 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 Comments
Accepted Answer
KALYAN ACHARJYA
on 13 Feb 2021
Edited: KALYAN ACHARJYA
on 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 Comments
Walter Roberson
on 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.
More Answers (0)
See Also
Categories
Find more on Characters and Strings 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!