[R] Reshaping Data for bi-partite Network Analysis

Rui Barradas ruipbarradas at sapo.pt
Sat Apr 13 23:23:33 CEST 2013


Hello,

With the following the order of both rows and columns will be different 
than the order of your example output, but the table is basically the same.

xtabs(time ~ people + place, data = Input)


Hope this helps,

Rui Barradas

Em 13-04-2013 22:03, sylvain willart escreveu:
> Hello
>
> I have a dataset of people spending time in places. But most people don't
> hang out in all the places.
>
> it looks like:
>
>> Input<-data.frame(people=c("Marc","Marc","Joe","Joe","Joe","Mary"),
> +              place=c("school","home","home","sport","beach","school"),
> +              time=c(2,4,3,1,5,4))
>> Input
>    people  place time
> 1   Marc school    2
> 2   Marc   home    4
> 3    Joe   home    3
> 4    Joe  sport    1
> 5    Joe  beach    5
> 6   Mary school    4
>
> In order to import it within R's igraph, I must use graph.incidence(), but
> the data needs to be formatted that way:
>
>>
> Output<-data.frame(school=c(2,0,4),home=c(4,3,0),sport=c(0,1,0),beach=c(0,5,0),
> +                    row.names=c("Marc","Joe","Mary"))
>> Output
>       school home sport beach
> Marc      2    4     0     0
> Joe       0    3     1     5
> Mary      4    0     0     0
>
> The Dataset is fairly large (couple hundreds of people and places), and I
> would very much appreciate if someone could point me to a routine or
> function that could transform my Input dataset to the required Output,
>
> Thank you very much in advance
>
> Regards
>
> Sylvain
>
> PS: sorry for cross-posting this on statnet and then on R help list, but I
> received a message from statnet pointing out the question was more related
> to general data management than actual network analysis. Which is true
> indeed...
>
> 	[[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at r-project.org 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.
>



More information about the R-help mailing list