When I am converting Date into months and plotting a boxplot the data against month why does it gets aligned alphabetically

Asked Oct 18 '20 at 05:58

Active Oct 18 '20 at 09:49

Viewed 26 times

I have a time series data of daily cases against time. I have grouped the data against month and changed the month variable using months function into January, February, etc. Now when I plot the box plot of the daily cases against the month variable, the plot gets aligned alphabetically instead chronologically.

Here is the data used to plot.

The following code I used.

y<-read.csv('COVID.csv',row.names=1)
y$Date<-as.Date(row.names(y),'%d-%m-%Y')
row.names(y)<-NULL
y<-y%>%group_by(month=floor_date(Date,unit='month'))
y$month<-months(y$month)
boxplot(y$Daily.Cases~y$month)

Here is the dataset

I tried the solution and it gave the following

As you can see, I don't have any data for the month of November and December but it's showing up in the graph.

edited Oct 18 '20 at 09:49

asked Oct 18 '20 at 05:58

SAIF UL MEHDI

Make `month` an ordered factor, i.e. `y$month <- factor(y$month, levels = month.name)` – stefan Oct 18 '20 at 07:09
I tried it and it's working but it is also giving me the months for which there's no data available. – SAIF UL MEHDI Oct 18 '20 at 09:45
After setting the order you can drop unused levels with `y$month <- droplevels(y$month)`. – stefan Oct 18 '20 at 16:41

When I am converting Date into months and plotting a boxplot the data against month why does it gets aligned alphabetically

0 Answers0