hi there so i have this set of data :
all_data1 = importdata("owid-covid-data_2020-21.csv");
num_data1 = all_data1.data;
text_data1 = all_data1.textdata;
days_tarcked= num_data1(:,1);
total_case= num_data1(:,2);
total_death= num_data1(:,3);
code_id = string(text_data1((2:end),1));
continent = string(text_data1((2:end),2));
location_countries = string(text_data1((2:end),3));
data_countries = string(text_data1((2:end),4));
that is about the days tracked by different countries for tracking there number of cases, and im trying to extract the countries that didnt have at leaset 396 entries for there days track from variable days track and location_countries.
any hint or suggestions will be appreciated.

댓글 수: 2

KSSV
KSSV 2022년 5월 18일
Attach your data and tell us what you want. It can be achieved with few steps depending on how data is and how it is read.
Zakarya Haidari
Zakarya Haidari 2022년 5월 20일
so if you have look at the excel sheet, there are

댓글을 달려면 로그인하십시오.

답변 (1개)

David Hill
David Hill 2022년 5월 20일

0 개 추천

t=readtable('owid-covid-data_2020-21.csv');
u=unique(t.Location);
count=0;
for k=1:length(u)
m=movsum(diff(t.TotalCases(ismember(t.Location,u(k)))),3);
if all(m<396)
count=count+1;
C{count}=u{k};
end
end

카테고리

도움말 센터File Exchange에서 Time Series Events에 대해 자세히 알아보기

제품

질문:

2022년 5월 17일

댓글:

2022년 5월 26일

Community Treasure Hunt

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

Start Hunting!

Translated by