Column labels with source names
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
Julio Martín
am 1 Jun. 2017
Kommentiert: Walter Roberson
am 19 Jun. 2017
Hi, i have a file like attached. I'd like to show each source name in each column of results (For example If I calculate mean value). Could you tell me how to do? I know I can use fprintf but don't know how Thanks, regards
5 Kommentare
Walter Roberson
am 2 Jun. 2017
You have 8 numeric columns. Should we assume that each column is one channel? At the top you have 8 lines under the source name header: should we assume that those 8 lines are the channel names?
Will the files always have 8 source names and 8 columns?
Akzeptierte Antwort
Walter Roberson
am 18 Jun. 2017
filename = 'BES30_1.txt';
nvars = 8;
fid = fopen(filename, 'rt');
if fid < 0; error('Could not open file "%s"', filename); end
failed_step = false;
while true
thisline = fgetl(fid);
if ~ischar(thisline); failed_step = true; break; end %end of file
if strcmpi(thisline, '[SOURCE NAMES]'); break; end
end
if failed_step; fclose(fid); error('No [SOURCE NAMES] in file'); end
channel_names = cell(1, nvars);
failed_step = false;
for K = 1 : nvars
thisline = fgetl(fid);
if ~ischar(thisline); failed_step = true; break; end %end of file
if isempty(thisline); failed_step = true; break; end %unexpected blank line
channel_names{K} = thisline;
end
if failed_step; fclose(fid); error('Not enough column names in file'); end
failed_step = false;
while true
thisline = fgetl(fid);
if ~ischar(thisline); failed_step = true; break; end %end of file
if strcmpi(thisline, '[DATA]'); break; end
end
if failed_step; fclose(fid); error('No [DATA] in file'); end
fmt = repmat('%f', 1, nvars);
data = cell2mat( textscan(fid, fmt, 'CollectOutput', 1) );
fclose(fid);
data_mean = mean(data);
data_max = max(data);
data_min = min(data);
channel_name_width = max( cellfun(@length, channel_names) );
name_fmt = repmat( sprintf('%%%ds ', channel_name_width), 1, nvars );
name_fmt(end-1:end) = '\n';
data_fmt = repmat( sprintf('%%%.dg ', channel_name_width), 1, nvars );
data_fmt(end-1:end) = '\n';
fprintf(name_fmt, channel_names{:});
fprintf(data_fmt, data_min);
fprintf(data_fmt, data_max);
fprintf(data_fmt, data_mean);
2 Kommentare
Walter Roberson
am 19 Jun. 2017
If the number of lines before each major section is fixed then this could be made notably shorter. Also, part of the length is in error checking.
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import and Analysis finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!