[R-es] Uso de merge

[Antonio Rodriguez Andres]

Jose Luis

Column `Country` joining factors with different levels, coercing to
character vector

common_col_names <- intersect(names(sub_kei), names(knowledge))
> common_col_names
[1] "Country" "Year"

nrow(sub_kei) <- 132
nrow(knowledge) <- 3864

Tiene distinto numero de pais como de año, en el sub_kei aparecen 5 años y
en el otro dataset (knowledge) datos anuales de 1995 a 2017. Yo quiero que
el merge dataset aparezcan todos los años

 countrylist <-unique(sub_kei$Country)
> countrylist
 [1] Argentina            Brazil               Colombia             China
              Czech Republic
 [6] Greece               Hungary              India
Indonesia            Israel
[11] Malaysia             Mexico               Pakistan             Peru
             Philippines
[16] Poland               Qatar                Russian Federation   Saudi
Arabia         Thailand
[21] Turkey               United Arab Emirates
22 Levels: Argentina Brazil China Colombia Czech Republic Greece Hungary
India Indonesia Israel ... United Arab Emirates

On Mon, 25 Mar 2019 at 22:08, jose luis <pepeceb using yahoo.es> wrote:

> Hola
> prueba con
> library(dplyr)
> combine <- full_join(sub_kei, knowledge)
>
>
> El Lunes 25 de marzo de 2019 19:49, Antonio Rodriguez Andres <
> antoniorodriguezandres70 using gmail.com> escribió:
>
>
> Hola usuarios de R
>
> Estoy tratando de usar merge, para dos data frame, sin embargo al usarlo me
> da resultado correcto, en términos de emparejamiento de pais y año, pero lo
> que me hace es que el dataframe *y* me hace como un append por filas. Las
> variables comunes son país y año. Alguna sugerencia?
>
>
> combine = merge(sub_kei, knowledge, by = common_col_names, all.x = TRUE,
> all.y = TRUE)
> Saludos
>
> --
>
> Member, Editorial Committee, *The Economic and Labour Relations Review* (a
> SAGE journal)
>
> http://elr.sagepub.com/
>
> Member, Editorial Committee, African Journal of Economic and Management
> Studies
>
>
> http://emeraldgrouppublishing.com/products/journals/editorial_team.htm?id=ajems
>
> https://www.researchgate.net/profile/Antonio_Andres (Research Gate
> profile)
>
>     [[alternative HTML version deleted]]
>
> _______________________________________________
> R-help-es mailing list
> R-help-es using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-help-es
>
>

-- 

Member, Editorial Committee, *The Economic and Labour Relations Review* (a
SAGE journal)

http://elr.sagepub.com/

Member, Editorial Committee, African Journal of Economic and Management
Studies

http://emeraldgrouppublishing.com/products/journals/editorial_team.htm?id=ajems

https://www.researchgate.net/profile/Antonio_Andres (Research Gate profile)

	[[alternative HTML version deleted]]