Select Data Column With Header are not in the first row
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Tyann Hardyn
il 2 Mag 2021
Commentato: Tyann Hardyn
il 4 Mag 2021
Hi,
I wanna read each data in columns but the header were not in the first row. The headers are located in the 13th row right after 12 introduction headers above it. The data format are like these :
Format IAGA-2002 |
Source of Data |
Station Name |
IAGA Code ABK |
Geodetic Latitude -68.367 |
Geodetic Longitude 18.817 |
Elevation |
Reported XYZF |
Sensor Orientation |
Digital Sampling |
Data Interval Type PT1M |
Data Type DEFINITIVE |
DATE TIME DOY ABKX ABKY ABKZ ABKF |
1989-11-01 00:00:00.000 305 11575.00 746.00 51129.00 99999.00 .............. (Column Data which i want to read or plot)
1989-11-01 00:01:00.000 305 11575.00 747.00 51132.00 99999.00
1989-11-01 00:02:00.000 305 11576.00 750.00 51134.00 99999.00
1989-11-01 00:03:00.000 305 11576.00 749.00 51135.00 99999.00
1989-11-01 00:04:00.000 305 11575.00 750.00 51137.00 99999.00
How do i select or plot data column in the DATE header and ABKZ header?
Thank you very much.
0 Commenti
Risposta accettata
Mathieu NOE
il 3 Mag 2021
hello
see below example :
opts = detectImportOptions("Document1.txt","NumHeaderLines",12);
opts.SelectedVariableNames = ["DATE","ABKZ"];
T = readtable("Document1.txt",opts)
C = table2cell(T);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Cluster Configuration 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!