'data.frame': 225 obs. of 10 variables:
$ Country : chr "Afghanistan" "Albania" "Algeria" "Andorra" ...
$ Other.names : chr "Afghanistan" "Albania" "Algeria" "Andorra" ...
$ ISO.3166.1.alpha.3.CODE: chr "AFG" "ALB" "DZA" "AND" ...
$ Population : int 40462186 2872296 45236699 77481 34654212 15237 99348 45921761 2972939 107560 ...
$ Continent : chr "Asia" "Europe" "Africa" "Europe" ...
$ Total.Cases : int 177827 273870 265691 40024 99194 2700 7493 9041124 422574 34051 ...
$ Total.Deaths : int 7671 3492 6874 153 1900 9 135 128065 8617 212 ...
$ TotÂ.Cases..1M.pop : int 4395 95349 5873 516565 2862 177200 75422 196881 142140 316577 ...
$ TotÂ.Deaths.1M.pop : int 190 1216 152 1975 55 591 1359 2789 2898 1971 ...
$ Death.percentage : num 4.314 1.275 2.587 0.382 1.915 ...
Country Other.names ISO.3166.1.alpha.3.CODE
Length:225 Length:225 Length:225
Class :character Class :character Class :character
Mode :character Mode :character Mode :character
Population Continent Total.Cases Total.Deaths
Min. :8.050e+02 Length:225 Min. : 1 Min. : 0
1st Qu.:5.666e+05 Class :character 1st Qu.: 24071 1st Qu.: 189
Median :5.828e+06 Mode :character Median : 163936 Median : 1965
Mean :3.507e+07 Mean : 2184781 Mean : 27448
3rd Qu.:2.191e+07 3rd Qu.: 1092547 3rd Qu.: 13660
Max. :1.439e+09 Max. :81839052 Max. :1008222
TotÂ.Cases..1M.pop TotÂ.Deaths.1M.pop Death.percentage
Min. : 9 Min. : 0 Min. : 0.0000
1st Qu.: 11384 1st Qu.: 123 1st Qu.: 0.5113
Median : 88987 Median : 708 Median : 1.0369
Mean :136900 Mean :1097 Mean : 1.4441
3rd Qu.:223335 3rd Qu.:1795 3rd Qu.: 1.9770
Max. :696044 Max. :6286 Max. :18.1518
### Extracted data
[1] "Country" "Other.names"
[3] "ISO.3166.1.alpha.3.CODE" "Population"
[5] "Continent" "Total.Cases"
[7] "Total.Deaths" "TotÂ.Cases..1M.pop"
[9] "TotÂ.Deaths.1M.pop" "Death.percentage"
Population Total.Cases Total.Deaths TotÂ.Cases..1M.pop
1 40462186 177827 7671 4395
2 2872296 273870 3492 95349
3 45236699 265691 6874 5873
4 77481 40024 153 516565
5 34654212 99194 1900 2862
6 15237 2700 9 177200
7 99348 7493 135 75422
8 45921761 9041124 128065 196881
9 2972939 422574 8617 142140
10 107560 34051 212 316577
11 26017767 4680816 6384 179908
12 9096360 3887355 15985 427353
13 10299156 792061 9697 76905
14 399822 33295 788 83275
15 1804995 556241 1471 308168
16 167561502 1951770 29122 11648
17 287991 59938 375 208125
18 9443882 965322 6844 102217
19 11677924 3851048 30826 329772
20 410260 57289 656 139641
21 12678649 26952 163 2126
22 61875 12564 128 203055
23 786480 31437 12 39972
24 11951714 902448 21896 75508
25 3245097 375693 15719 115773
26 2434708 305526 2686 125488
27 215204501 29999816 660269 139401
28 30583 6155 62 201256
29 444812 135974 213 305689
30 6856886 1140679 36568 166355
31 21905848 20853 382 952
32 12510155 38519 38 3079
33 566557 55960 401 98772
34 17123941 135747 3054 7927
35 27701805 119544 1927 4315
36 38321435 3499226 37690 91312
37 4976719 14649 113 2944
38 26650 8574 33 321726
39 67073 20606 24 307218
40 17250246 7308 191 424
41 176668 69036 156 390767
42 19403451 3486653 56750 179692
43 1439323776 154738 4638 108
44 51832231 6085926 139660 117416
45 902011 8093 160 8972
46 5755689 24071 385 4182
47 17592 2118 0 120396
48 5175547 839368 8308 162180
49 4060951 1102730 15601 271545
50 11314513 1092547 8514 96562
51 165268 40671 267 246091
52 1222745 439964 947 359817
53 10743762 3830631 39720 356545
54 5827911 2919428 5762 500939
55 1013146 15590 189 15388
56 72299 11891 63 164470
57 11038333 578130 4375 52375
58 94323344 86748 1337 920
59 18111933 859890 35421 47476
60 105711844 505264 24417 4780
61 6543499 161570 4120 24692
62 1483588 15903 183 10719
63 3632329 9728 103 2678
64 1328097 558706 2468 420682
65 1181191 69851 1394 59136
66 119945147 469819 7504 3917
67 49188 34237 28 696044
68 3657 123 0 33634
69 907817 64422 834 70964
70 5555788 889626 3178 160126
71 65526369 25997852 142506 396754
72 312224 79075 394 253264
73 283751 72318 646 254864
74 2317612 47586 303 20532
75 2535418 11988 365 4728
76 3975762 1649222 16756 414819
77 84252947 21646375 130563 256921
78 32207812 160971 1445 4998
79 33673 16979 101 504232
80 10333930 3077711 27684 297826
81 56942 11971 21 210231
82 113436 14024 218 123629
83 400244 130705 843 326563
84 18495493 830745 17325 44916
85 13755881 36459 440 2650
86 2049374 8151 170 3977
87 793196 63272 1226 79768
88 11645833 30549 833 2623
89 10180299 421062 10880 41360
90 7603455 1171422 8172 154064
91 9617409 1854198 45510 192796
92 345120 181830 101 526860
93 1403754381 43029044 521388 30653
94 278586508 6019981 155288 21609
95 85874667 7167646 140315 83466
96 41801625 2320260 25173 55506
97 5034333 1471210 6786 292235
98 85821 28416 84 331108
99 9326000 3943153 10530 422813
100 60306185 14846514 159784 246186
101 27520953 81761 796 2971
102 2983794 128811 2893 43170
103 125798669 6653841 28248 52893
104 10380442 1689314 14003 162740
105 19169833 1305188 13660 68086
106 55843563 323454 5648 5792
107 122656 3067 13 25005
108 4381108 629525 2554 143691
109 6712569 200968 2991 29939
110 7460338 183560 679 24605
111 1849698 802534 5643 433873
112 6771939 1092995 10315 161401
113 2171978 32910 697 15152
114 5265647 7400 294 1405
115 7034832 501738 6419 71322
116 38320 16429 84 428732
117 2655811 1030966 8907 388193
118 643801 216979 1037 337028
119 664828 82 0 123
120 28936285 64050 1388 2213
121 19994654 85664 2626 4284
122 33091831 4246467 35099 128324
123 557204 176993 298 317645
124 21271006 30495 728 1434
125 443602 81596 641 183940
126 59889 7 0 117
127 374756 141415 909 377352
128 4863443 58670 982 12063
129 1275463 36628 968 28717
130 284330 36891 187 129747
131 131303955 5665376 323212 43147
132 117134 1 0 9
133 4017550 514199 11446 127988
134 39729 10842 54 272899
135 3370682 468610 2177 139025
136 628205 233326 2705 371417
137 4997 175 2 35021
138 37676342 1163526 16060 30882
139 32787052 225266 2200 6871
140 55048340 611875 19433 11115
141 2621429 157646 4019 60137
142 30053867 978475 11951 32557
143 17201245 7908701 22016 459775
144 290302 60294 311 207694
145 5002100 693219 350 138586
146 6762511 18434 224 2726
147 25738714 8811 308 342
148 215077352 255468 3142 1188
149 1645 7 0 4255
150 2083224 306670 9228 147209
151 5495449 1408708 2518 256341
152 5333815 388468 4251 72831
153 228397520 1525466 30361 6679
154 18245 4042 6 221540
155 5308883 581236 5351 109484
156 4433639 765213 8170 172593
157 9243590 42203 640 4566
158 7285892 648353 18731 88987
159 33775745 3548559 212328 105062
160 112133868 3679485 59343 32813
161 37774045 5969621 115345 158035
162 10144662 3604114 21693 355272
163 2807805 361819 677 128862
164 906497 336945 709 371700
165 19013049 2860094 65090 150428
166 146044010 17896866 369708 122544
167 13513881 129728 1458 9600
168 51346429 13874216 17235 270208
169 6109 2 0 327
170 53858 5549 43 103030
171 185096 22964 365 124065
172 39820 10107 63 253817
173 5744 1957 1 340703
174 200722 2285 1 11384
175 34056 15181 113 445766
176 226281 5945 73 26273
177 35762746 751076 9048 21002
178 17515750 85919 1965 4905
179 8675762 1980722 15825 228305
180 99413 40421 164 406597
181 8260822 7674 125 929
182 5930887 1109744 1276 187113
183 43728 9766 86 223335
184 5464272 1725487 19417 315776
185 2079438 973892 6501 468344
186 716351 11470 133 16012
187 16668781 26400 1348 1584
188 60617532 3722954 100050 61417
189 11423439 17278 138 1513
190 46786482 11551574 102541 246900
191 21570428 661991 16481 30690
192 9930 4150 6 417925
193 111557 6746 106 60471
194 45640385 61955 4907 1357
195 595833 79232 1325 132977
196 10209507 2487852 18331 243680
197 8765420 3490876 13715 398255
198 18244381 55711 3144 3054
199 23892241 24310 853 1017
200 9912437 17388 124 1754
201 62710097 33815 800 539
202 70106601 3711595 25418 52942
203 1362386 22832 130 16759
204 8618172 36944 272 4287
205 107792 7127 9 66118
206 1407422 138425 3756 98354
207 12035092 1035884 28323 86072
208 85927644 14894731 98157 173340
209 39634 5910 36 149114
210 10099567 892170 2302 88337
211 48267221 163936 3595 3396
212 68510300 21216874 165570 309689
213 43273831 4968881 107980 114824
214 3494806 889513 7166 254524
215 334400597 81839052 1008222 244734
216 34318156 237853 1637 6931
217 319701 4107 2 12846
218 805 29 0 36025
219 28294895 520843 5686 18408
220 98871712 9818328 42600 99304
221 10894 454 7 41674
222 623031 10 1 16
223 30975258 11806 2143 381
224 19284482 317076 3967 16442
225 15241601 246525 5446 16174
Total.Cases Total.Deaths TotÂ.Cases..1M.pop Total.Deaths.1
1 177827 7671 4395 7671
2 273870 3492 95349 3492
3 265691 6874 5873 6874
4 40024 153 516565 153
5 99194 1900 2862 1900
6 2700 9 177200 9
7 7493 135 75422 135
8 9041124 128065 196881 128065
9 422574 8617 142140 8617
10 34051 212 316577 212
11 4680816 6384 179908 6384
12 3887355 15985 427353 15985
13 792061 9697 76905 9697
14 33295 788 83275 788
15 556241 1471 308168 1471
16 1951770 29122 11648 29122
17 59938 375 208125 375
18 965322 6844 102217 6844
19 3851048 30826 329772 30826
20 57289 656 139641 656
21 26952 163 2126 163
22 12564 128 203055 128
23 31437 12 39972 12
24 902448 21896 75508 21896
25 375693 15719 115773 15719
26 305526 2686 125488 2686
27 29999816 660269 139401 660269
28 6155 62 201256 62
29 135974 213 305689 213
30 1140679 36568 166355 36568
31 20853 382 952 382
32 38519 38 3079 38
33 55960 401 98772 401
34 135747 3054 7927 3054
35 119544 1927 4315 1927
36 3499226 37690 91312 37690
37 14649 113 2944 113
38 8574 33 321726 33
39 20606 24 307218 24
40 7308 191 424 191
41 69036 156 390767 156
42 3486653 56750 179692 56750
43 154738 4638 108 4638
44 6085926 139660 117416 139660
45 8093 160 8972 160
46 24071 385 4182 385
47 2118 0 120396 0
48 839368 8308 162180 8308
49 1102730 15601 271545 15601
50 1092547 8514 96562 8514
51 40671 267 246091 267
52 439964 947 359817 947
53 3830631 39720 356545 39720
54 2919428 5762 500939 5762
55 15590 189 15388 189
56 11891 63 164470 63
57 578130 4375 52375 4375
58 86748 1337 920 1337
59 859890 35421 47476 35421
60 505264 24417 4780 24417
61 161570 4120 24692 4120
62 15903 183 10719 183
63 9728 103 2678 103
64 558706 2468 420682 2468
65 69851 1394 59136 1394
66 469819 7504 3917 7504
67 34237 28 696044 28
68 123 0 33634 0
69 64422 834 70964 834
70 889626 3178 160126 3178
71 25997852 142506 396754 142506
72 79075 394 253264 394
73 72318 646 254864 646
74 47586 303 20532 303
75 11988 365 4728 365
76 1649222 16756 414819 16756
77 21646375 130563 256921 130563
78 160971 1445 4998 1445
79 16979 101 504232 101
80 3077711 27684 297826 27684
81 11971 21 210231 21
82 14024 218 123629 218
83 130705 843 326563 843
84 830745 17325 44916 17325
85 36459 440 2650 440
86 8151 170 3977 170
87 63272 1226 79768 1226
88 30549 833 2623 833
89 421062 10880 41360 10880
90 1171422 8172 154064 8172
91 1854198 45510 192796 45510
92 181830 101 526860 101
93 43029044 521388 30653 521388
94 6019981 155288 21609 155288
95 7167646 140315 83466 140315
96 2320260 25173 55506 25173
97 1471210 6786 292235 6786
98 28416 84 331108 84
99 3943153 10530 422813 10530
100 14846514 159784 246186 159784
101 81761 796 2971 796
102 128811 2893 43170 2893
103 6653841 28248 52893 28248
104 1689314 14003 162740 14003
105 1305188 13660 68086 13660
106 323454 5648 5792 5648
107 3067 13 25005 13
108 629525 2554 143691 2554
109 200968 2991 29939 2991
110 183560 679 24605 679
111 802534 5643 433873 5643
112 1092995 10315 161401 10315
113 32910 697 15152 697
114 7400 294 1405 294
115 501738 6419 71322 6419
116 16429 84 428732 84
117 1030966 8907 388193 8907
118 216979 1037 337028 1037
119 82 0 123 0
120 64050 1388 2213 1388
121 85664 2626 4284 2626
122 4246467 35099 128324 35099
123 176993 298 317645 298
124 30495 728 1434 728
125 81596 641 183940 641
126 7 0 117 0
127 141415 909 377352 909
128 58670 982 12063 982
129 36628 968 28717 968
130 36891 187 129747 187
131 5665376 323212 43147 323212
132 1 0 9 0
133 514199 11446 127988 11446
134 10842 54 272899 54
135 468610 2177 139025 2177
136 233326 2705 371417 2705
137 175 2 35021 2
138 1163526 16060 30882 16060
139 225266 2200 6871 2200
140 611875 19433 11115 19433
141 157646 4019 60137 4019
142 978475 11951 32557 11951
143 7908701 22016 459775 22016
144 60294 311 207694 311
145 693219 350 138586 350
146 18434 224 2726 224
147 8811 308 342 308
148 255468 3142 1188 3142
149 7 0 4255 0
150 306670 9228 147209 9228
151 1408708 2518 256341 2518
152 388468 4251 72831 4251
153 1525466 30361 6679 30361
154 4042 6 221540 6
155 581236 5351 109484 5351
156 765213 8170 172593 8170
157 42203 640 4566 640
158 648353 18731 88987 18731
159 3548559 212328 105062 212328
160 3679485 59343 32813 59343
161 5969621 115345 158035 115345
162 3604114 21693 355272 21693
163 361819 677 128862 677
164 336945 709 371700 709
165 2860094 65090 150428 65090
166 17896866 369708 122544 369708
167 129728 1458 9600 1458
168 13874216 17235 270208 17235
169 2 0 327 0
170 5549 43 103030 43
171 22964 365 124065 365
172 10107 63 253817 63
173 1957 1 340703 1
174 2285 1 11384 1
175 15181 113 445766 113
176 5945 73 26273 73
177 751076 9048 21002 9048
178 85919 1965 4905 1965
179 1980722 15825 228305 15825
180 40421 164 406597 164
181 7674 125 929 125
182 1109744 1276 187113 1276
183 9766 86 223335 86
184 1725487 19417 315776 19417
185 973892 6501 468344 6501
186 11470 133 16012 133
187 26400 1348 1584 1348
188 3722954 100050 61417 100050
189 17278 138 1513 138
190 11551574 102541 246900 102541
191 661991 16481 30690 16481
192 4150 6 417925 6
193 6746 106 60471 106
194 61955 4907 1357 4907
195 79232 1325 132977 1325
196 2487852 18331 243680 18331
197 3490876 13715 398255 13715
198 55711 3144 3054 3144
199 24310 853 1017 853
200 17388 124 1754 124
201 33815 800 539 800
202 3711595 25418 52942 25418
203 22832 130 16759 130
204 36944 272 4287 272
205 7127 9 66118 9
206 138425 3756 98354 3756
207 1035884 28323 86072 28323
208 14894731 98157 173340 98157
209 5910 36 149114 36
210 892170 2302 88337 2302
211 163936 3595 3396 3595
212 21216874 165570 309689 165570
213 4968881 107980 114824 107980
214 889513 7166 254524 7166
215 81839052 1008222 244734 1008222
216 237853 1637 6931 1637
217 4107 2 12846 2
218 29 0 36025 0
219 520843 5686 18408 5686
220 9818328 42600 99304 42600
221 454 7 41674 7
222 10 1 16 1
223 11806 2143 381 2143
224 317076 3967 16442 3967
225 246525 5446 16174 5446
Total.Cases Total.Deaths TotÂ.Cases..1M.pop Total.Deaths.1
Total.Cases 1.0000000 0.91526266 0.12788974 0.91526266
Total.Deaths 0.9152627 1.00000000 0.03656118 1.00000000
TotÂ.Cases..1M.pop 0.1278897 0.03656118 1.00000000 0.03656118
Total.Deaths.1 0.9152627 1.00000000 0.03656118 1.00000000
---
title: "Covid dataset"
output:
flexdashboard::flex_dashboard:
orientation: columns
vertical_layout: fill
theme: darkly
storyboard: True
social: menu
source_code: embed
---
```{r setup, include=FALSE}
library(flexdashboard)
library(tidytext)
library(tm)
library(corrplot)
library(ggplot2)
covid=read.csv(file.path("C:\\Users\\dell\\OneDrive\\Desktop\\covid.csv"),header = TRUE)
View(covid)
```
Column {.dataset}
-----------------------------------------------------------------------
### Analysis
```{r}
str(covid)
summary(covid)
attach(covid)
```
Column {.dataset}
-----------------------------------------------------------------------
### Histogram
```{r}
hist(covid$Total.Deaths,breaks = 20, col="yellow",main = "COVID DEATH RATES")
hist(covid$Total.Cases,breaks = 20, col="purple",main = "COVID CASES")
```
### Boxplot and Scatterplot
```{r}
boxplot(Total.Cases~Total.Deaths,main = "Total.cases vs Total.deaths",las=3,col=c(4,2))
plot(TotÂ.Cases..1M.pop ~ TotÂ.Deaths.1M.pop, pch = 19, col = "blue")
```
### Extracted data
```{r}
names(covid)
newcovid=covid[c("Country","Other.names","Population","Continent","Death.percentage")]
View(newcovid)
```
### corrplot
```{r}
coviddf=covid[c(4,6,7,8)]
coviddf
coviddf=subset(covid,select = c(6:8,7))
coviddf
cor(coviddf)
corrplot(cor(coviddf),method="number",shade.col = NA,tl.col = "purple")
```
### ggplot
```{r}
ggplot(covid)+geom_point(mapping = aes(x=Total.Cases,y=Total.Deaths))+
ggtitle(label="Total.cases vs Total.deaths")
```