Filter löschen
Filter löschen

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

5 Ansichten (letzte 30 Tage)
Wong En Xin
Wong En Xin am 27 Okt. 2020
Kommentiert: Wong En Xin am 28 Okt. 2020
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.
  1 Kommentar
Sudhakar Shinde
Sudhakar Shinde am 27 Okt. 2020
You can use readtable and plot / bar functions. You could add excel data example and what you have written meanwhile to achieve this question.

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Sudhakar Shinde
Sudhakar Shinde am 27 Okt. 2020
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);)
  6 Kommentare
Sudhakar Shinde
Sudhakar Shinde am 28 Okt. 2020
Bearbeitet: Sudhakar Shinde am 28 Okt. 2020
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.

Melden Sie sich an, um zu kommentieren.

Kategorien

Mehr zu 2-D and 3-D Plots finden Sie in Help Center und File Exchange

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by