Skip to content

transform excel data into graph

3 messages · cross123, aaront, John Kane

Original
cross123
# 
Hello everyone,
I have a set of data in the following form, which are stored in an Excel
file:
                 nick       john       peter                 
lesson1       0.465     0.498     0.473    
lesson2       0.422      0.44      0.134           
lesson3       0.45       0.35       0.543                      
lesson4       0.590      0.64      0.11                      
lesson5       0.543      0.5        0.32                      

What I want to do is a 2d-graph plot where I will have  the name of the
student in the X-axis and the name of the lesson in the Y-axis and the
number from each pair will be used to construct the plot.
I am newbie with R and I don't know which package shall I use nor the
commands with which I will import my data in R so that the plot will be
created...

Any help would be greatly appreciated.
aaront
# 
There are numerous ways of importing data from excel. One is to save as a
.csv and use the read.csv function. Or, you can copy to the clipboard and
use the read.delim("clipboard",header=T) function.

Are you looking at a bar graph where the lessons have the names nested below
them on the x axis, and the numbers on the y?

As these are all introductory elements of using R, going through the
numerous intro R manuals available online is your best bet. Try:
http://cran.r-project.org/manuals.html
 
and also under "Contributed Documentation" at the above site.
cross123 wrote:

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      John Kane
    

    

      
      #
    

  


  

      
I am not sure exactly what you want but see if this
will work. It will give you a dotchart.  

Assume your data.frame is dat
First give the lessons column a name. See ?names

convert numbers in data.frame to a matrix for dotchart

dmat <- as.matrix(dat[,2:4])

Draw dotchart using dat$lessons as a 
dotchart(dmat, labels = dat[,1])

        
--- cross123 <ctsirigos at yahoo.com> wrote: