How do I plot specific data from an export excel file?

I have a excel file with data which contains category and value. For example: Canada---3---30, Canada---4---40, Italy---3---20

I would like to plot the data only for the country I want, I use 'location=input('location=')', and would like the graph to only show the data for the location I typed for my plot(x,y).

How should I do that? Thank you.

[Sudhakar Shinde]

You can use readtable and plot / bar functions. You could add excel data example and what you have written meanwhile to achieve this question.

Answer 1

[Sudhakar Shinde]

Example:

Then you need plot of Value1 vs Value2 of country 'Canada' :

table=readtable('test1.xlsx');
Data= contains((table.Country),'Canada');
plot(table.Value1(Data),table.Value2(Data);)

[Wong En Xin]

Hi, thank you for your reply, however my table has many locations (up to hundreds), and all locations with hundreds of value1 and value2, is there a short cut? And I would like to link it with location=input('location=') where it just plots the location I input. Thank you so much!

[Sudhakar Shinde]

If you could add your example data excel sheet, you may get more proper way.

[Wong En Xin]

[Wong En Xin]

HI, this is it, would like to plot days_tracked against total case but only the country I input

[Sudhakar Shinde]

country = input('Input Country: ','s');
Data= contains((table.location),country); %Filter the data with location input
plot(table.days_tracked(Data),table.total_cases(Data)); %Plot days_tracked vs total_cases 
% for input location

Above code lines will serve ur purpose.

[Wong En Xin]

Thank you!