Instead of creating the data frame programmatically, why not use an existing spreadsheet, available online. A simple HTTP file server, free and Open Source is HFS: http://rejetto.com/hfs/?f=
Once HFS is installed, uploading the spreadsheet is as simple as dragging and dropping an existing spreadsheet. Here is how it looks on my machine:
Once the file is in place, we can get its URL directly by right-clicking on the file, and selecting “Copy URL address – Ctrl+C”
The first time it will be needed to read the spreadsheet into R, some more software is needed
Download and install a PERL home on the machine. For Windows, Strawberry Perl can be used (link: http://strawberryperl.com/ )
Next, the package to read the spreadsheet needs to be installed into R. The package name is “gdata” so we perform
install.packages("gdata")
and
require("gdata")
at this point, we are ready to load directly the spreadsheet into a new data frame
dfXLBAN <- read.xls("http://192.168.0.107/BaRanas.xlsx")
trying URL 'http://192.168.0.107/BaRanas.xlsx'
Content type 'application/octet-stream' length 8786 bytes
downloaded 8786 bytes
lets display the data frame:
dfXLBAN
Date Name Bananas
1 1 Radka 2
2 2 Radka 3
3 3 Radka 4
4 4 Radka 5
5 5 Radka 1
6 6 Radka 1
7 7 Radka 7
8 1 Natalie 6
9 2 Natalie 2
10 3 Natalie 3
11 4 Natalie 4
12 5 Natalie 2
13 6 Natalie 1
14 7 Natalie 8
Since the spreadsheet contained one more row, we need (in order to have the dataframe exactly the same as our example with inline data) to discard the Date Column:
dfB2 <- data.frame(dfXLBAN$Name,dfXLBAN$Bananas)
dfB2
dfXLBAN.Name dfXLBAN.Bananas
1 Radka 2
2 Radka 3
3 Radka 4
4 Radka 5
5 Radka 1
6 Radka 1
7 Radka 7
8 Natalie 6
9 Natalie 2
10 Natalie 3
11 Natalie 4
12 Natalie 2
13 Natalie 1
14 Natalie 8
the plot function will be exactly the same as the previous post
