How to find selection frequency in a txt file?

Question

MByk 2023-5-1

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955874-how-to-find-selection-frequency-in-a-txt-file

评论： MByk 2023-5-2

Testing.txt

Hello all, I have 10 txt files (I share an example) and each file has a list of selected items. I have 13 items in total. What I want to know is how many times each item was selected but I am getting an error (Input must be a MAT-file or an ASCII file containing numeric data with same number of columns in each row) message. I think the problem is the varying length of each line. How can I fix it? Thanks for the help.

txtFiles = dir('*.txt'); 
nFiles = length(txtFiles);        
for i = 1:nFiles
    txtCnt = load(txtFiles(i).name);            
    fprintf('-----%s-----\n',txtFiles(i).name);
        
    Frq = zeros(1,13);
    for Indx = 1:13
        Frq(Indx) = sum(txtCnt == Indx);
    end
    Results = [1:13; Frq]
    idx = find(Frq > mean(Frq))
end
Error using load
Unable to read file 'Testing.txt'. Input must be a MAT-file or an ASCII file containing numeric data with same number of columns in each row.

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

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2023-5-1

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1955874-how-to-find-selection-frequency-in-a-txt-file#answer_1226649

在 MATLAB Online 中打开

Testing.txt

Do not use load. I would probably use readmatrix. Note that your rows do not all have the same number of elements. These rows are padded with NaN.

data = readmatrix("Testing.txt")
data = 422×5
   6     8   NaN   NaN
   6     8    13   NaN
   6     8    12   NaN
   8   NaN   NaN   NaN
   8    12   NaN   NaN
   8    11   NaN   NaN
   8    13   NaN   NaN
   6     8   NaN   NaN
   6     8    13   NaN
   6     8    12   NaN

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

Cris LaPierre 2023-5-2

在 MATLAB Online 中打开

Error.txt

Looks like MATLAB is trying to guess where the data starts. This is a result of having a different number of values in each row. Use the 'NumHeaderLines' name value pair to indicate that the data starts on the first line.

txtFiles = dir('*.txt'); 
nFiles = length(txtFiles);        
for i = 1:nFiles
    txtCnt = readmatrix(txtFiles(i).name,'NumHeaderLines',0)
    fprintf('-----%s-----\n',txtFiles(i).name);
        
    Frq = zeros(1,13);
    for Indx = 1:13
        Frq(Indx) = sum(txtCnt == Indx,'all');
    end
    Results = [1:13; Frq]
    idx = find(Frq > mean(Frq))
end
txtCnt = 13×4
     5     7    13   NaN
     5    10   NaN   NaN
     1     5     7   NaN
     1     5     7    10
     1     5    10   NaN
     1     5    13   NaN
     7    10    13   NaN
    10    13   NaN   NaN
     7    10   NaN   NaN
     1     7    13   NaN
-----Error.txt-----
Results = 2×13
     1     2     3     4     5     6     7     8     9    10    11    12    13
     8     0     0     0     6     0     7     0     0     8     0     0     6
idx = 1×5
     1     5     7    10    13

MByk 2023-5-2

I spent hours trying to find hidden/special characters that could cause the error. :) I also tested xls format that resulted in same error. Thank you again.

请先登录，再进行评论。