how can I plot particular rows of a matrix?

84 views (last 30 days)
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!

Accepted Answer

Basil C.
Basil C. on 10 Jul 2019
Edited: Basil C. 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

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,:))

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
Basil C.
Basil C. 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.

Community Treasure Hunt

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

Start Hunting!