# How can I create a matrix that contains number and text without using the cell array?

조회 수: 3 (최근 30일)
Riccardo Melani 2023년 2월 3일
댓글: the cyclist 2023년 2월 4일
Hi,
I need to turn a structure into a matrix (as an Excel-like table - see above). I can transpose the single data stored in the different fields to create my table (as I did above), but I can't add columns containing text. I know I am supposed to create a cell array, but my goal is to have all my data in a single matrix that I can open in R for analysis. I'm also trying to open a cell array in R but doesn't really work well.
Thank you very much!
Riccardo
##### 댓글 수: 2없음 표시없음 숨기기
Walter Roberson 2023년 2월 3일
Unfortunately https://www.rdocumentation.org/packages/rmatio/versions/0.12.0/topics/read.mat says almost nothing about what kinds of variables it can read in R.
the cyclist 2023년 2월 4일
Yeah, the unfortunate practical reality is that converting to CSV is almost always the way to communicate between statistical software languages.

댓글을 달려면 로그인하십시오.

### 답변 (2개)

the cyclist 2023년 2월 3일
편집: the cyclist 2023년 2월 3일
The MATLAB table data type is probably the best for this.
Then, how you choose to export the data from MATLAB will also be important. You can use the writetable function for that.
##### 댓글 수: 0이전 댓글 -2개 표시이전 댓글 -2개 숨기기

댓글을 달려면 로그인하십시오.

Sulaymon Eshkabilov 2023년 2월 3일
The most efficientw ay of getting this exercise done is wot use writetable():
% (1) Some structure data:
A.Data1 =(1:10).';
A.Data2=randn(10,1)*10;
A.TXT = [''; ''; 'abc'; 'bac'; 'cba'; 'cab'];
% (2) Convert it into a table array
B = array2table(A.Data1);
B.Var2 = A.Data2;
% (3) Write them (numerical and textual data) into MS Excel using writetable()
writetable(B, 'RData.xls', 'WriteVariableNames',false, 'Sheet', 1);
C = table(A.TXT);
writetable(C, 'RData.xls', 'WriteVariableNames',false, 'Sheet', 1, 'Range', 'C5:C10')

댓글을 달려면 로그인하십시오.

### 카테고리

Help CenterFile Exchange에서 Matrices and Arrays에 대해 자세히 알아보기

### Community Treasure Hunt

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

Start Hunting!

Translated by