How to extract values from 1x1 cell array

18 次查看（过去 30 天）
Aram Eskandari
Aram Eskandari 2018-12-23
评论： madhan ravi 2018-12-23
I've been searching around for a solution to this, there are plenty of people who ask similar questions but none of the solutions have worked for me.
See the attached csv-file, the code I have so far is this;
stock_history = importdata("stock_history.csv");
for i=1:length(stock_history)
row_i = stock_history(i,:);
end
With this code, the variable row_i will be a 1x1 cell array, where the first value is
{'"69","2018-11-30","185.35000","185.65000","183.35000","184.70000","1482674","2018-12-06 11:12:30"'}
In the same for-loop, I would like to save the 1st, 2nd, 3rd, 6th values. So in the example above I would save the values 69, 2018-11-30, 185.35000, 184.70000. I would like to save them into a regular list, for example a list called c_id would save all values from the 1st spot in the cell array, date would be a list with the 2nd values, open_price and close_price would be the 3rd and 6th values.

请先登录，再回答此问题。

采纳的回答

madhan ravi
madhan ravi 2018-12-23
Just use readtable() to read the file
  9 个评论
显示 7更早的评论
Guillaume
Guillaume 2018-12-23
By default readtable interpret quoted text as text. If you want to ignore the quotes and get numbers you either need to tell readtable or easier, let matlab figure it out using detectImportOptions:
opts = detectImportOptions('stock_history.csv');
stock_history = readtable('stock_history.csv', opts);
c_id = stock_history{:, 1};
c_id will be a double column vector.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

产品


版本

R2018a

Community Treasure Hunt

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

Start Hunting!

Translated by