convert the cell array to double

Question

sarfudeen 2014-10-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/160244-convert-the-cell-array-to-double

编辑： sarfudeen 2014-10-28

Hi...

I have a cell array of size 31685 X 59. I want convert into a double. I used str2double but it takes longer duration of 130 sec for execution of the conversion.Please suggest me a alternative way to make it faster to lesser than 5 sec.

The first two columns in the cell array are of Date and Time.

Awaiting for earlier response...

Regards, M. Sarfudeen

2 个评论
显示无隐藏无

Jan 2014-10-27

Please post a minimal example of your data. "Date and Time" could be a string, a serial date number or two diffent columns. What is the wanted output?

Please post the code your are currently using. Then it is much easier to improve the code. Perhaps you only forgot to pre-allocate the output and you can solve this in milliseconds.

sarfudeen 2014-10-28

编辑：sarfudeen 2014-10-28

在 MATLAB Online 中打开

Hi Jan,

My code as follows:

[File,Path] = uigetfile({'*.csv','MultiSelect','ON');

fmt = '%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q%q';

z = ischar(File);

if z == 0

   num = length(File)
   temp = cell(1,num);

parfor i = 1: num

    fid1 = fopen(fullfile(Path,File{1,i}),'r');
    temp(i) = textscan(fid1,fmt,'Delimiter',',','CollectOutput',1);
    fclose(fid1);

end

This is my code for reading the multiple csv files.

The temp stores the data as cell array of strings. I would like to convert the temp to double using str2double but it takes too much of time (approx... 130 sec) as my files are of 365 files.

The first column is of Date with format as 'yyyy-mm-dd'

The second column is of Time with format as 'HH:MM:SS'

Kindly please provide me solution which makes the conversion as fast as possible at the earliest.

I am using Matlab R2012b version.

请先登录，再进行评论。

请先登录，再回答此问题。