does 'table' do the job for you?
> input <- read.table(text = "Name1 Name2 category
+
+ mauro francesco E234
+ luca giuseppe E5578
+ luca franco E5569
+ maria luca E4556", header = TRUE, as.is = TRUE)
> input
Name1 Name2 category
1 mauro francesco E234
2 luca giuseppe E5578
3 luca franco E5569
4 maria luca E4556
> table(input$Name1, input$Name2)
francesco franco giuseppe luca
luca 0 1 1 0
maria 0 0 0 1
mauro 1 0 0 0
>
Jim Holtman
Data Munger Guru
What is the problem that you are trying to solve?
Tell me what you want to do, not how you want to do it.
On Mon, Oct 7, 2013 at 12:09 PM, [email protected] <[email protected]> wrote:
> Dear All,
>
> I Have a dataframe like that:
>
> Name1 Name2 category
>
> mauro francesco E234
> luca giuseppe E5578
> luca franco E5569
> maria luca E4556
> ...
> I would like to calculate the frequency of many time in my data I found in
> the list name:
>
> a<-read.table("pippo.csv",header=T,sep="\t")
> name1<-as.character(a[,1])
> name2<-as.character(a[,2])
> category<-as.character(a[,3])
>
> for(i in 1:lenght(name1)){
> re <-which(name1 == name2)
>
> }
>
> So how can create a table of frequncy of many times I found a name in column
> one respect to the second ?
> Thanks in advance for your help!
> M.
>
> ______________________________________________
> [email protected] mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
______________________________________________
[email protected] mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
