> Ive found out a way around my problem. I was trying to plaot a histogram
of
> strings, but I had to change it into integers. I ran an sql query on the
> original DB that I got the CSV file from and used COUNT to get the
number of
> each unique item in a given column. I then used these numbers t
The sqldf package allows you to apply SQL statements to R data frames:
http://sqldf.googlecode.com
On Wed, May 6, 2009 at 12:08 PM, DonkeyRhubarb wrote:
>
>
> Ive found out a way around my problem. I was trying to plaot a histogram of
> strings, but I had to change it into integers. I ran an sql
Ive found out a way around my problem. I was trying to plaot a histogram of
strings, but I had to change it into integers. I ran an sql query on the
original DB that I got the CSV file from and used COUNT to get the number of
each unique item in a given column. I then used these numbers to create
Im more than happy to use a barplot, but at this stage time is just so short
I need something to show. I can find examples of plotting a line of numbers
that has been manually typed into R, but Im missing something to do it from
a CSV file.
The name of my csv file is OutputFromDB. Would you know
Sorry for mailing to you personally...
for types
read.csv(file.choose())
freqTable = table(types)
pie(freqTable)
##example for some data
temp = data.frame(types = 1:10)
pie(table(temp))
Thomas Roth
PS: use barplot instead of pie
DonkeyRhubarb schrieb:
Hi all,
I am looking to create a pie
> I am looking to create a pie chart from a given column in a .csv file.
>
> My class variables are as follows:
>
> entry_type, uniquekey, types, title,url, abstract, journal,
> author, month,
> year, howpublished
>
> So say I want to export a pie chart that groups together all entrie
Hi,
I used ggplot2 for plotting recently, you should give it a try - it's excellent.
http://had.co.nz/ggplot2/
All the best
Philipp
DonkeyRhubarb wrote:
> Hi all,
>
> I am looking to create a pie chart from a given column in a .csv file.
>
> My class variables are as follows:
>
> entry_type
You could go to rseek.org and search for pie chart; that will give you
lots of ideas and examples, including discussion of why pie charts
are a bad idea.
Sarah
On Tue, May 5, 2009 at 9:02 AM, DonkeyRhubarb wrote:
>
> Hi all,
>
> I am looking to create a pie chart from a given column in a .csv fi
Hi all,
I am looking to create a pie chart from a given column in a .csv file.
My class variables are as follows:
entry_type, uniquekey, types, title,url, abstract, journal,
author, month,
year, howpublished
So say I want to export a pie chart that groups together all entries u
9 matches
Mail list logo
