Wrong date while importing .csv
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Ancalagon8
am 24 Aug. 2018
Kommentiert: Ancalagon8
am 3 Sep. 2018
Having a problem when i import daily .csv files. More specifically, when i plot my xy data(x axis contains date and time stamp), in every different daily file, MATLAB shows todays date. Any ideas?
Akzeptierte Antwort
jonas
am 24 Aug. 2018
Bearbeitet: jonas
am 24 Aug. 2018
The date is not automatically assigned because it's not in the data but in the name of the file. You could do something like this:
files=dir('folderpath~\*.csv');
for i=1:length({files.name})
date=files(i).name;
date=regexprep(date,'.csv','')
data=readtable(files(i).name);
t{i}=data{:,1}+datetime(date);
xy{i}=data{:,2:3}
end
Now you have two cell arrays, t and xy, where the former has all time data and the latter all other data.
18 Kommentare
jonas
am 24 Aug. 2018
Bearbeitet: jonas
am 24 Aug. 2018
You're welcome! Note that you can just remove the curly braces from the t{i} if you want to achieve that. I put the results in a cell array as I figured you have several data sets that you want to load and store.
Also, don't use datetime as a variable name!!
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Type Conversion finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!