transform data from rows to columns
2 次查看(过去 30 天)
显示 更早的评论
I have a CSV data file. That looks like below company-----Date--------Price ComA--------15/05/2015--20.5 ComA--------15/06/2015--30 Comb--------15/05/2015--15
I want the companies to be in the columns and dates to be rows. How to do that?
0 个评论
采纳的回答
Shameer Parmar
2016-6-21
If you have variable 'data' like..
data = {'company-----Date--------Price', 'ComA--------15/05/2015--20.5', 'ComA--------15/06/2015--30', 'Comb--------15/05/2015--15'}
then
following command give you the expected result in column..
data = data';
output will be as follows:
data =
'company-----Date--------Price'
'ComA--------15/05/2015--20.5'
'ComA--------15/06/2015--30'
'Comb--------15/05/2015--15'
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Portfolio Optimization and Asset Allocation 的更多信息
产品
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!