Kebytech Nigeria Best Tech Site

HOW TO READ DATA FROM EXCEL INTO R

 Reading of data from excel into R environment has prove difficulty to many people but after you take your time to read this, it won't pose problem again.  let begin.

   First step: you need to save the file in "csv format. By click on save, under save as click on Csv format before typing in the name you want to save it with.
 Second step: Go to that file, right click, go to property then copy the location of the file.
Third step: open R environment. Type k<-read.Csv ( " past the file location copy here/the file name.Csv"). remember to change all the forward slatch to backward slatch. e.g

K<-read.Csv("c:olaye/desktop/data.Csv")
if you have done everything correctly you will have no error after you click on enter.
Then type the variable name in which the file is save into "K",then enter you will have the file ready for use in your R environment.

Thanks leave comment on area you are having difficulty or need help will attend to you.