How to extract values from 1x1 cell array

2018 12 23
1 个回答
回答已采纳
更新时间：2018 12 23
6 次查看（30 天）

0 个投票

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

1 个投票

Just use readtable() to read the file

9 个评论
显示 7更早的评论 隐藏 7更早的评论

Aram Eskandari
Aram Eskandari 2018-12-23
Thanks, but that doesn't solve the issue. I've tried using table and extracting it into a list with this;
stock_history = readtable("stock_history.csv")
c_id = stock_history{:,1}
But c_id will become an array instead of a regular list
madhan ravi
madhan ravi 2018-12-23
upload a short sample of your desired output
Aram Eskandari
Aram Eskandari 2018-12-23
not sure how to upload it since I don't have it, but I might be able to explain it a bit better;
if you use readtable("stock_history.csv"), you will get a table with 8 columns/variables. I would like the 1st column to be saved as a list/vector of integers, the 2nd column I want to save as a vector of strings, the 3rd and 6th columns I want to save as a list/vector of doubles.
madhan ravi
madhan ravi 2018-12-23
str2double(T{:,1}) % double array
string(T{:,1}) % string array
Aram Eskandari
Aram Eskandari 2018-12-23
Thank you so much, this worked perfectly!
Guillaume
Guillaume 2018-12-23
"But c_id will become an array instead of a regular list"
There is no list type in matlab, so what is a regular list?
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 个）

类别

在 帮助中心 和 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