#100DaysOfCode

Day 55: Coronavirus popular patients chronic disease by fatal cases

#100DaysOfCode #wolframlang #wolflang #DataScience #Code #Programming #ImageProcessing

By Daniel Carvalho - @danielscarvalho

In[]:=

ResourceObject["Patient Medical Data for Novel Coronavirus COVID-19"]covid=Dataset[%]

Out[]=

ResourceObject

Name: Patient Medical Data for Novel Coronavirus COVID-19 »
Type: DataResource
Description: Medical records of patients infected with novel coronavirus COVID-19



Out[]=

Age	Sex	City	AdministrativeDivision	Country	GeoPosition	DateOfOnsetSymptoms	DateOfAdmissionHospital	DateOfConfirmation	Symptoms	LivesInWuhan	LivesInWuhanComment	TravelHistoryDates	TravelHistoryLocation	ReportedMarketExposure	ReportedMarketExposureComment	ChronicDiseaseQ	ChronicDiseases	SequenceAvailable	DischargedQ	DeathQ	DateOfDeath	DateOfDischarge
30	male	Hefei	Anhui, China	China	31.65°N 117.8°E	Sat 18 Jan 2020	Mon 20 Jan 2020	Wed 22 Jan 2020	—	True	—	 Fri 17 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
47	male	Hefei	Anhui, China	China	31.83°N 117.2°E	Fri 10 Jan 2020	Tue 21 Jan 2020	Thu 23 Jan 2020	—	False	—	 Fri 10 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
49	male	Hefei	Anhui, China	China	31.83°N 117.2°E	Wed 15 Jan 2020	Mon 20 Jan 2020	Thu 23 Jan 2020	—	False	—	 Fri 10 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
47	female	Hefei	Anhui, China	China	31.83°N 117.2°E	Fri 17 Jan 2020	Mon 20 Jan 2020	Thu 23 Jan 2020	—	False	—	—	—	—	—	—	—	—	—	—	—	—
50	female	Hefei	Anhui, China	China	31.83°N 117.2°E	Fri 10 Jan 2020	Tue 21 Jan 2020	Thu 23 Jan 2020	—	False	—	 Tue 7 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	—	Luan	Anhui, China	China	31.73°N 116.5°E	—	—	Fri 24 Jan 2020	{pneumonia}	—	—	—	—	—	—	—	—	—	—	—	—	—
42	female	Fuyang	Anhui, China	China	32.89°N 115.8°E	Tue 21 Jan 2020	Tue 21 Jan 2020	Wed 22 Jan 2020	{fever}	False	—	 Sun 19 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	female	Huaibei	Anhui, China	China	33.94°N 116.8°E	—	—	Sat 25 Jan 2020	—	False	—	 Mon 13 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
59	female	Huainan	Anhui, China	China	32.62°N 117.0°E	Sun 19 Jan 2020	Fri 24 Jan 2020	Sun 26 Jan 2020	{fever}	True	—	 Wed 22 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
30	male	Hefei	Anhui, China	China	31.83°N 117.2°E	Fri 17 Jan 2020	Wed 22 Jan 2020	Thu 23 Jan 2020	—	True	—	 Tue 21 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	—	Luan	Anhui, China	China	31.73°N 116.5°E	—	—	Thu 23 Jan 2020	{pneumonia}	—	—	—	—	—	—	—	—	—	—	—	—	—
39	male	Fuyang	Anhui, China	China	32.89°N 115.8°E	—	Mon 20 Jan 2020	Thu 23 Jan 2020	—	False	—	 Fri 17 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	—	Anqing	Anhui, China	China	30.53°N 117.1°E	—	—	Thu 23 Jan 2020	—	—	—	—	—	—	—	—	—	—	—	—	—	—
38	female	Chizhou	Anhui, China	China	30.66°N 117.5°E	Wed 22 Jan 2020	Wed 22 Jan 2020	Thu 23 Jan 2020	{cough}	True	—	 Sun 19 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
45	male	Bengbu	Anhui, China	China	32.92°N 117.4°E	Tue 21 Jan 2020	Tue 21 Jan 2020	Mon 27 Jan 2020	{fever}	True	—	 Sun 19 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	—	—	Beijing, China	China	40.22°N 116.2°E	—	—	Tue 21 Jan 2020	—	—	—	—	—	—	—	—	—	—	—	—	—	—
—	—	—	Beijing, China	China	40.22°N 116.2°E	—	—	Tue 21 Jan 2020	—	—	—	—	—	—	—	—	—	—	—	—	—	—
33	female	—	Beijing, China	China	39.96°N 116.5°E	—	Mon 20 Jan 2020	Wed 22 Jan 2020	{fever}	True	—	 Sat 18 Jan 2020 	 Wuhan 	—	—	—	—	—	—	—	—	—
—	female	—	Beijing, China	China	39.66°N 116.4°E	Wed 8 Jan 2020	Wed 8 Jan 2020	Tue 21 Jan 2020	{fatigue,fever,headache}	False	—	 Wed 8 Jan 2020 	 Wuhan 	—	—	—	—	—	True	—	—	Fri 24 Jan 2020
—	—	—	Beijing, China	China	39.66°N 116.4°E	—	—	Tue 21 Jan 2020	—	—	—	—	—	—	—	—	—	—	—	—	—	—
showing 1–20 of 26961

In[]:=

{c=covid[Select[!MissingQ[#ChronicDiseaseQ]&&!MissingQ[#DeathQ]&],{"ChronicDiseaseQ","DeathQ","ChronicDiseases"}],WordCloud[Flatten[DeleteMissing[Normal[c[All,"ChronicDiseases"]]]]]}

Out[]=



ChronicDiseaseQ	DeathQ	ChronicDiseases
True	True	—
True	True	{hypertension,chronic obstructive pulmonary disease,diabetes,chronic renal insufficiency}
True	True	{diabetes,cerebral infarction}
True	True	{hypertension,diabetes,coronary heart disease,frequent ventricular premature beat,coronary stent}
True	True	{hypertension,cerebral infarction,encephalomalacia}
True	True	{hypertension,hip replacement}
True	True	{Parkinson's disease}
True	True	{hypertension,diabetes,Parkinson's disease}
True	True	{hypertension,diabetes,colon cancer}
True	True	{chronic bronchitis,stenocardia,hypertension,coronary stent,hemorrhage of digestive tract}
True	True	{hypertension,diabetes}
True	True	{chronic bronchitis}
True	True	{hypertension,diabetes}
True	True	{diabetes}
True	True	{hypertension}
True	True	{hypertension}
True	True	{coronary heart disease}
True	True	{diabetes,coronary heart disease}
True	True	{chronic bronchitis}
True	True	{hypertension,diabetes}
showing 1–20 of 22

,



To learn more:

https://datarepository.wolframcloud.com/resources/Patient-Medical-Data-for-Novel-Coronavirus-COVID-19