Importing data from multiple .dat files into an array
11 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Victoria Dutch
am 16 Mär. 2020
Kommentiert: Ameer Hamza
am 16 Mär. 2020
I have several hundred .dat files (saved in folders of ~15 for each geographic location they represent) that I want to add to my structural array, with each column as a field:
ie. the column headed density becomes
TVC.Date.Location.SMP.Profiles.Number.density_smp
However, my .dat files have 4 rows of metadata and then the headers before the data I need starts.
I've created a filelist for the first folder containing the .dat files and then tried
% pit RP_04
cd 'G:\Uni_Work\PHD\Data\Trail Valley Creek\Winter 2018-19\January 2019\SMP\Processed\RP_04';
FileList39 = dir('*.dat'); % generate a list of filenames which can be used to generate locations of profiles
Data_and_Headers = importdata(FileList39(1), '\t');
I've tried "ImportData" and "ReadTable" which I saw suggested on here, and had no luck with either. Any suggestions?
0 Kommentare
Akzeptierte Antwort
Ameer Hamza
am 16 Mär. 2020
Bearbeitet: Ameer Hamza
am 16 Mär. 2020
Try readmatrix and specify the number of header lines
readmatrix(FileList39(1).name, 'NumHeaderLines', 5)
or readtable with
readtable(FileList39(1).name, 'HeaderLines', 5)
4 Kommentare
Ameer Hamza
am 16 Mär. 2020
Have you read the files using readmatrix or readtable? readmatrix already outputs a matrix, for readtable you can use table2array.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!