Organizing dates and values using simple matrices

Question

Cas Cas 2015-7-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231120-organizing-dates-and-values-using-simple-matrices

评论： Cas Cas 2015-7-27

I have data of that look as that looks like this:

Year     Month     Day1     Day2     Day3 ... Day31
1999      01        VAL     VAL      VAL       VAL
1999      02        VAL     VAL      VAL       VAL

It's a csv file and VAL is a real number. I'm using a mix of textread and csvread to open them (depending, some of the files have headers that need to be included) and it seems like a lot of matrix rearranging. I think I have an idea of how to use MATLAB to organize them into cell arrays, but actually cell arrays won't help me in the end. What is needed is just a x-by-2 matrix that basically is like

1999-01-01 VALUE
1999-01-02 VALUE
1999-01-03 VALUE
1999-01-04 VALUE

I'm mainly not sure if the first column is possible like that or if it needs to be either a string or a x-by-4 matrix like this

1999 01 03 VAL

Thanks for any suggestions.

2 个评论
显示无隐藏无

bio lim 2015-7-25

Take a look at structures. They might solve your problem.

Cas Cas 2015-7-25

Sorry, I mentioned cell arrays wouldn't work in the end, and the same is for structures. It has to be a matrix.

请先登录，再进行评论。

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

Answer 1

Azzi Abdelmalek 2015-7-25

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/231120-organizing-dates-and-values-using-simple-matrices#answer_187153

编辑：Azzi Abdelmalek 2015-7-26

在 MATLAB Online 中打开

Edit

%-----------------Example------------------------
A=[ {'year' 'month'} genvarname(repmat({'day'},1,31),'day');repmat({1999},12,1)  num2cell((1:12)') num2cell(rand(12,31))] 
%----------------The code------------------------
B=A(2:end,3:end);
BB=B(:);
y=repmat(A(2:end,1),1,31)';
y=y(:);
m=repmat(A(2:end,2),1,31)';
m=m(:);
d=num2cell(repmat((1:31)',size(B,1),1));
out=[y m  d BB];
idx=cellfun(@isempty,out(:,4));   %-----------Edited line--------------
out(idx,:)=[]

4 个评论
显示 2更早的评论隐藏 2更早的评论

Cas Cas 2015-7-27

Okay so this is what I want I think. However, the day values don't quite match up correctly with their respective dates. For example, just compare January 1st and 2nd 1999 before and after. I've been trying to fix this myself with matrix manipulation but with no luck. Any advice? I tried some transposes also that I thought might work, but those ended up getting me errors with the concatenations.

Cas Cas 2015-7-27

Okay, I've figured out the issue on my own and can output to a file. My question now is: is there anyway for the dates to by hyphenated or stored in two matrices upon saving to a file or something for use in a database?

请先登录，再进行评论。