How to read row1 as datetime
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Yasuyuki Hamanaka
le 24 Mai 2021
Commenté : Yasuyuki Hamanaka
le 29 Mai 2021
I read below table using readtable(). I wnat to read first and second column of the first row as string. But after the third clumn, I want to read data as datetime. And other data should be read as double. How can I do that?
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/629030/image.png)
0 commentaires
Réponse acceptée
Uday Pradhan
le 27 Mai 2021
Modifié(e) : Uday Pradhan
le 27 Mai 2021
Hi,
To read the first row in the specified format, you could try:
t = readtable('yourDataOnlyRow1','Format','%s %s %{mm/dd/yyyy HH:MM}D %{mm/dd/yyyy HH:MM}D %{mm/dd/yyyy HH:MM}D','TextType','string','ReadVariableNames',false)
where the file yourDataOnlyRow1 contains only the first row of your data. For the rest of the data, you could do:
t1 = readtable('yourData','Format','%f%f%f%f%f','ReadVariableNames',false,'HeaderLines',1) %exclude the first row from the original data file
These two table cannot be joined due to conflicting data types. Perhaps try reformatting your data and have a look at the following documentation pages:table2timetable,readtable.
Note:To get the data as a table with text entries, try:
>> t1 = readtable('yourData.txt','Format','auto')
t1 =
2×5 table
Var1 Var2 Var3 Var4 Var5
____________ ______________ __________________ __________________ __________________
{'Depth ()'} {'Channel ()'} {'4/5/2018 11:10'} {'4/5/2018 12:10'} {'4/5/2018 12:12'}
{'1' } {'2' } {'3' } {'4' } {'5' }
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!