How to extract month-wise data from a single column?
2 visualizzazioni (ultimi 30 giorni)
Mostra commenti meno recenti
Rahul Verma
il 2 Giu 2023
Modificato: Dyuman Joshi
il 7 Giu 2023
I have an excel file, containing monthly data of several years in one single column. 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 the data values in single column. There are total 904 rows (indicating 904 months).
Now i want to extract the February month data from all the years. How can i do it?
I have attached the data file in excel format.
0 Commenti
Risposta accettata
Dyuman Joshi
il 2 Giu 2023
Modificato: Dyuman Joshi
il 7 Giu 2023
Make sure that the excel is present in the current directory and MATLAB has access to it.
file = readmatrix('Wind1948to2023.xlsx');
FebData = file(2:12:end)
Più risposte (0)
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!