How to convert raw cell in [num,txt,raw] = xlsread to ordinary matrix if I have three string columns by using Matlab
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
I have Excel files containing string and numeric data such as...
ID_REF Entrez Gene Gene Symbol SD_cancer 1 SD_cancer 2 SD_cancer 3 SD_cancer 4 SD_cancer 5
221438_s_at 56158 TEX12 2.946576 3.112977 2.968877 3.160022 2.998543
31826_at 23307 FKBP15 7.358873 7.415367 7.260536 7.281535 7.391214
The first three columns are strings and the rest of the columns are numeric. I used [num,txt,raw] = xlsread to read my Excel file. I want to convert raw cell to ordinary matrix to go further with my analysis. I tried to use cell2mat importdata textscan, but it does not work for me. Could you please help me to convert raw to matrix? I will be grateful to you.
0 Kommentare
Antworten (1)
Walter Roberson
am 20 Jan. 2016
No, it is not possible to create an ordinary matrix that contains both text and numeric values.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Large Files and Big Data finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!