清空筛选条件
清空筛选条件

Importing data from multiple .dat files into an array

6 次查看（过去 30 天）
Victoria Dutch
Victoria Dutch 2020-3-16
评论： Ameer Hamza 2020-3-16
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?

请先登录，再回答此问题。

采纳的回答

Ameer Hamza
Ameer Hamza 2020-3-16
编辑：Ameer Hamza 2020-3-16
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 个评论
显示 2更早的评论
Victoria Dutch
Victoria Dutch 2020-3-16
Thanks. I think this gets me half way there. How would I then save column from this double as matrices?
Ameer Hamza
Ameer Hamza 2020-3-16
Have you read the files using readmatrix or readtable? readmatrix already outputs a matrix, for readtable you can use table2array.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2019a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by