MATLAB Answers

how can I plot particular rows of a matrix?

33 views (last 30 days)
Tran Trang
Tran Trang on 10 Jul 2019
Commented: 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.

Accepted Answer

Be Matlabi
Be Matlabi on 10 Jul 2019
Edited: Be Matlabi on 11 Jul 2019
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.

More Answers (2)

KSSV
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.


Tran Trang
Tran Trang on 10 Jul 2019
Edited: 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

Be Matlabi
Be Matlabi on 11 Jul 2019
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

Sign in to comment.


Translated by