plot textdata with NaN

2 ビュー (過去 30 日間)
John fredson
John fredson 2022 年 5 月 15 日
コメント済み: Walter Roberson 2022 年 5 月 20 日
May I know
How to assign a zero to a NaN data in a infinitely long text data
how to plot a infitely long text data which contain NaN?
  5 件のコメント
John fredson
John fredson 2022 年 5 月 18 日
The data plotted is textdata and this occured, how to solve it?
KSSV
KSSV 2022 年 5 月 18 日
Attach your data nd show us your full code.

サインインしてコメントする。

回答 (5 件)

John fredson
John fredson 2022 年 5 月 18 日
X = importdata('owid-covid-data_2020-21.csv');
d_tracked = X.textdata(1:32,5);
t_case = X.textdata(1:32,6);
t_death = X.textdata(1:32,7);
t_case = string(total_case);
t_death = string(total_death);
D_tracked = string(day_tracked);
figure
subplot(1,2,1)
plot(t_case,d_tracked,'b-')
set(gca, 'YScale', 'log')
xlabel('accumulated cases')
ylabel('tracked,')
title('ccumulated cases vstracked')
subplot(1,2,2)
plot(t_death,d_tracked,'r-')
set(gca, 'YScale', 'log')
xlabel('accumulated deaths')
ylabel('tracked,')
title('accumulated death vs tracked')
  1 件のコメント
Walter Roberson
Walter Roberson 2022 年 5 月 18 日
plot(t_death,d_tracked,'r-')
both of those variables are string arrays. What would it mean to plot one against the other?
Perhaps you want to categorical() and scatter()?

サインインしてコメントする。


Walter Roberson
Walter Roberson 2022 年 5 月 18 日
Give up on reading the file that way. Use readable() instead.

KSSV
KSSV 2022 年 5 月 18 日
Read about readtable.
T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1002155/owid-covid-data_2020-21.csv');
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
plot(T.Date,T.TotalCases)
  2 件のコメント
John fredson
John fredson 2022 年 5 月 18 日
bro how you generate this? can teach me?
KSSV
KSSV 2022 年 5 月 18 日
Read csv fille into Table using readtable. Go through this function. It works well. As an example, check how I am plotting India data alone from the table.
T = readtable('https://in.mathworks.com/matlabcentral/answers/uploaded_files/1002155/owid-covid-data_2020-21.csv');
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
idx = strcmp(T.Location,'India') ; % get indices of India
T1 = T(idx,:) ; % data for India alone
plot(T1.Date,T1.TotalCases,'r')
hold on
plot(T1.Date,T1.TotalDeaths,'b')
legend('Total cases','TotalDeath')
title('India')

サインインしてコメントする。


John fredson
John fredson 2022 年 5 月 19 日
T = readtable('owid-covid-data_2020-21.csv');
id_a = strcmp(X.Location,'a');
T1 = T(id_a,:) ;
id_A = strcmp(X.Location,'A');
T2 = T(id_A,:) ;
id_E = strcmp(X.Location,'E');
T3 = T(id_E,:) ;
id_S = strcmp(X.Location,'S');
T4 = T(id_S,:) ;
id_N = strcmp(X.Location,'N');
T5 = T(id_N,:) ;
id_O = strcmp(X.Location,'O');
T6 = T(id_O,:) ;
plot(X1.DaysTracked, X1.TotalCases,'b-', X2.DaysTracked, X2.TotalCases,'r-', X3.DaysTracked, X3.TotalCases,'k-', X4.DaysTracked, X4.TotalCases,'g-', X5.DaysTracked, X5.TotalCases,'p-', X6.DaysTracked, X6.TotalCases,'m-')
Why this code cannot run
  6 件のコメント
John fredson
John fredson 2022 年 5 月 19 日
but data must take the continent
Voss
Voss 2022 年 5 月 19 日
I plotted TotalCases vs DaysTracked, like you did.
How should Continent be taken into account?

サインインしてコメントする。


Walter Roberson
Walter Roberson 2022 年 5 月 19 日
T = readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/1002155/owid-covid-data_2020-21.csv', 'VariableNamingRule', 'preserve');
G = findgroups(T.Continent);
hold on
splitapply(@(dt, tc, cont) plot(dt, tc, 'DisplayName', cont(1)), T.('Days Tracked'), T.('Total Cases'), string(T.Continent), G);
hold off
xlim auto; ylim auto
legend show
Why do there appear to be a lot more than 6 lines? Well, you have a number of different locations within each continent, and each one of those has a full range of days tracked, so when you put the data for all those locations together as one line, the days information keeps resetting.
If this is not the output you were looking for, then you should be more specific. For example were you wanting to total over all locations within each continent ?
  2 件のコメント
John fredson
John fredson 2022 年 5 月 20 日
how to sum up variable variables in one column of the table read by readtable
Walter Roberson
Walter Roberson 2022 年 5 月 20 日
I suggest that you look at groupsummary()

サインインしてコメントする。

カテゴリ

Help Center および File ExchangePolar Plots についてさらに検索

タグ

Community Treasure Hunt

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

Start Hunting!

Translated by