How to convert one column from string to datetime

2024 2 18
1 个回答
回答已采纳
更新时间：2024 2 18
12 次查看（30 天）

0 个投票

Hi everyone
I have a n by 3 matrix. The second column is date in string format. I need to convert the second column to datetime format "YYYY-MM-DD" and return the other 2 columns untouched. I thought this would work but I am getting an error:
ABC(:,2) = datetime(ABC(:,2));
The error is:
Error using datetime
Input data must be a numeric array, a string array, a cell array containing character vectors,
or a char matrix.
How can I fix my code?
Thank you

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

Stephen23
Stephen23 2024-2-18
"How can I fix my code?"
Please upload your data in a MAT file by clicking the paperclip button.
Manny
Manny 2024-2-18
编辑：Manny 2024-2-18
Here is a few entries from the second column:
>> ABC(:,2)
ans =
2443×1 table
TRADE_DATE
______________
{'2014-06-03'}
{'2014-06-11'}
{'2014-06-19'}
{'2014-06-25'}
{'2014-06-26'}
Manny
Manny 2024-2-18
编辑：Manny 2024-2-18
@Stephen23, thanks for the reply. I am new to Matlab. I am not really sure what you mean/need. Are you asking for this? The problem is CIV table.
Dyuman Joshi
Dyuman Joshi 2024-2-18
Save the table as an excel file using writetable and upload it here using the paperclip button.

请先登录，再进行评论。

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

 采纳的回答

Dyuman Joshi
Dyuman Joshi 2024-2-18
Ran in:

0 个投票

Ran in:
If you are using R2018b or a later version, you can use convertvars -
%Random data for example
ABC = table(rand(5,1), {'2014-06-03';'2014-06-11';'2014-06-19';'2014-06-25';'2014-06-26'})
ABC = 5×2 table
Var1 Var2 ________ ______________ 0.018163 {'2014-06-03'} 0.91476 {'2014-06-11'} 0.90892 {'2014-06-19'} 0.11466 {'2014-06-25'} 0.94165 {'2014-06-26'}
%Convert the 2nd column data to datetime
ABC = convertvars(ABC, 2, @(x) datetime(x, 'InputFormat', 'yyyy-MM-dd'))
ABC = 5×2 table
Var1 Var2 ________ ___________ 0.018163 03-Jun-2014 0.91476 11-Jun-2014 0.90892 19-Jun-2014 0.11466 25-Jun-2014 0.94165 26-Jun-2014

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by