How do i change a ISO 861 Date that is beeing immported as categorical to a double or similar?
2 views (last 30 days)
Show older comments
Pavle Markovic on 5 Jan 2023
Answered: Siddharth Bhutiya on 26 Jan 2023
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
Cameron on 5 Jan 2023
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 on 26 Jan 2023
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
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!