<p><div><div><div><div data-show-faces="false" data-height="21" data-width="100" data-layout="button_count" data-send="true" data-href="https://www.r-bloggers.com/tips-for-analyzing-excel-data-in-r/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="http://blog.revolutionanalytics.com/2018/08/how-to-use-r-with-excel.html"> Revolutions</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<div>
<p>If you're familiar with analyzing data in Excel and want to learn how to work with the same data in R, Alyssa Columbus has put together a very useful guide: <a rel="nofollow" href="http://rpubs.com/acolumbus/how-to-use-r-with-excel" target="_blank">How To Use R With Excel</a>. In addition to providing you with a guide for installing and setting up R and the RStudio IDE, it provide a wealth of useful tips for working with Excel data in R, including:</p>
<ul>
<li>To import Excel data into R, use the readxl package</li>
<li>To export Excel data from R, use the openxlsx package</li>
<li>How to remove symbols like &quot;$&quot; and &quot;%&quot; from currency and percentage columns in Excel, and convert them to numeric variables suitable for analysis in R</li>
<li>How to do computations on variables in R, and a list of common Excel functions (like RAND and VLOOKUP) with their R equivalents</li>
<li>How to emulate common Excel chart types (like histograms and line plots) using R plotting functions</li>
</ul>
<p>Conversely, you can also use R within Excel. The guide suggests <a rel="nofollow" href="https://bert-toolkit.com/" target="_blank">BERT (Basic Excel R Toolkit)</a>, which allows you to apply R functions to Excel data via the Excel formula interface:</p>
<p><a rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b022ad38d569f200d-pi" target="_blank"> </a><a rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b022ad3ad07cb200b-pi" target="_blank"><img border="0" alt="BERT-loop" title="BERT-loop" src="http://revolution-computing.typepad.com/.a/6a010534b1db25970b022ad3ad07cb200b-800wi"></a><a rel="nofollow" href="http://revolution-computing.typepad.com/.a/6a010534b1db25970b022ad38d569f200d-pi" target="_blank"><br></a></p>
<p>With BERT, you can also open an R console within Excel, and use R commands to manipulate data within the spreadsheet. BERT is open-source and <a rel="nofollow" href="https://bert-toolkit.com/download-bert" target="_blank">available here</a>, and you can see the detailed guide to using Excel data in R at the link below.</p>
<p>RPubs: <a rel="nofollow" href="http://rpubs.com/acolumbus/how-to-use-r-with-excel" target="_blank">How To Use R With Excel</a> (via author <a rel="nofollow" href="https://twitter.com/alycolumbus/status/1024151847706091520" target="_blank">Alyssa Columbus</a>)</p>
</div>
	<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="http://blog.revolutionanalytics.com/2018/08/how-to-use-r-with-excel.html"> Revolutions</a></strong>.</div>
<hr>
<a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers.com</a> offers <strong><a rel="nofollow" href="https://feedburner.google.com/fb/a/mailverify?uri=RBloggers">daily e-mail updates</a></strong> about <a rel="nofollow" href="https://www.r-project.org/" title="The R Project for Statistical Computing">R</a> news and <a rel="nofollow" href="https://www.r-bloggers.com/search/tutorial" title="R tutorials">tutorials</a> on topics such as: <a rel="nofollow" href="https://www.r-bloggers.com/search/data%20science" title="Data science">Data science</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data" title="Big Data">Big Data, <a rel="nofollow" href="https://www.r-users.com/" title="R jobs">R jobs</a>, visualization (<a rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2" title="ggplot and ggplot2 tutorials">ggplot2</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/boxplot" title="Boxplots using lattice and ggplot2 tutorials">Boxplots</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/map" title="Maps and gis">maps</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/animation" title="Animation in R">animation</a>), programming (<a rel="nofollow" href="https://www.r-bloggers.com/search/RStudio" title="RStudio IDE for R">RStudio</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/sweave" title="Sweave and literate programming">Sweave</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX" title="LaTeX in R">LaTeX</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/SQL" title="SQL and databases">SQL</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/eclipse" title="Eclipse IDE for R">Eclipse</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/git" title="git and github, Version Control System">git</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/hadoop" title="Large data in R using Hadoop">hadoop</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping" title="Web Scraping of google, facebook, yahoo, twitter and more using R">Web Scraping</a>) statistics (<a rel="nofollow" href="https://www.r-bloggers.com/search/regression" title="Regressions and ANOVA analysis tutorials">regression</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/PCA" title="principal component analysis tutorial">PCA</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/time+series" title="Time series">time series</a>, <a rel="nofollow" href="https://www.r-bloggers.com/search/trading" title="finance trading">trading</a>) and more...
<img width="1" alt="" src="http://feeds.feedburner.com/~r/RBloggers/~4/e-4H5V766A0" height="1"></a></div>