Column labels with source names

Question

Julio Martín 2017-6-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342791-column-labels-with-source-names

评论： Walter Roberson 2017-6-19

BES30_1.txt

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 个评论
显示 3更早的评论隐藏 3更早的评论

Walter Roberson 2017-6-2

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?

Julio Martín 2017-6-18

Hi yes, each column is one channel, and yes, those 8 lines are the channel names Thanks

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2017-6-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/342791-column-labels-with-source-names#answer_271065

在 MATLAB Online 中打开

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);