removing the text data by only keeping the numerical values

Question

Abhijit Sardar 2021-4-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/809100-removing-the-text-data-by-only-keeping-the-numerical-values

评论： Adam Danz 2021-4-22

D11.csv

I want to remove all the text present before the two columns with numerical values.I have several files like this how can i do it for all the text files at the same time

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

请先登录，再进行评论。

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

Answer 1

Adam Danz 2021-4-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/809100-removing-the-text-data-by-only-keeping-the-numerical-values#answer_681175

Use readtable or readmatrix. Both functions allow you to specify the starting line of the data.

2 个评论
显示无隐藏无

Abhijit Sardar 2021-4-22

how will i do it if it is a text file

Adam Danz 2021-4-22

Those functions are designed to work with text files and other types of files.

Read the documentation, that's why I provided links. There's a bit of a learning curve to using these functions since they have many different options but that's all explained in the documentation along with examples. Walter Roberson's answer shows you how to do this and each of those steps are explained in the links I provided above.

请先登录，再进行评论。

Answer 2

Walter Roberson 2021-4-22

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/809100-removing-the-text-data-by-only-keeping-the-numerical-values#answer_681505

在 MATLAB Online 中打开

filename = 'https://www.mathworks.com/matlabcentral/answers/uploaded_files/592115/D11.csv';
opt = detectImportOptions(filename, 'readvariablenames', false, 'headerlines', 9, 'extracolumnsrule', 'ignore');
t = readtable(filename, opt );
t.Properties.VariableNames = {'X-AXIS', 'Y-AXIS'};
summary(t)
Variables:

    X-AXIS: 2000×1 double

        Values:

            Min             0 
            Median     499.75 
            Max         999.5 

    Y-AXIS: 2000×1 double

        Values:

            Min          -77  
            Median      -0.5  
            Max          104  