How to plot a specific data range in a xlsx-file
24 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hendrik Lange
le 16 Juin 2021
Commenté : Hendrik Lange
le 21 Juin 2021
Hi guys,
i have a big Excel-table (7200000x5), which consists frequencies of a heatpump over a time period. I want to use the fft to analyse the data. But how am i able plot not the wholw datasheet.( for example, from 1-5000? ) Thanks for your help!
0 commentaires
Réponse acceptée
Divija Aleti
le 21 Juin 2021
Hi Hendrik,
The input array to the function 'fft' can be either a vector or a matrix. Firstly, you can create a table using the data in the excel sheet with the function 'readtable'.
Then, you can choose only those rows and columns for which you want to analyse the data.
For example, let A be the table with the data. To use rows 1 to 5000 and all columns, the syntax is:
Y = fft(A(1:5000,:));
To use rows 2500 to 10000 and columns 2 to 4, the syntax is:
Y = fft(A(2500:10000,2:4));
For additional information on the functions used here, refer to the following links:
Hope this helps!
Regards,
Divija
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Bartlett dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!