How to prepare extract monthly Data from a group of data?

조회 수: 1 (최근 30일)
Rahul Verma
Rahul Verma 2023년 1월 24일
댓글: Rahul Verma 2023년 1월 24일
I have an excel file, containing monthly data of several years column-wise. Now i have to extract the data for perticular month (say February month from all the years). I want to write a code which can extract the data in aforementioned manner.
I have attached the excel file for better understanding. Descroption of data: The excel file contains years, months and data values. First column is year (1950-2022), second column- respective months and thrird column has values.
Now i want to extract the February month data from all the years. How can i do it?

채택된 답변

VBBV 2023년 1월 24일
A = readtable('');
A.Properties.VariableNames = {'Year','Month','Data'};
idx=A.Month == 2;
AllFebData = [A.Year(idx) A.Data(idx)]
AllFebData = 73×2
1.0e+03 * 1.9500 0.0006 1.9510 -0.0004 1.9520 -0.0017 1.9530 -0.0002 1.9540 -0.0002 1.9550 -0.0015 1.9560 -0.0020 1.9570 -0.0015 1.9580 -0.0022 1.9590 0.0025

추가 답변 (1개)

Arif Hoq
Arif Hoq 2023년 1월 24일
febmonth=a(b,[1 3]);


Help CenterFile Exchange에서 Spreadsheets에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by