importing excel into matlab

4 ビュー (過去 30 日間)
moji
moji 2015 年 4 月 21 日
回答済み: Star Strider 2015 年 4 月 21 日
I am pretty new to MATLAB, I have these two questions: 1.I want to import two columns of excel spreadsheet into MATLAB. After importing it the cells which had No Value had been set to zero in MATLAB. what can I do to make all those zero values to NaN value?
2. I would like to calculate the median value for every 61 rows, what is the command for this?
Thanks

サインインしてこの質問に回答する。

回答 (1 件)

Star Strider
Star Strider 2015 年 4 月 21 日
1. See the xlsread function.
2. That is a bit more difficult. The usual technique is to use the reshape function to sort the array into (in this instance) a (61xN) matrix (the vectors have to be an integer multiple of 61 rows for this to work), the taking the median of the columns.

カテゴリ

Help Center および File Exchange で Data Import from MATLAB についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by