How to extract cell arrays (dates) from a cell array
14 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
I have a cell array which I want to make a matrix and create graphs from. I've done something similar before and it worked but since my matlab updated to the new one, I can't recreate my results and have come across the same problem in another data extraction.
Okay so this is my code:
%the following lines will read the excel tables into matlab so that they
%are compatible
Therm1 = readtable('Thermister data.xlsx');
%convert datafrom a table to cell and then a numeric array
thermister1 = table2cell(Therm1);
thermister2 = cell2mat(thermister1);
These issues pop up:
% Error using cell2mat (line 45)
% All contents of the input cell array must be of the same data type.
% Error in Thermisters (line 19)
% thermister2 = cell2mat (thermister1);
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/728669/image.jpeg)
once my table is in a cell array it looks more like this:
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/728674/image.jpeg)
I've tried making columns 2-6 a matriz seperately and it worked, but I can't get the date and time to be extracted into a matrix because each individual date is in it's own 1x1 cell array. How can I fix this issue?
1 Commento
the cyclist
il 3 Set 2021
It would be much easier for us to help if you upload your data file (or a small subset that exhibits the issue), so that we can exactly replicate that problem.
Risposte (1)
Vedere anche
Categorie
Scopri di più su Data Type Identification 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!