<div><div><div><div data-width="55" data-show-faces="false" data-send="true" data-layout="box_count" data-height="62" data-href="http://www.r-bloggers.com/grea-the-rstudio-add-in-to-read-all-the-data-into-r/"></div></div><div><a data-url="http://www.r-bloggers.com/grea-the-rstudio-add-in-to-read-all-the-data-into-r/" data-counturl="http://www.r-bloggers.com/grea-the-rstudio-add-in-to-read-all-the-data-into-r/" data-count="vertical" data-text="GREA: The RStudio Add-In to read ALL the data into R!" target="_blank" class="twitter-share-button" data-via="rbloggers" href="https://twitter.com/share"></a></div><div></div></div><div></div></div>
<p><em>Guest post by <strong>Stanislaus Stadlmann</strong></em></p>
<p>Have you also been overburdened by the vast selection of R packages to read different filetypes into R? Do you sometimes just want to get that .csv file up and running in your environment, but forgot about all those endless <code>read.table()</code> options?</p>
<p>Well, GREA’s got you covered. <a target="_blank" href="https://github.com/Stan125/GREA">Gotta Read ‘Em All</a> is an RStudio Add-In meant to help the R-User parse all important filetypes into R without having to remember any actual code or package. This is done interactively via a user interface built upon the <a target="_blank" href="http://shiny.rstudio.com">Shiny</a> framework. For reading the files, <a target="_blank" href="https://cran.r-project.org/web/packages/rio/index.html">rio</a> (by Thomas Leeper) is used, which can read a vast amount of different filetypes.</p>
<p>Here’s how it works: In the beginning, the user selects a file on his computer. After some adjustments (which are done interactively), the proper function to read the file is pasted into the console, with an object name that can be specified by the user. In between, the user can always head to the preview to see what the parsed file would look like with the current options.</p>
<h3><b>Installation</b></h3>
<p>Installation is easy. Just run the following code:</p>
<p><code>devtools::install_github(&quot;Stan125/GREA&quot;)</code></p>
<h3><b>Usage</b></h3>
<h4>1. Starting the Add-In</h4>
<p>Calling the Add-In is simple: just click on the Add-In Tab and select ‘Gotta Read Em All’. The Add-In itself quickly pops up and you are ready to start!</p>
<h4>2. Selecting the Dataset</h4>
<p>Once the Add-In is started up, press the “Select File” button to select a file on your computer. Then, type in a name for your desired dataset. Once the file is loaded into the Add-In, you may see additional options for parsing the file on the right. Ignore those for now and head right to the “previews” tab.</p>
<p><img sizes="(max-width: 450px) 100vw, 450px" srcset="http://i1.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step2.png?resize=450%2C333 450w, http://i1.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step2.png?w=610 610w" alt="step2" class="wp-image-129619" src="http://i1.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step2.png?resize=450%2C333" data-recalc-dims="1"></p>
<h4>3. Looking at the preview</h4>
<p>The previews tab shows a preview of what your dataframe would look like if you parsed it with the current settings. If something looks odd (e.g. your column names fell into the first row of the dataset), head back to the first tab. We can see that in our case, the column and decimal separators are wrongly specified. If everything is right, still head back to the first tab.</p>
<p><img sizes="(max-width: 450px) 100vw, 450px" srcset="http://i0.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step3.png?resize=450%2C350 450w, http://i0.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step3.png?w=567 567w" alt="step3" class="wp-image-129620" src="http://i0.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step3.png?resize=450%2C350" data-recalc-dims="1"></p>
<h4>4. Adjusting stuff</h4>
<p>If the preview of your dataframe looked off, you now have the chance to adjust some parameters (e.g. Sheet Index for Excel files, or separator for .csv files). Adjust them so your preview looks exactly like you want them to. When you have typed in a name for your newly aquired dataset and are then finished, press “done”. Afterwards, the function to read your dataset is pasted into your console. Boom! You’re good to go.</p>
<p><img sizes="(max-width: 450px) 100vw, 450px" srcset="http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?resize=450%2C79 450w, http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?resize=768%2C136 768w, http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?resize=1024%2C181 1024w, http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?w=1506 1506w, http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?w=912 912w, http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?w=1368 1368w" alt="step4" class="wp-image-129621" src="http://i2.wp.com/www.r-bloggers.com/wp-content/uploads/2016/07/step4.png?resize=450%2C79" data-recalc-dims="1"></p>
<h3><b>Remarks</b></h3>
<p>RStudio Add-Ins require the newest release of RStudio. GREA can be found on this <a target="_blank" href="https://github.com/Stan125/GREA">GitHub Page</a>. Feedback and Suggestions are always very much welcome.</p>
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/dU-3B7fQJ2c">