MATLAB Answers

0

how can I plot particular rows of a matrix?

Asked by Tran Trang on 10 Jul 2019
Latest activity Commented on by Tran Trang on 11 Jul 2019
I have a 7208x34 matrix which columns [3 32] represent price data over the 1961-1990 period. And a row array 1x30 (the row array indicates the years from 1961 to 1990). I want to plot time series of 68 rows (i.e. grouping by cities) for each goods over the 1961-1990 period, against the 1x30 row array (years). Something looks like this:
Goods city_name price_year1961 price_year1962…
A city1 0.5
A city2 0.7
.
.
.
A city68 0.9
B city1 0.4
B city2 0.7
.
.
.
B city68 0.9
and a row vector represents the years [1961:1990].
Thank you very much!

  0 Comments

Sign in to comment.

3 Answers

Answer by Be Matlabi on 10 Jul 2019
Edited by Be Matlabi on 11 Jul 2019
 Accepted Answer

You could first start by reading the columns into an array
data=readtable('Price.txt');
prices=data(:,3:30);
n=5; %in order to plot the data for city 5
city_data=prices(n:68:end,:)
year=1961:1990;
If you want to plot for individual Good
good=3 % for the data of Good 3
plot(year,city_data(good,:))
For all the goods
for i=1:size(city_data,1)
plot(year,city_data(i,:))
hold on
end

  0 Comments

Sign in to comment.


Answer by KSSV
on 10 Jul 2019

If A is your data...and you want to plot ith row; use
plot(A(i,:))

  0 Comments

Sign in to comment.


Answer by Tran Trang on 10 Jul 2019
Edited by Tran Trang on 10 Jul 2019

Hi B Matlabi,
Thank you for your reply. should it be city_data = prices(n:68:end,:), instead of city_data = prices(n:n:end,:), as the city repeats after 68 rows?
And how can I plot all the goods but with each plot for each good?
Thank you.

  2 Comments

Yes you are correct, it should be
city_data = prices(n:68:end,:)
In order to plot all the goods but with each plot for each good at once you could try the subplot function
Thank you very much!

Sign in to comment.