How do i change a ISO 861 Date that is beeing immported as categorical to a double or similar?

2 次查看（过去 30 天）
Pavle Markovic
Pavle Markovic 2023-1-5
回答： Siddharth Bhutiya 2023-1-26
Hey,
I am helping someone with this, after two days of googling and searching i am kinda lost.
I have a CSV, similar to the snipet i uploaded(the real file is 8GB), and i am trying to get rid of the categorical format. My Workflow as of rn, import data, select delimited, and so on and soforth and choose column vectors. With that, i can do all the other manipulations as i please, but i need the "time" do finish the job.
At this point i am out of ideas and i do not know where to continue searching.
THanks in advance

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

回答（2 个）

Cameron
Cameron 2023-1-5
All I did was use the readtable function and it seemed to work fine. Is there something else that I'm missing?
importTable = readtable('Measurement 47 .csv');
NewDateTime = datetime(extractBefore(strrep(importTable.Time,"T"," "),"."));
Siddharth Bhutiya
Siddharth Bhutiya 2023-1-26
You could use detectImportOptions + readtable to do this. detectImportOptions would allow you to specifiy what the data type of the imported variable should be. Link to doc: detectImportOptions

类别

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

标签

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by