add dd and mmm and time for matrix

Question

Damith 2016-2-22

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/269481-add-dd-and-mmm-and-time-for-matrix

评论： Star Strider 2016-2-24

采纳的回答： Star Strider

150521.csv

在 MATLAB Online 中打开

Hi,

I have a file like this (see the attached csv file) but I need to include dd mmm yyyy in first column and (arbitrary time say 12:00) time in second column as shown in "output" below. How can I achieve this in MATLAB?

Any help is appreciated.

Thanks in advance.

output:

Jan 1990  12:00  203.03
Jan 1992  12:00  104.77
Jan 1993  12:00  46.156
Jan 1994  12:00  150.65
Jan 1995  12:00  75.323
.
.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Star Strider 2016-2-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/269481-add-dd-and-mmm-and-time-for-matrix#answer_210832

在 MATLAB Online 中打开

You would have to use a cell array:

D = xlsread('Damith 150521.csv');
L = size(D,1);
Dv = [D(:,1) ones(L, 2) ones(L,1)* 12 zeros(L,2)];                  % Date Vectors
Out = {datestr(Dv(:,1:6), 'dd mmm yyyy HH:MM') D(:,2)};             % Output Cell Array
celldisp(Out)                                                       % Display Output (Can Be Discarded)

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

Star Strider 2016-2-22

在 MATLAB Online 中打开

My pleasure.

The code changes slightly to create a table and then write the table to the Excel file:

D = xlsread('Damith 150521.csv');
L = size(D,1);
Dv = [D(:,1) ones(L, 2) ones(L,1)* 12 zeros(L,2)];                  % Date Vectors
OutDate = datestr(Dv(:,1:6), 'dd mmm yyyy HH:MM');                  % Date Array
celldisp(Out)                                                       % Display Output (Can Be Discarded)
table_out = table(OutDate,D(:,2))                                   % Create Table
file_out = 'Damith 150521 DS.xlsx';                                 % Define File
writetable(table_out, file_out)                                     % Write File
[File_Check_Num,File_Check_Dates] = xlsread(file_out)               % Check File (Can Be Discarded)

This is the full code, including the previous code to create the date strings.

The table is necessary because the xlswrite function doesn’t like the cell array of strings. The intermediate table variable solves whatever problem it has with them.

The ‘File_Check_...’ variables simply demonstrate that the data were written to the file correctly, and how to read them. They aren’t necessary for the rest of the code.