library(dygraphs)
library(xts)
library(lubridate)
library(timetk)
library(dplyr)
library(readr)
data1<-read.csv("c:/users/nic user/downloads/report.csv")
a<-aggregate(. ~data1$MthYr , data = data1, sum)
#
# str(data1)
# glimpse(data1)
# a<-data1 %>% group_by(data1$month)
# a
#aggregate(. ~data1$month, data=data1, FUN = sum)
#s<-parse_datetime(data1$month, "%d/%m/%y")
#s<-as.Date(data1$month)
# s<-as.POSIXct(as.numeric(as.character(data1$month)),origin = "2017-01-01")
# s
qxts <- xts(a[, -1], order.by=as.Date(as.POSIXct(a$`data1$MthYr`)))
qxts
ad <- cbind(qxts$RegCount,qxts$AbortionCount,qxts$MaternalDeathCount)
dygraph(ad, main = "Deaths from Lung Disease (UK)") %>%
dySeries("RegCount", stepPlot = TRUE, color = "red") %>%
dyGroup(c("AbortionCount", "MaternalDeathCount"), drawPoints = TRUE, color = c("blue", "green"))
why is it looking like this...
MthYr UnitName RegCount AbortionCount MaternalDeathCount
0001-01-19 34 595 139251 5465 293
0001-01-19 68 595 143688 5825 348
0001-01-19 102 595 120622 3223 404
0001-02-19 136 595 134003 5157 376
0001-02-19 170 595 145692 5091 421
0001-02-19 204 595 104335 2076 333
0001-03-19 238 595 123052 5121 334
0001-03-19 272 595 115471 5251 325
0001-03-19 306 595 54319 1108 390
0001-04-19 340 595 161201 5216 375
0001-04-19 374 595 161791 4992 357
0001-05-19 408 595 150065 5880 354
0001-05-19 442 595 142824 5499 349
0001-06-19 476 595 146671 5781 411
0001-06-19 510 595 144185 5316 329
0001-07-19 544 595 142286 5958 402
0001-07-19 578 595 135974 5022 316
0001-08-19 612 595 127708 5968 409
0001-08-19 646 595 118690 4804 410
0001-09-19 680 595 117502 5134 416
0001-09-19 714 595 122510 4309 319
0001-10-19 748 595 115698 5208 316
0001-10-19 782 595 99298 4371 362
0001-11-19 816 595 125748 5420 355
0001-11-19 850 595 115744 3954 309
0001-12-19 884 595 140958 5927 398
0001-12-19 918 595 105097 3689 274
while the real data looks like this...
MthYr | UnitName | RegCount | AbortionCount | MaternalDeathCount |
---|---|---|---|---|
01-01-2018 | a | 4979 | 187 | 5 |
01-01-2018 | b | 7168 | 170 | 3 |
01-01-2018 | c | 4276 | 314 | 5 |
01-01-2018 | d | 2148 | 92 | 1 |
01-01-2018 | e | 7256 | 182 | 4 |
01-01-2018 | f | 5309 | 117 | 3 |
01-01-2018 | g | 5153 | 211 | 1 |
01-01-2018 | h | 5214 | 102 | 3 |
01-01-2018 | i | 2074 | 76 | 1 |
01-01-2018 | j | 2958 | 262 | 2 |
01-01-2018 | k | 4006 | 136 | 2 |
01-01-2018 | l | 3047 | 87 | 1 |
01-01-2018 | m | 3557 | 164 | 1 |
01-01-2018 | n | 3155 | 244 | 5 |
01-01-2018 | o | 3194 | 171 | 1 |
01-01-2018 | p | 2985 | 132 | 2 |
01-01-2018 | q | 6795 | 140 | 4 |
01-01-2018 | r | 3862 | 99 | 2 |
01-01-2018 | s | 1567 | 12 | 1 |
01-01-2018 | t | 4339 | 81 | 3 |
01-01-2018 | u | 3159 | 137 | 2 |
01-01-2018 | v | 3744 | 262 | 1 |
01-01-2018 | w | 6950 | 104 | 6 |
01-01-2018 | x | 3596 | 164 | 1 |
01-01-2018 | y | 2724 | 81 | 9 |
01-01-2018 | z | 7178 | 377 | 6 |
01-01-2018 | a | 4254 | 128 | 4 |
01-01-2018 | b | 1955 | 38 | 3 |
01-01-2018 | c | 2835 | 173 | 4 |
01-01-2018 | d | 3130 | 159 | 2 |
01-01-2018 | e | 4609 | 242 | 5 |
01-01-2018 | f | 2535 | 113 | 1 |
01-01-2018 | g | 2904 | 100 | 2 |
01-01-2018 | h | 6636 | 408 | 5 |
01-02-2018 | i | 5017 | 170 | 2 |
01-02-2018 | j | 7806 | 211 | 5 |
01-02-2018 | k | 4218 | 245 | 4 |
01-02-2018 | l | 2779 | 113 | 2 |
01-02-2018 | m | 6672 | 213 | 3 |
01-02-2018 | n | 5804 | 112 | 4 |
01-02-2018 | o | 4458 | 179 | 3 |
01-02-2018 | p | 4889 | 97 | 3 |
01-02-2018 | q | 2190 | 67 | 1 |
01-02-2018 | r | 2631 | 205 | NULL |
01-02-2018 | s | 4147 | 133 | 4 |
01-02-2018 | t | 3136 | 83 | 2 |
01-02-2018 | u | 3543 | 176 | NULL |
01-02-2018 | v | 2867 | 217 | 6 |
01-02-2018 | w | 3277 | 174 | 1 |
01-02-2018 | x | 2844 | 143 | 3 |
01-02-2018 | y | 6172 | 178 | 3 |
01-02-2018 | z | 3587 | 102 | 4 |
01-02-2018 | a | 1521 | 9 | NULL |
01-02-2018 | b | 4103 | 90 | 2 |
01-02-2018 | c | 3436 | 138 | 3 |
01-02-2018 | d | 3304 | 197 | 3 |
01-02-2018 | e | 6495 | 91 | 5 |
01-02-2018 | f | 3590 | 130 | 2 |
01-02-2018 | g | 3069 | 67 | 2 |
01-02-2018 | h | 6181 | 340 | 2 |
01-02-2018 | i | 3930 | 126 | 4 |
01-02-2018 | j | 1872 | 41 | NULL |
01-02-2018 | k | 2508 | 164 | 2 |
01-02-2018 | l | 2930 | 153 | 1 |
01-02-2018 | m | 4100 | 218 | 2 |
01-02-2018 | n | 2239 | 91 | 3 |
01-02-2018 | o | 2694 | 155 | 2 |
01-02-2018 | p | 5994 | 329 | 5 |
01-03-2018 | q | 4739 | 191 | 4 |
01-03-2018 | r | 7420 | 235 | 5 |
01-03-2018 | s | 3790 | 275 | 1 |
01-03-2018 | t | 2288 | 99 | 1 |
01-03-2018 | u | 5818 | 178 | 2 |
01-03-2018 | v | 5250 | 102 | NULL |
01-03-2018 | w | 4011 | 176 | 2 |
01-03-2018 | x | 4323 | 128 | NULL |
01-03-2018 | y | 2089 | 63 | NULL |
01-03-2018 | z | 2539 | 189 | 1 |
01-03-2018 | a | 3718 | 145 | 5 |
01-03-2018 | b | 2917 | 92 | 1 |
01-03-2018 | c | 3390 | 166 | 4 |
01-03-2018 | d | 3036 | 177 | 6 |
01-03-2018 | e | 2836 | 176 | 1 |
01-03-2018 | f | 2768 | 166 | NULL |
01-01-2019 | g | 6330 | 177 | 1 |
01-01-2019 | h | 3553 | 111 | 2 |
01-01-2019 | i | 1671 | 10 | NULL |
01-01-2019 | j | 3465 | 86 | 1 |
01-01-2019 | k | 2743 | 122 | 1 |
01-01-2019 | l | 2993 | 178 | NULL |
01-01-2019 | m | 5992 | 91 | 6 |
01-01-2019 | n | 3335 | 129 | 2 |
01-01-2019 | o | 2923 | 95 | 2 |
01-01-2019 | p | 5390 | 314 | 6 |
01-01-2019 | q | 3784 | 130 | 1 |
01-01-2019 | r | 1696 | 44 | 3 |
01-01-2019 | s | 2315 | 172 | 2 |
01-01-2019 | t | 2467 | 117 | NULL |
01-02-2019 | u | 3492 | 232 | 1 |
01-02-2019 | v | 2002 | 104 | 2 |
01-02-2019 | w | 2527 | 124 | 4 |
01-02-2019 | x | 5442 | 327 | 5 |
01-02-2019 | y | 5947 | 183 | 3 |
01-02-2019 | z | 8122 | 214 | 1 |
01-02-2019 | a | 4739 | 248 | 3 |
01-02-2019 | b | 2650 | 127 | 2 |
01-02-2019 | c | 9221 | 178 | 4 |
01-02-2019 | d | 6352 | 134 | 4 |
01-02-2019 | e | 5501 | 237 | 1 |
01-02-2019 | f | 5682 | 85 | 2 |
01-02-2019 | g | 2617 | 85 | 3 |
01-02-2019 | h | 3233 | 166 | NULL |
01-02-2019 | i | 4367 | 130 | NULL |
01-02-2019 | j | 3142 | 88 | 3 |
01-02-2019 | k | 3562 | 166 | NULL |
01-02-2019 | l | 3610 | 168 | 2 |
01-02-2019 | m | 3832 | 185 | NULL |
01-02-2019 | n | 3205 | 158 | 3 |
01-02-2019 | o | 6994 | 167 | 5 |
01-02-2019 | p | 4315 | 121 | 2 |
01-02-2019 | q | 2522 | 9 | 1 |
01-02-2019 | r | 5760 | 78 | 2 |
01-02-2019 | s | 3412 | 135 | 2 |
01-02-2019 | t | 4233 | 158 | 3 |
01-02-2019 | u | 8364 | 118 | 3 |
01-02-2019 | v | 3682 | 145 | 3 |
01-02-2019 | w | 3162 | 91 | 7 |
01-02-2019 | x | 8250 | 323 | 5 |
01-02-2019 | y | 5522 | 119 | 2 |
01-02-2019 | z | 2381 | 41 | NULL |
01-02-2019 | a | 3280 | 213 | 3 |
01-02-2019 | b | 3349 | 128 | 3 |
01-03-2019 | c | 6335 | 232 | 6 |
01-03-2019 | d | 2919 | 110 | 2 |
01-03-2019 | e | 3235 | 147 | 1 |
01-03-2019 | f | 7704 | 329 | 4 |
01-03-2019 | g | 5274 | 218 | 4 |
01-03-2019 | h | 7557 | 235 | 1 |
01-03-2019 | i | 4703 | 268 | 4 |
01-03-2019 | j | 2446 | 111 | 1 |
01-03-2019 | k | 8107 | 198 | 5 |
01-03-2019 | l | 5918 | 153 | 5 |
01-03-2019 | m | 5115 | 264 | 4 |
01-03-2019 | n | 5895 | 93 | 5 |
01-03-2019 | o | 2440 | 82 | 1 |
01-03-2019 | p | 3257 | 250 | 5 |
01-03-2019 | q | 4144 | 164 | 1 |
01-03-2019 | r | 3786 | 99 | 5 |
01-03-2019 | s | 3535 | 180 | 2 |
01-03-2019 | t | 3467 | 175 | 3 |
01-03-2019 | u | 3219 | 202 | 3 |
01-03-2019 | v | 2915 | 175 | 2 |
01-03-2019 | w | 6756 | 184 | 15 |
01-03-2019 | x | 4031 | 116 | 1 |
01-03-2019 | y | 2348 | 26 | NULL |
01-03-2019 | z | 5369 | 92 | 7 |
01-03-2019 | a | 3327 | 161 | 7 |
01-03-2019 | b | 3637 | 207 | 3 |
01-03-2019 | c | 7993 | 120 | 9 |
01-03-2019 | d | 3918 | 169 | 2 |
01-03-2019 | e | 3154 | 104 | 2 |
01-03-2019 | f | 6882 | 361 | 4 |
01-03-2019 | g | 4902 | 112 | 3 |
01-03-2019 | h | 2358 | 52 | NULL |
01-03-2019 | i | 2971 | 237 | 3 |
01-03-2019 | j | 3222 | 146 | 4 |
01-04-2019 | k | 4630 | 234 | 4 |
01-04-2019 | l | 2837 | 116 | 5 |
01-04-2019 | m | 2838 | 172 | 2 |
01-04-2019 | n | 7114 | 404 | 12 |
01-04-2019 | o | 5216 | 211 | 4 |
01-04-2019 | p | 7283 | 232 | 4 |
01-04-2019 | q | 5080 | 301 | 5 |
01-04-2019 | r | 2761 | 102 | 6 |
01-04-2019 | s | 8121 | 238 | 6 |
01-04-2019 | t | 5760 | 166 | 5 |
01-04-2019 | u | 5066 | 227 | 3 |
01-04-2019 | v | 5487 | 103 | 5 |
01-04-2019 | w | 2297 | 70 | 2 |
01-04-2019 | x | 3163 | 228 | NULL |
01-04-2019 | y | 3893 | 139 | 5 |
01-04-2019 | z | 3129 | 107 | 2 |
could anyone please tell me how to rectify this error. please guide me through this issue.
any help and suggestion would be a great help.