You are now following this question
- You will see updates in your followed content feed.
- You may receive emails, depending on your communication preferences.
Slope of some groups of data separated by NaNs
Accepted Answer
15 Comments
More Answers (1)
Hi @Adi Purwandana,
After reviewing your comments, and analyzing the dataset data_mine.mat in matlab shown below
Name Size Bytes Class Attributes
dx 1x893 7144 double z 1x893 7144 double
You are right that it contains two variables, dx and z. As you mentioned that dx having groups of values separated by NaNs, first import the .mat. file to access the variables as shown in your code snippet. Then, split the dx values into separate groups based on the NaN values. For each group, fit a linear regression model to determine the slope and then visualize each group along with its corresponding slope line. Here is a full code example in MATLAB that accomplishes this:
% Load the dataset load('data_mine.mat');
% Initialize variables dx_groups = {}; z_groups = {}; current_group_dx = []; current_group_z = [];
% Split dx and z into groups based on NaN in dx for i = 1:length(dx) if isnan(dx(i)) if ~isempty(current_group_dx) % Only save if current group is not empty dx_groups{end + 1} = current_group_dx; %#ok<AGROW> z_groups{end + 1} = current_group_z; %#ok<AGROW> current_group_dx = []; % Reset for next group current_group_z = []; % Reset for next group end else current_group_dx(end + 1) = dx(i); %#ok<AGROW> current_group_z(end + 1) = z(i); %#ok<AGROW> end end
% Add last group if it exists if ~isempty(current_group_dx) dx_groups{end + 1} = current_group_dx; %#ok<AGROW> z_groups{end + 1} = current_group_z; %#ok<AGROW> end
% Initialize figure for plotting figure; hold on;
% Analyze each group and plot results for g = 1:length(dx_groups) % Extract current group x = dx_groups{g}; y = z_groups{g};
% Perform linear regression to find slope p = polyfit(x, y, 1); % p(1) is the slope, p(2) is the intercept
% Generate x values for plotting the fitted line x_fit = linspace(min(x), max(x), 100); y_fit = polyval(p, x_fit);
% Plot original data points plot(x, y, 'o', 'DisplayName', ['Group ' num2str(g)]);
% Plot the fitted line plot(x_fit, y_fit, 'LineWidth', 2, 'DisplayName', ['Slope: ' num2str(p(1))]); end
% Finalize plot settings xlabel('dx'); ylabel('z'); title('Slope Analysis of Groups in dx'); legend show; grid on; hold off;
% Display slopes for each group in command window for g = 1:length(dx_groups) fprintf('Group %d: Slope = %.4f\n', g, polyfit(dx_groups{g}, z_groups{g}, 1)); end
Please see attached.
As you will notice that the code starts by loading the data_mine.mat file.It loops through dx, collecting values until a NaN is encountered. Each segment is stored in separate cell arrays (dx_groups and z_groups). For each group of data points, a linear fit is performed using polyfit, which returns coefficients for a linear equation (y = mx + b). For more information on this function, please refer to polyfit
Each group’s data points and corresponding fitted line are plotted. The slopes are displayed in the legend and printed to the console. Adjust visualization parameters (like colors or markers) based on your preferences or specific requirements.
Hope this helps.
Please let me know if you have any further questions.
1 Comment
See Also
Categories
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!An Error Occurred
Unable to complete the action because of changes made to the page. Reload the page to see its updated state.
Select a Web Site
Choose a web site to get translated content where available and see local events and offers. Based on your location, we recommend that you select: .
You can also select a web site from the following list
How to Get Best Site Performance
Select the China site (in Chinese or English) for best site performance. Other MathWorks country sites are not optimized for visits from your location.
Americas
- América Latina (Español)
- Canada (English)
- United States (English)
Europe
- Belgium (English)
- Denmark (English)
- Deutschland (Deutsch)
- España (Español)
- Finland (English)
- France (Français)
- Ireland (English)
- Italia (Italiano)
- Luxembourg (English)
- Netherlands (English)
- Norway (English)
- Österreich (Deutsch)
- Portugal (English)
- Sweden (English)
- Switzerland
- United Kingdom(English)
Asia Pacific
- Australia (English)
- India (English)
- New Zealand (English)
- 中国
- 日本Japanese (日本語)
- 한국Korean (한국어)