I'm currently trying to take in multiple files from a directory, do calculations to them, and then save the file to a new directory. The problem I'm having is the num2cell function keeps adding onto the size of the array.
my first iteration
dataf = 9060 x 6
but then my second iteration through
dataf = 9060 x 12
example of a row:
1 2 3 4 5 6 nan nan nan nan nan nan
and this makes it so i cannot combine my matrix's to create the final output.
how do I get rid of the 'nan' issue that occurs.
clear
clc
[PathName,FileName] = uigetfile({'*.xlsx;*.csv'},'Select Data');
[num txt]=xlsread([FileName,PathName]);
length = size(txt,1);
lengthnum = size(num,1);
cd('C:\Users\name\Desktop\Stocks_new')
filename = PathName;
dataF = num;
dataF=num2cell(dataF);
title = txt(1,1:7);
dates = txt(2:length,1);
final = [title; dates dataF];
xlswrite(PathName,final,1)

댓글 수: 1

KSSV
KSSV 2016년 11월 13일
Are you sure that the nans are not there in num?

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

답변 (0개)

카테고리

도움말 센터 및 File Exchange에서 Data Type Conversion에 대해 자세히 알아보기

제품

질문:

2016년 11월 12일

편집:

2016년 11월 13일

Community Treasure Hunt

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

Start Hunting!

Translated by