How to import dates?
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Vinicius Teixeira
el 4 de Mayo de 2020
Comentada: Vinicius Teixeira
el 5 de Mayo de 2020
I have a database in excel like numbers, text and dates and I am not able to import the dates correctly. I'm using the following code
path(path, 'C:\Users\vinic\thesis\Matlab')
[data, textdata, rawdata]=xlsread('Teste',1);
Viewing rawdata the dates were imported as follows. However, the first date didn’t come just the day
'Time Stamp'
'01/06/2017'
'01/06/2017 00:10:00'
'01/06/2017 00:20:00'
'01/06/2017 00:30:00'
'01/06/2017 00:40:00'
'01/06/2017 00:50:00'
'01/06/2017 01:00:00'
'01/06/2017 01:10:00'
'01/06/2017 01:20:00'
'01/06/2017 01:30:00'
How can solve this problem?
I need the first item to appear as follows
'01/06/2017 00:00:00'
1 comentario
dpb
el 4 de Mayo de 2020
The first date is still ok; it was just zero minutes and simply a formatting issue in the spreadsheet.
As the documentation notes, xlsread has been deprecated; I suggest the readtable function instead -- the resulting table will in all likelihood be much easier to work with going forward...if it is time-specific data, converting then to a timetable is probably even better.
Respuesta aceptada
Cris LaPierre
el 5 de Mayo de 2020
If you are unfamiliar with readtable, start by using the import tool. It is on the toolstrip in the Home tab. This video from the Practical Data Science with MATLAB course can help. Once you have the datatypes and formatting set the way you want, import the data, covert the settings to code, or generate an import function for repeated use.
3 comentarios
Cris LaPierre
el 5 de Mayo de 2020
Editada: Cris LaPierre
el 5 de Mayo de 2020
You can use the import tool to create an import function that can be used to automate the import process of all files with the same formatting. The first video I shared showed you how to use the Import Tool. If you do want to create an importing function, this video shows you how to generate and reuse your code.
And if you have a lot of files, this video shows you how to use the import function you have created in conjunction with a datastore to import multiple files.
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets 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!