[R] to build a data.frame

[Rui Barradas]

Hello,

Try the following.

aggregate(Project ~ Country + Iso, data = df, FUN = length)


Hope this helps,

Rui Barradas

Em 19-06-2013 15:23, Arnaud Michel escreveu:
> Hello
>
> I have the following dataframe
>
> df <- data.frame(
> Project=c("Abaco","Abaco","Abac","Abaco","Abaco","Abaco",
> "Abaco","Adaptclone","Adaptclone","Adaptclone","Adaptclone","Adaptclone",
> "Adaptclone","Adopt","Adopt","Adopt"),
>
> Country=c("Zimbabwe","Burkina Faso","South Africa","Madagascar","Tanzania",
> "Mali","Mozambique","Madagascar","Ghana","Nigeria","Kenya","Burkina Faso",
>   "South Africa","Tanzania","Kenya","Ethiopia" ),
>
> Iso=c("ZW","BF","ZA","MG","TZ","ML","MZ","MG","GH","NG","KE","BF",
>   "ZA","TZ","KE","ET"))
>
> I would like to build a other dataframe with name Country
> where column 1 is country,
> the column 2 is number of project (in the country)
> the column 3 is the code Iso (wich correspond with the country : Ex ZW
> is ISO of Zimbabwe)
>        Pays        PaysIso  NbrProj
>     Zimbabwe      ZW       1
>   Burkina Faso    BF        2
>
>
> I know associate Country and Number of projets but how associate Iso
>
> Any idea ?
> Thank you for your help
>