Clear Filters
Clear Filters

Extracting data from txt file

2 views (last 30 days)
Wai Jye Chan
Wai Jye Chan on 13 May 2020
Edited: Walter Roberson on 13 May 2020
Hi, I have a raw data file where there's two variable - F & R. I would like to extract the specific value of R when F is at 5, 10, 15, 20. what should I do? Please help me with the coding. I'm new in Matlab. Thank you.
  1 Comment
Walter Roberson
Walter Roberson on 13 May 2020
What does the data file look like? Please be specific about information such as whether it is tab separated columns.
Will those exact values of F appear in the file, or do you need to interpolate the values?

Sign in to comment.

Answers (1)

Walter Roberson
Walter Roberson on 13 May 2020
Edited: Walter Roberson on 13 May 2020
filename = 'AppropriateFileName';
data = sortrows( load(filename) );
F = data(:,1);
R = data(:,2);
probe_at = 5:5:20;
interpolated_R = interp1(F, R, probe_at);
I note that you want F at 15 and 20, which are beyond the range of F in the sample you post. If the data does not extend as far as 15 or 20 then the above code would return NaN in those positions. Extrapolation is possible by adding extra options to the interp1() call, but you should consider more about what kind of extrapolation is appropriate; I can see that you have something non-linear going on in the response.

Categories

Find more on Variables in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!