Column

Analysis

'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  

Column

Histogram

Boxplot and Scatterplot

### 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"       

corrplot

    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

ggplot

---
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")

```