How to prepare extract monthly Data from a group of data?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
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?
0 Commenti
Risposta accettata
VBBV
il 24 Gen 2023
A = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1272440/AO_1950_2022.xlsx');
A.Properties.VariableNames = {'Year','Month','Data'};
idx=A.Month == 2;
AllFebData = [A.Year(idx) A.Data(idx)]
Più risposte (1)
Arif Hoq
il 24 Gen 2023
a=table2array(readtable("AO_1950_2022.xlsx"));
b=a(:,2)==2;
febmonth=a(b,[1 3]);
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!