Match columns and fill datasets
2 views (last 30 days)
Show older comments
Tanmoyee Bhattacharya
on 11 Jul 2024
Answered: Star Strider
on 12 Jul 2024
I have two files. One file has some values like that:
1
1
1
1
1
1
2
2
2
2
2
2
2
3
3
3
3
3
3
Another file has values like that
1 10
2 20
3 30
I have to assign values of 1, 2 and 3 from file 2 to file 1. In file 1 if 1 value is 6 then six 10 values will assign. Like that I have 800 values. If there is any shortcut for that.
0 Comments
Accepted Answer
Star Strider
on 12 Jul 2024
File_1 = [1
1
1
1
1
1
2
2
2
2
2
2
2
3
3
3
3
3
3];
File_2 = [1 10
2 20
3 30];
Out = accumarray(File_1, File_1, [], @(x){File_2(x,:)})
Result = cell2mat(Out)
disp(Result)
Out{1}
Out{2}
Out{3}
.
0 Comments
More Answers (0)
See Also
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!