Importing data from multiple .dat files into an array
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Victoria Dutch
el 16 de Mzo. de 2020
Comentada: Ameer Hamza
el 16 de Mzo. de 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 comentarios
Respuesta aceptada
Ameer Hamza
el 16 de Mzo. de 2020
Editada: Ameer Hamza
el 16 de Mzo. de 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 comentarios
Ameer Hamza
el 16 de Mzo. de 2020
Have you read the files using readmatrix or readtable? readmatrix already outputs a matrix, for readtable you can use table2array.
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!