In[]:=
ds=ResourceData["Patient Medical Data for Novel Coronavirus 2019-nCoV from Wuhan, China"]
In[]:=
ds[1;;3]
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.83°N 117.2°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
-

Thu 9 Jan 2020
,
Fri 10 Jan 2020

Chenzhou
-
-
-
-
-
-
-
-
-
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
-

Thu 9 Jan 2020
,
Fri 10 Jan 2020

Chenzhou
-
-
-
-
-
-
-
-
-
In[]:=
ds[1;;3,{"Age","Sex","City"}]
Out[]=
Age
Sex
City
30
male
Hefei
47
male
Hefei
49
male
Hefei
In[]:=
ds[Tally,"Sex"]
Out[]=
male
280
female
176
-
6962
In[]:=
ds[Select[Not[MissingQ[#Age]]&],"Age"]
Out[]=
30
47
49
47
50
42
59
30
39
38
45
33
37
39
32
45
45
18
56
42
rows 1–20 of 579
In[]:=
ds2=ds[Select[Not[MissingQ[#Age]]&&Head[#Age]=!=Interval&],N[#Age]&]
Out[]=
30.0
47.0
49.0
47.0
50.0
42.0
59.0
30.0
39.0
38.0
45.0
33.0
37.0
39.0
32.0
45.0
45.0
18.0
56.0
42.0
33.0
44.0
65.0
21.0
41.0
44.0
30.0
70.0
43.0
31.0
43.0
24.0
40.0
66.0
65.0
36.0
10.0
63.0
37.0
78.0
76.0
48.0
66.0
66.0
63.0
62.0
49.0
46.0
34.0
41.0
72.0
20.0
54.0
33.0
49.0
42.0
33.0
2.0
29.0
62.0
61.0
20.0
51.0
50.0
72.0
80.0
49.0
69.0
66.0
32.0
28.0
55.0
68.0
30.0
34.0
30.0
50.0
39.0
56.0
62.0
63.0
62.0
57.0
35.0
40.0
30.0
30.0
37.0
56.0
50.0
35.0
36.0
35.0
27.0
40.0
42.0
33.0
40.0
50.0
42.0
66.0
52.0
29.0
28.0
22.0
32.0
42.0
23.0
49.0
38.0
62.0
65.0
56.0
35.0
88.0
28.0
31.0
50.0
48.0
36.0
37.0
19.0
60.0
58.0
29.0
47.0
52.0
51.0
53.0
39.0
34.0
49.0
46.0
46.0
40.0
51.0
37.0
55.0
32.0
24.0
rows 1–20 of 357
In[]:=
ds2[Mean]
Out[]=
46.3221
In[]:=
Histogram[Normal[ds2]]
Out[]=
In[]:=
ReverseSortBy[Tally[Flatten[Normal[ds[Select[Not[MissingQ[#ChronicDiseases]]&],"ChronicDiseases"]]]],Last]//Grid
Out[]=
hypertension
15
diabetes
11
coronary heart disease
5
chronic bronchitis
3
Parkinson's disease
2
coronary stent
2
cerebral infarction
2
type 2 diabetes
1
Tuberculosis
1
stenocardia
1
lung cancer
1
hip replacement
1
hemorrhage of digestive tract
1
frequent ventricular premature beat
1
encephalomalacia
1
colon cancer
1
chronic renal insufficiency
1
chronic obstructive pulmonary disease
1