How to load CSV file with space?

18 visualizaciones (últimos 30 días)
Megha
Megha el 2 de Nov. de 2018
Comentada: madhan ravi el 2 de Nov. de 2018
I have a csv file that loads very perfectly from 2nd column onwards.
data = csvread('filename.csv',1,1);
However, in the first column of my data I have date:
the format of the date is
2012/09/15 00:00:00,0,-13.654,...
2012/09/15 00:00:01,0,-18.654,...
2012/09/15 00:00:02,0,-166.654,...
2012/09/15 00:00:03,0,-178.654,...
...
...
...
Here, date is space separated with time. This creates error in loading the file using
data = csvread('filename.csv',1,0);
Can anyone suggest what to do?

Respuesta aceptada

madhan ravi
madhan ravi el 2 de Nov. de 2018
Editada: madhan ravi el 2 de Nov. de 2018
What happens when you use
readtable()
because they are capable of reading dates by default
  11 comentarios
Megha
Megha el 2 de Nov. de 2018
Yes, Thank you
madhan ravi
madhan ravi el 2 de Nov. de 2018
Anytime :) ,if it worked make sure to accept the answer so that people know the question is solved

Iniciar sesión para comentar.

Más respuestas (0)

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by