Wrong date while importing .csv
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Ancalagon8
el 24 de Ag. de 2018
Comentada: Ancalagon8
el 3 de Sept. de 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?
Respuesta aceptada
jonas
el 24 de Ag. de 2018
Editada: jonas
el 24 de Ag. de 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 comentarios
jonas
el 24 de Ag. de 2018
Editada: jonas
el 24 de Ag. de 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!!
Más respuestas (0)
Ver también
Categorías
Más información sobre Data Type Conversion en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!