{"id":3106,"date":"2015-07-10T12:35:45","date_gmt":"2015-07-10T11:35:45","guid":{"rendered":"https:\/\/abcdr.guyader.pro\/?p=3106"},"modified":"2018-04-08T00:01:52","modified_gmt":"2018-04-07T23:01:52","slug":"comment-fusionner-deux-data-frame-merge","status":"publish","type":"post","link":"https:\/\/thinkr.fr\/abcdr\/comment-fusionner-deux-data-frame-merge\/","title":{"rendered":"Comment fusionner deux data.frame ? : merge"},"content":{"rendered":"<p>La fonction <b>merge()<\/b> permet de fusionner deux data.frame ayant une variables en commun ainsi que des donn\u00e9es compl\u00e9mentaires.<\/p>\n<pre><code><br \/>age &lt;- c(11,13,14)\n\nprenom &lt;- c(\"simon\",\"nicolas\",\"cyril\")\n\nmoyenne &lt;- c(12.1,14.2,8.6)\n\nclasse &lt;- factor(c(\"6eme\",\"4eme\",\"3eme\"))\n\n\u00a0\n\neleves &lt;- cbind.data.frame(age,prenom,classe, moyenne)\n\n#On colle les donn\u00e9es dans un data.frame\n\n\u00a0\n\nnb_elev &lt;- c(29,32,36,33)\n\nmoy_classe &lt;- c(10.2,11.3,10.6,10.9)\n\ncaract_classe &lt;- cbind.data.frame(c(\"6eme\",\"5eme\",\"4eme\",\"3eme\"),nb_elev,moy_classe)\n\n#On colle les donn\u00e9es dans un data.frame\n\n\u00a0\n\nnames(caract_classe) &lt;- c(\"classe\",\"effectif\",\"moyenne de la classe\")\n\n#On attribue \u00e0 chaque variable le nom que l'on d\u00e9sire\n\n\u00a0\n\nmerge(eleves,caract_classe,by=\"classe\")\u00a0\n\n#On fusionne les donn\u00e9es dans un data.frame\n\n#La cl\u00e9 commune aux donn\u00e9es est la variable \"classe\"\n\n#En effet, la variable commune aux data.frame \u00ab\u00a0eleves\u00a0\u00bb et \u00ab\u00a0caract_classe\u00a0\u00bb est la variable classe.\n\n<\/code><\/pre>\n<p> \u00a0<\/p>\n<p>On obtient :<\/p>\n<p>\u00a0<\/p>\n<pre><code><br \/><br \/>merge(eleves,caract_classe,by=\"classe\") #La cl\u00e9 est la variable \"ville\"\n\n\u00a0 classe age\u00a0 prenom moyenne effectif moyenne de la classe\n\n1\u00a0\u00a0 3eme\u00a0 14\u00a0\u00a0 cyril\u00a0\u00a0\u00a0\u00a0 8.6\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 33\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10.9\n\n2\u00a0\u00a0 4eme\u00a0 13 nicolas\u00a0\u00a0\u00a0 14.2\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 36\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10.6\n\n3\u00a0\u00a0 6eme\u00a0 11\u00a0\u00a0 simon\u00a0\u00a0\u00a0 12.1\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 29\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10.2<br \/> <\/code><\/pre>\n<p>\u00a0<\/p>\n<p>\u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"<p>La fonction merge() permet de fusionner deux data.frame ayant une variables en commun ainsi que des donn\u00e9es compl\u00e9mentaires. age &lt;- c(11,13,14) prenom &lt;- c(\u00ab\u00a0simon\u00a0\u00bb,\u00a0\u00bbnicolas\u00a0\u00bb,\u00a0\u00bbcyril\u00a0\u00bb) moyenne &lt;- c(12.1,14.2,8.6) classe &lt;- factor(c(\u00ab\u00a06eme\u00a0\u00bb,\u00a0\u00bb4eme\u00a0\u00bb,\u00a0\u00bb3eme\u00a0\u00bb)) \u00a0 eleves &lt;- cbind.data.frame(age,prenom,classe, moyenne) #On colle les donn\u00e9es dans un data.frame \u00a0 nb_elev &lt;- c(29,32,36,33) moy_classe &lt;- c(10.2,11.3,10.6,10.9) caract_classe &lt;- cbind.data.frame(c(\u00ab\u00a06eme\u00a0\u00bb,\u00a0\u00bb5eme\u00a0\u00bb,\u00a0\u00bb4eme\u00a0\u00bb,\u00a0\u00bb3eme\u00a0\u00bb),nb_elev,moy_classe) #On colle les donn\u00e9es dans un data.frame \u00a0 names(caract_classe) &lt;- c(\u00ab\u00a0classe\u00a0\u00bb,\u00a0\u00bbeffectif\u00a0\u00bb,\u00a0\u00bbmoyenne de la classe\u00a0\u00bb) #On attribue \u00e0 chaque variable le nom que l&rsquo;on d\u00e9sire \u00a0 merge(eleves,caract_classe,by=\u00a0\u00bbclasse\u00a0\u00bb)\u00a0 #On fusionne les donn\u00e9es dans un data.frame #La cl\u00e9 commune aux donn\u00e9es est la variable \u00ab\u00a0classe\u00a0\u00bb #En effet, la variable commune aux data.frame \u00ab\u00a0eleves\u00a0\u00bb et \u00ab\u00a0caract_classe\u00a0\u00bb est<a class=\"more-link\" href=\"https:\/\/thinkr.fr\/abcdr\/comment-fusionner-deux-data-frame-merge\/\">Read More &rarr;<\/a><\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"content-type":"","rop_custom_images_group":[],"rop_custom_messages_group":[],"rop_publish_now":"initial","rop_publish_now_accounts":{"twitter_399453572_399453572":""},"rop_publish_now_history":[],"rop_publish_now_status":"pending","jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[8,12,23],"tags":[],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-helene","4":"post-3106","6":"format-standard","7":"category-fonctions-utiles","8":"category-manipulation-de-donnees","9":"category-transformation-de-donnees"},"acf":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9O7Sx-O6","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/comments?post=3106"}],"version-history":[{"count":2,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3106\/revisions"}],"predecessor-version":[{"id":4269,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3106\/revisions\/4269"}],"wp:attachment":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/media?parent=3106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/categories?post=3106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/tags?post=3106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}