{"id":3264,"date":"2016-11-01T15:48:43","date_gmt":"2016-11-01T14:48:43","guid":{"rendered":"https:\/\/abcdr.guyader.pro\/?p=3264"},"modified":"2018-04-08T00:02:34","modified_gmt":"2018-04-07T23:02:34","slug":"importer-rapidement-plusieurs-fichiers-csv","status":"publish","type":"post","link":"https:\/\/thinkr.fr\/abcdr\/importer-rapidement-plusieurs-fichiers-csv\/","title":{"rendered":"Comment importer rapidement plusieurs fichiers CSV"},"content":{"rendered":"<p>Avec R, il est tout \u00e0 fait possible de r\u00e9aliser une multiple importation des fichiers CSV (autres types de fichiers). La fonction ci-dessous utilise les fonctions <em><strong>bind_rows<\/strong><\/em> et la syntaxe de la librairie <strong>dplyr<\/strong>.<\/p>\n<pre><code> multmerge &lt;- function(mypath = getwd()){\nrequire(dplyr)\ndataset &lt;- list.files(path=mypath, full.names=TRUE, pattern=\"\\.csv\") %&gt;% lapply(read.csv, header=TRUE, sep=\"t\") %&gt;% bind_rows()\ndataset\n}\n<\/code><\/pre>\n<p>Dans cette fonction, l&rsquo;objet <em>mypath<\/em> indique l&#8217;emplacement o\u00f9 se trouve tous les fichiers CSV. Par d\u00e9faut, la fonction va chercher dans l&rsquo;espace de travail actuel (<strong>getwd<\/strong>). Il est possible de le modifier manuel comme ci-dessous:<\/p>\n<pre><code>\u00a0mydata &lt;- \u00a0multmerge(mypath=\"Nom\/Du\/Chemin\/Des\/Fichiers\")<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Avec R, il est tout \u00e0 fait possible de r\u00e9aliser une multiple importation des fichiers CSV (autres types de fichiers). La fonction ci-dessous utilise les fonctions bind_rows et la syntaxe de la librairie dplyr. multmerge &lt;- function(mypath = getwd()){ require(dplyr) dataset &lt;- list.files(path=mypath, full.names=TRUE, pattern=\u00a0\u00bb\\.csv\u00a0\u00bb) %&gt;% lapply(read.csv, header=TRUE, sep=\u00a0\u00bbt\u00a0\u00bb) %&gt;% bind_rows() dataset } Dans cette fonction, l&rsquo;objet mypath indique l&#8217;emplacement o\u00f9 se trouve tous les fichiers CSV. Par d\u00e9faut, la fonction va chercher dans l&rsquo;espace de travail actuel (getwd). Il est possible de le modifier manuel comme ci-dessous: \u00a0mydata &lt;- \u00a0multmerge(mypath=\u00a0\u00bbNom\/Du\/Chemin\/Des\/Fichiers\u00a0\u00bb)<a class=\"more-link\" href=\"https:\/\/thinkr.fr\/abcdr\/importer-rapidement-plusieurs-fichiers-csv\/\">Read More &rarr;<\/a><\/p>\n","protected":false},"author":2,"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":[10],"tags":[],"class_list":{"0":"entry","1":"post","2":"publish","3":"author-vincent","4":"post-3264","6":"format-standard","7":"category-importation-de-donnees"},"acf":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p9O7Sx-QE","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3264","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\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/comments?post=3264"}],"version-history":[{"count":2,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3264\/revisions"}],"predecessor-version":[{"id":4310,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/posts\/3264\/revisions\/4310"}],"wp:attachment":[{"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/media?parent=3264"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/categories?post=3264"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thinkr.fr\/abcdr\/wp-json\/wp\/v2\/tags?post=3264"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}