how to write for and while loop for my excel data.?? can any one help me..
9 次查看(过去 30 天)
显示 更早的评论
i have daily data of 36 years in 4 columns manner like: 1/1/1950 1/2/1950 1/3/1950..........29/12/200 30/12/2000 31/12/2000 (days in order, months in order, years in order) in that case, i need 4 months data in each year. for example: june, july, august, september months in each year
how can pick that particular data and place it side help me please..
0 个评论
回答(1 个)
ag
2024-11-13,16:41
Hi J,
To extract data for specific months (June, July, August, and September) from your dataset, you can utilise the "ismember" MATLAB function.
The below code snippet demonstrates how to do that:
% Assuming 'data' is a matrix where each row corresponds
% to a day and the columns are [day, month, year, value]
% Define the months of interest (June, July, August, September)
monthsOfInterest = [6, 7, 8, 9];
% Extract rows where the month is one of the months of interest
selectedData = data(ismember(data(:, 2), monthsOfInterest));
For more details, please refer to the following MathWorks documentation: ismember - https://www.mathworks.com/help/matlab/ref/double.ismember.html
Hope this helps!
1 个评论
Voss
2024-11-13,17:49
data = randi(9,5,4)
monthsOfInterest = [6, 7, 8, 9];
% Extract *elements of first column* of data where second column is in [6,7,8,9]
selectedData = data(ismember(data(:,2),monthsOfInterest))
% Extract *rows* of data where second column is in [6,7,8,9]
selectedData = data(ismember(data(:,2),monthsOfInterest),:)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!