importing excel into matlab

2 次查看（过去 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