Attempting to automate the importing of text file data
조회 수: 2 (최근 30일)
이전 댓글 표시
I am trying to automate the importing of text file data. How can I call each individual text file name, which is variable, in the readtable function? I have a variable with each textfile name, but am having difficulty using that in the readtable function. Is that a good way to do it? Im not even sure. I attached two text files for examples, any help is appreciated.
textfiles = dir('*.txt');
numboffiles = length(textfiles);
filelist = {ones(1:numboffiles)};
for j =1:numboffiles
filelist(j) = {textfiles(j).name};
end
data = ones(length(filelist));
for i = 1:length(filelist)
fid = fopen(filelist{i});
if fid == -1
fprintf ('Wrong File Name');
else
data(i) = readtable(filelist(j), 'Delimiter', '\t', 'ReadVariableNames',false, 'HeaderLines', 9);
end
end
댓글 수: 2
KSSV
2019년 3월 22일
YOu can read your file with readtable.......
but am having difficulty using that in the readtable function what difficulty?
You already asked multiple questions int he same context of text file...but you have neevr discussed or acknowledges your previous questions. You should discuss at your previous questions..if you are happy with the answer provided ..accept the answer then you can ask a different question.
채택된 답변
Andrei Bobrov
2019년 3월 22일
%Let directory 'data' have your files: 40_8deg_HL_Both.txt and 40_4deg_HL_Both.txt
n = dir('path_to_data/data/*Both.txt');
m = numel(n);
T = cell(m,1);
vn = {'Data_Timestamp','q','V_ref','Alpha','NFonSF','AFonAF2','PMonYM','P','Orientation'};
for ii = 1:m
T{ii} = readtable(n(1).name,'ReadVariableNames',0,...
'Format','%{yyyyMMdd HH:mm:ss.SSS}D %f %f %f %f %f %f %f %q',...
'HeaderLines',9);
T{ii}.Properties.VariableNames = vn;
end
%or other for-loop
for ii = 1:m
T{ii} = readtable(n(1).name,'ReadVariableNames',0,...
'Format','%q %q %f %f %f %f %f %f %f %q','HeaderLines',9);
T{ii}.Var1 = datetime(strcat(T{ii}{:,1},'_',T{ii}{:,2}),'I','uuuuMMdd_HH:mm:ss.SSS');
T{ii}.Var2 = [];
T{ii}.Properties.VariableNames = vn;
end
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Language Support에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!