New to Matlab- How to import a text file for analysis that contains numbers and characters?

Question

Hedaya Rizeq 2019-12-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498164-new-to-matlab-how-to-import-a-text-file-for-analysis-that-contains-numbers-and-characters

编辑： Stephen23 2019-12-29

I have a text file that has columns that contain both numbers and characters (attached). What function can I use to be able to read the file for further analysis? I need to calculate the average reaction times based the types of stimuli.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Vladimir Sovkov 2019-12-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498164-new-to-matlab-how-to-import-a-text-file-for-analysis-that-contains-numbers-and-characters#answer_407866

If you need it only once (or few times), use the Import utility of Matlab (Home\Import Data - a green downward arrow); chose the output type either "table" or "numeric array" depending on what you want. To work with this kind of files repeatedly, you should write a program using file operations (fopen, fread, fclose, ...) and string processing tools. Check the Matlab documentation.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

Answer 2

Bhaskar R 2019-12-27

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/498164-new-to-matlab-how-to-import-a-text-file-for-analysis-that-contains-numbers-and-characters#answer_407869

在 MATLAB Online 中打开

Using textscan command you can get the required data from the input text file, data would be extracted in the cell data type

try this to extract the data from input file

fmt = '%d\t%d\t%s\t%d\t%d\t%d\t%s\t%d\t%d\t%s\t%s';    % format of the text file
f = fopen('T001_1.txt', 'rt');    % open input file
% get the file data to variable data(cell data type)
data = textscan(f, fmt ,'HeaderLines',1,'CollectOutput',true);
fclose(f);    % close file identifier
%% do your calculation on extracted "data"

5 个评论
显示 3更早的评论隐藏 3更早的评论

Hedaya Rizeq 2019-12-29

编辑：Hedaya Rizeq 2019-12-29

在 MATLAB Online 中打开

Thank you for this. When I ran the code I got an error message (Index in position 2 exceeds array bounds (must not exceed 6)). How can this be fixed?

%%  Opening file to store Analysed data
targetfile= ['Outputfile',date,'.txt'];
fid1 = fopen(targetfile,'w');
fprintf(fid1,'Sub_Number \t Sub_Condition \t Avg_MDC_LB \t Avg_MDC_RB \t Avg_MDC_LG \t Avg_MDC_RG \t Avg_DC_LB \t Avg_DC_RB \t Avg_DC_LG \t Avg_DC_RG \t Percent_Error \n');
%MDC = Misdirectional Cue, DC = Directional Cue, LB = Left Blue, RB = Right Blue,LG
%= Left Green, RG = Right Green
subject_number = {'V001' 'V002' 'V003' 'V004' 'V005'};
subject_condition = {'1' '2'};
for sub_number = 1:length(subject_number)
    for sub_condition = 1:2
         fileName = cell2mat([subject_number(sub_number), '_', num2str(sub_condition) '.txt']);
                            
                % Opening Data File
                fid = fopen(fileName,'r');
                if(fid==-1)
                    continue;
                end
              
                % Allocate imported array to column variable names
                 fmt = '%d%d%s%d%d%d%s%d%d%s%s';    % format of the text file
                
                 fileData = textscan(fid, fmt,'HeaderLines',1,'CollectOutput',true);
  %% Calculate
              CueSecond = fileData (:,1);
              CueMillisecond = fileData (:,2);
              CueType = fileData (:,3);
              CueDuration = fileData (:,4);
              StimulusSecond = fileData (:,5);
              Stimulus_ms = fileData (:,6);
              StimType = fileData (:,7);
              ResponseSecond = fileData (:,8);
              Response_ms = fileData (:,9);
              ResponseType = fileData (:,10);
              ResponseCorrect = fileData (:,11);
              
             
               
                 
   
               
              fprintf(fid1,'%s \t %g \t %g \t %g \t %g \t %g \t %g \t %g \t %g \t %g \t %g \t n',sub_number, sub_condition, Avg_MDC_LB, Avg_MDC_RB, Avg_MDC_LG, Avg_MDC_RG, Avg_DC_LB, Avg_DC_RB, Avg_DC_LG, Avg_DC_RG, Percent_Error);
                 
            
    end
 end
            fclose(fid1);

Hedaya Rizeq 2019-12-29

Thank you, this was very helpful. Also, I haven't realized how tricky it is to perform simple math with numbers stored in cell arrays. Any tips on how I can calculate the mean of (Response_ms - Stimulus_ms)?

Stephen23 2019-12-29

编辑：Stephen23 2019-12-29

在 MATLAB Online 中打开

"How can this be fixed?"

By reading the comment that i wrote two days ago, where I recommended removing the 'CollectOutput' option, and explained why.

"I haven't realized how tricky it is to perform simple math with numbers stored in cell arrays. Any tips on how I can calculate the mean of"

By reading Walter Roberson's comment from four horus ago, which includes the advice to change your cell array indexing (from parentheses to curly braces):

CueSecond      = fileData{1}; % Get the CONTENT of the 1st cell
CueMillisecond = fileData{2}; % Get the CONTENT of the 2nd cell
etc.

You should also revise cell array indexing

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-cell-array.html

请先登录，再进行评论。

New to Matlab- How to import a text file for analysis that contains numbers and characters?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

回答（2 个）

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

Community Treasure Hunt

New to Matlab- How to import a text file for analysis that contains numbers and characters?

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

回答（2 个）

0 个评论 显示 -2更早的评论隐藏 -2更早的评论

5 个评论 显示 3更早的评论隐藏 3更早的评论

另请参阅

类别

标签

Community Treasure Hunt

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

5 个评论
显示 3更早的评论隐藏 3更早的评论