Build a box plot using R

[kabali]

Hi,

I need your help to create R code by creating Box plot. Click on the "this link" to get excel data sheet to create box plot using R code
this link

thanks

 

[AhoyNC]

See if this helps. You didn't say what you wanted to plot, so I just did visits vs. day of the week.
Also with Excel 365 you can do box plots without R.

When I imported your data to R I named it traffic (so you will need to change that part of the code to what ever name you used). I keep your headers the same as you had.
This line of code is just to put the DayofWeek on order for the graph.

traffic$DayOfWeek<-factor(traffic$DayOfWeek,levels=c("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"))

For the box plot this would be the code.

boxplot(traffic$Visits~traffic$DayOfWeek,xlab="Day of Week",ylab="Visits")

 

[kabali]

N/A

 

[kabali]

See if this helps. You didn't say what you wanted to plot, so I just did visits vs. day of the week.
Also with Excel 365 you can do box plots without R.

When I imported your data to R I named it traffic (so you will need to change that part of the code to what ever name you used). I keep your headers the same as you had.
This line of code is just to put the DayofWeek on order for the graph.

traffic$DayOfWeek<-factor(traffic$DayOfWeek,levels=c("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"))

For the box plot this would be the code.

boxplot(traffic$Visits~traffic$DayOfWeek,xlab="Day of Week",ylab="Visits")

View attachment 83844

May I get the R code you used it to get the output please?

 

[AhoyNC]

I gave you the R code above, but here it is off the R console
I saved your Excel file as a Tab Delimited Text (txt) to import.
The choose() file in the read.table command will let you choose the file from were you saved it.


> traffic<-read.table(file.choose(),header=T,sep="\t")
> traffic$DayOfWeek<-factor(traffic$DayOfWeek,levels=c("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"))
> boxplot(traffic$Visits~traffic$DayOfWeek,xlab="Day of Week",ylab="Visits")

 

[kabali]

I gave you the R code above, but here it is off the R console
I saved your Excel file as a Tab Delimited Text (txt) to import.
The choose() file in the read.table command will let you choose the file from were you saved it.


> traffic<-read.table(file.choose(),header=T,sep="\t")
> traffic$DayOfWeek<-factor(traffic$DayOfWeek,levels=c("Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"))
> boxplot(traffic$Visits~traffic$DayOfWeek,xlab="Day of Week",ylab="Visits")

Pls show the r code and the output in Rstudio for me. Don't copy and paste the r code here

 

[AhoyNC]

I don't have an option to download it in Rstudio for you. The 3 lines of code above was copyed right out of R. All you have to do is copy and past the code above into R or just type it into Rstudio (it's only 3 lines of code).
Note I named the data as traffic, if you used a different name just change the traffic to what ever you named your data and skip the first line of code if the data is already in R.
If you look at post#2 above it shows the output of the boxplot command. Since you didn't say what you wanted a box plot to show I just picked visits and day of week.

 

[AhoyNC]

I don;t usually use Rstudio and the post above shows a screen shot of R.
Below if it helps is a screen shot of the same thing in Rstudio.