清空筛选条件
清空筛选条件

Matlab error how to fix?

3 次查看（过去 30 天）
Manny
Manny 2024-3-4
评论： Manny 2024-3-4
hi everyone
i am intererested in creating a m by 2 matrix where the first column is a datetime and second column is numeric. I thought the below code would work but it is not. how can i fix my code?
Code:
Data = convertvars(Data, 2, @(x) datetime(x, 'InputFormat', 'yyyy-MM-dd'));
FilteredDataRealizedVol = Data(:,["TRADE_DATE","REALIZED_VOLATILITY"]);
MR_Volatility(:,1) = FilteredDataRealizedVol.TRADE_DATE;
MR_Volatility(:,2) = FilteredDataRealizedVol1 + S * (M - FilteredDataRealizedVol1);
Error:
Error using ()
You cannot assign numeric values to a datetime array. Assign to the array's Year, Month, Day, Hour, Minute, or Second
properties, or use datetime(x,'ConvertFrom',...) to create datetime values for assignment.
Error in LinearRegression (line 51)
MR_Volatility(:,2) = FilteredDataRealizedVol1 + S * (M - FilteredDataRealizedVol1);
Thank you

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

采纳的回答

Walter Roberson
Walter Roberson 2024-3-4
You cannot fix your code. It is not possible to create a uniform array in which the first column is datetime and the second column is numeric.
You can create a table(), but not an array.
MR_Volatility(:,2) = FilteredDataRealizedVol1 + S * (M - FilteredDataRealizedVol1);
Note by the way that you are operating on the entire table FilteredDataRealizedVol1 there, not just on the realized volatility
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2024-3-4
MRVolatility{:,1} = FilteredDataRealizedVol.TRADE_DATE;
Manny
Manny 2024-3-4
thank you so much!! it works now

请先登录，再进行评论。

更多回答（1 个）

Voss
Voss 2024-3-4
"creating a m by 2 matrix where the first column is a datetime and second column is numeric"
You cannot mix data types in a matrix (or any array); all elements must be of the same class.
However, you might find that using a table works well.
https://www.mathworks.com/help/matlab/tables.html
https://www.mathworks.com/help/matlab/matlab_prog/create-a-table.html

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by