plot textdata with NaN

2022 5 15
5 个回答
更新时间：2022 5 20
7 次查看（30 天）

0 个投票

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 个评论
显示 3更早的评论 隐藏 3更早的评论

Dyuman Joshi
Dyuman Joshi 2022-5-15
What does 'Infinitely long text data' mean? Is the data bounded? Periodic?
You can change the NaN values to zero by
data(isnan(data)=0;
John fredson
John fredson 2022-5-18
how to plot textdata on subplot?
KSSV
KSSV 2022-5-18
Use plot
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

0 个投票

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 个评论
显示 -1更早的评论 隐藏 -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

0 个投票

Give up on reading the file that way. Use readable() instead.
KSSV
KSSV 2022-5-18
Ran in:

0 个投票

Ran in:
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
Ran in:
Ran in:
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

0 个投票

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 个评论
显示 4更早的评论 隐藏 4更早的评论

Walter Roberson
Walter Roberson 2022-5-19
The Location in the data is country names such as 'Kenya', not single character codes such as 'E'
John fredson
John fredson 2022-5-19
I know the variable I coded is in full form but due to policy I can't show the full code so I cut it a bit
John fredson
John fredson 2022-5-19
can you guys suggest what's wrong with this code?
Voss
Voss 2022-5-19
Ran in:
Ran in:
Your table is T (T1, T2, ...) but sometimes you refer to it as X (X1, X2, ...), but X (X1, X2, ...) is not defined.
T = readtable('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.
id_a = strcmp(T.Location,'Afghanistan');
T1 = T(id_a,:) ;
id_A = strcmp(T.Location,'Angola');
T2 = T(id_A,:) ;
plot(T1.DaysTracked, T1.TotalCases,'b-', T2.DaysTracked, T2.TotalCases,'r-')
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
Ran in:

0 个投票

Ran in:
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()

请先登录，再进行评论。

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by