How to read row1 as datetime
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Yasuyuki Hamanaka
il 24 Mag 2021
Commentato: Yasuyuki Hamanaka
il 29 Mag 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?
0 Commenti
Risposta accettata
Uday Pradhan
il 27 Mag 2021
Modificato: Uday Pradhan
il 27 Mag 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' }
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Tables in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!