Re: [R] Categorizing and displaying excel data in tabular format

2014-02-07 Thread Patrick Connolly
On Wed, 05-Feb-2014 at 08:20AM -0800, ashrafali wrote: |> Thank you David. |> |> I tried the Table function with two columns |> |> table(R_format$Client.Mnemonic,R_format$Tasks) |> |> and got something like the one I have attached in this word file |> Task_Summary_for_Clients.docx |>

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-05 Thread ashrafali
Thank you David. I tried the Table function with two columns table(R_format$Client.Mnemonic,R_format$Tasks) and got something like the one I have attached in this word file Task_Summary_for_Clients.docx I need to

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread David Winsemius
On Feb 4, 2014, at 1:40 PM, ashrafali wrote: > I have converted the excel file to csv and imported the data using R Studio. > > This is the file R_format.xlsx > > > I have coded the following: > > list(R_format$Tasks) > list(R_for

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread ashrafali
I have converted the excel file to csv and imported the data using R Studio. This is the file R_format.xlsx I have coded the following: list(R_format$Tasks) list(R_format$Client.Mnemonic) task.freq=table(R_format$Tasks) task.freq cb

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread David Winsemius
On Feb 4, 2014, at 8:49 AM, Greg Snow wrote: > First, .csv files are not Excel files (and I was unable to open the > one you link to). > This is what was in the linked file: Tasks,Client Mnemonic Ibus ,ANMC_AK Ibus ,ANMC_AK Ibus ,YAVA_AZ Ibus ,YAVA_AZ Release upgrade(BE),ANMC_AK OS upgrades ,L

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread Rui Barradas
Hello, With me the following worked: URL <- "http://r.789695.n4.nabble.com/file/n4684711/R_format.csv"; dat <- read.csv(URL) str(dat) 'data.frame': 34 obs. of 2 variables: $ Tasks : Factor w/ 10 levels "Code upgrade BE/FE",..: 4 4 4 4 8 6 6 6 6 6 ... $ Client.Mnemonic: Factor w/

Re: [R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread Greg Snow
First, .csv files are not Excel files (and I was unable to open the one you link to). Second, while the word "Help" is used many ways, this list is intended to assist, i.e. you show that you have done some work and tell us where you are stuck and we are happy to give hints and pointers to help you

[R] Categorizing and displaying excel data in tabular format

2014-02-04 Thread ashrafali
R_format.csv Hi, I am new to R Programming and need help on categorizing and plotting the data in the attached excel file into tabular format. Please help. -- View this message in context: http://r.789695.n4.nabble.com/Categorizin