How to extract month-wise data from a single column?
3 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Rahul Verma
el 2 de Jun. de 2023
Editada: Dyuman Joshi
el 7 de Jun. de 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 comentarios
Respuesta aceptada
Dyuman Joshi
el 2 de Jun. de 2023
Editada: Dyuman Joshi
el 7 de Jun. de 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)
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!