Matlab error how to fix?

2024 3 4
2 个回答
回答已采纳
更新时间：2024 3 4
6 次查看（30 天）

0 个投票

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

0 个投票

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更早的评论 隐藏 1更早的评论

Manny
Manny 2024-3-4
编辑：Manny 2024-3-4
thank you both. i created a table. the table is 1 by 2. i am getting an error when i try to assign values to the columns. i think i need to pad the newly created table with data so the sizes are the same. is this correct? if yes, how do i fix this?
Code:
FilteredDataRealizedVol1 = table2array(FilteredDataRealizedVol(:,"REALIZED_VOLATILITY"));
sz = [height(FilteredDataRealizedVol) 2];
varTypes = ["datetime", "double"];
varNames = ["TRADE_DATE","REALIZED_VOLATILITY"];
MRVolatility = table('Size',sz,'VariableTypes',varTypes,'VariableNames',varNames);
Error:
Error using ()
Right hand side of an assignment into a table must be another table or a cell array.
Error in LinearRegression (line 55)
MRVolatility(:,1) = FilteredDataRealizedVol.TRADE_DATE;
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

0 个投票

"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

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by