[R] Reshaping Data for bi-partite Network Analysis

[Rui Barradas]

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.
>