<p><div><div><div><div data-width="100" data-show-faces="false" data-send="true" data-layout="button_count" data-height="21" data-href="https://www.r-bloggers.com/dplyr-0-6-0-coming-soon/"></div></div><div></div></div><div></div></div>
<div>
(This article was first published on <strong><a href="https://blog.rstudio.org/2017/04/13/dplyr-0-6-0-coming-soon/"> RStudio Blog</a></strong>, and kindly contributed to <a rel="nofollow" href="https://www.r-bloggers.com/">R-bloggers)</a> </div>
<p>I’m planning to submit dplyr 0.6.0 to CRAN on May 11 (in four weeks time). In preparation, I’d like to announce that the release candidate, dplyr 0.5.0.9002 is now available. I would really appreciate it if you’d try it out and report any problems. This will ensure that the official release has as few bugs as possible.</p>
<div>
<h2>Installation</h2>
<p>Install the pre-release version with:</p>
<pre><code># install.packages(&quot;devtools&quot;)
devtools::install_github(&quot;tidyverse/dplyr&quot;)</code></pre>
<p>If you discover any problems, please file a minimal <a target="_blank" rel="nofollow" href="http://github.com/jennybc/reprex#readme">reprex</a> on <a target="_blank" rel="nofollow" href="https://github.com/tidyverse/dplyr/issues">GitHub</a>. You can roll back to the released version with:</p>
<pre><code>install.packages(&quot;dplyr&quot;)</code></pre>
</div>
<div>
<h2>Features</h2>
<p>dplyr 0.6.0 is a major release including over 100 bug fixes and improvements. There are three big changes that I want to touch on here:</p>
<ul>
<li>Databases</li>
<li>Improved encoding support (particularly for CJK on windows)</li>
<li>Tidyeval, a new framework for programming with dplyr</li>
</ul>
<p>You can see a complete list of changes in the draft <a target="_blank" rel="nofollow" href="https://github.com/tidyverse/dplyr/releases/tag/v0.6.0-rc">release notes</a>.</p>
<div>
<h3>Databases</h3>
<p>Almost all database related code has been moved out of dplyr and into a new package, <a target="_blank" rel="nofollow" href="http://github.com/hadley/dbplyr/">dbplyr</a>. This makes dplyr simpler, and will make it easier to release fixes for bugs that only affect databases.</p>
<p>To install the development version of dbplyr so you can try it out, run:</p>
<pre><code>devtools::install_github(&quot;hadley/dbplyr&quot;)</code></pre>
<p>There’s one major change, as well as a whole heap of bug fixes and minor improvements. It is now no longer necessary to create a remote “src”. Instead you can work directly with the database connection returned by DBI, reflecting the robustness of the DBI ecosystem. Thanks largely to the work of <a target="_blank" rel="nofollow" href="https://github.com/krlmlr">Kirill Muller</a> (funded by the <a target="_blank" rel="nofollow" href="https://www.r-consortium.org/">R Consortium</a>) DBI backends are now much more consistent, comprehensive, and easier to use. That means that there’s no longer a need for a layer between you and DBI.</p>
<p>You can continue to use <code>src_mysql()</code>, <code>src_postgres()</code>, and <code>src_sqlite()</code> (which still live in dplyr), but I recommend a new style that makes the connection to DBI more clear:</p>
<pre><code>con &lt;- DBI::dbConnect(RSQLite::SQLite(), &quot;:memory:&quot;)
DBI::dbWriteTable(con, &quot;iris&quot;, iris)
#> [1] TRUE

iris2 &lt;- tbl(con, &quot;iris&quot;)
iris2
#> Source:     table&lt;iris> [?? x 5]
#> Database:   sqlite 3.11.1 [:memory:]
#> 
#>    Sepal.Length Sepal.Width Petal.Length Petal.Width Species
#>           &lt;dbl>       &lt;dbl>        &lt;dbl>       &lt;dbl>   &lt;chr>
#> 1           5.1         3.5          1.4         0.2  setosa
#> 2           4.9         3.0          1.4         0.2  setosa
#> 3           4.7         3.2          1.3         0.2  setosa
#> 4           4.6         3.1          1.5         0.2  setosa
#> 5           5.0         3.6          1.4         0.2  setosa
#> 6           5.4         3.9          1.7         0.4  setosa
#> 7           4.6         3.4          1.4         0.3  setosa
#> 8           5.0         3.4          1.5         0.2  setosa
#> 9           4.4         2.9          1.4         0.2  setosa
#> 10          4.9         3.1          1.5         0.1  setosa
#> # ... with more rows</code></pre>
<p>This is particularly useful if you want to perform non-SELECT queries as you can do whatever you want with <code>DBI::dbGetQuery()</code> and <code>DBI::dbExecute()</code>.</p>
<p>If you’ve implemented a database backend for dplyr, please read the <a target="_blank" rel="nofollow" href="https://github.com/hadley/dbplyr/blob/master/NEWS.md#backends">backend news</a> to see what’s changed from your perspective (not much). If you want to ensure your package works with both the current and previous version of dplyr, see <code>wrap_dbplyr_obj()</code> for helpers.</p>
</div>
<div>
<h3>Character encoding</h3>
<p>We have done a lot of work to ensure that dplyr works with encodings other that Latin1 on Windows. This is most likely to affect you if you work with data that contains Chinese, Japanese, or Korean (CJK) characters. dplyr should now just work with such data.</p>
</div>
<div>
<h3>Tidyeval</h3>
<p>dplyr has a new approach to non-standard evaluation (NSE) called tidyeval. Tidyeval is described in detail in a new <a target="_blank" rel="nofollow" href="http://dplyr.tidyverse.org/articles/programming.html">vignette about programming with dplyr</a> but, in brief, it gives you the ability to interpolate values in contexts where dplyr usually works with expressions:</p>
<pre><code>my_var &lt;- quo(homeworld)

starwars %>%
  group_by(!!my_var) %>%
  summarise_at(vars(height:mass), mean, na.rm = TRUE)
#> # A tibble: 49 × 3
#>         homeworld   height  mass
#>             &lt;chr>    &lt;dbl> &lt;dbl>
#> 1        Alderaan 176.3333  64.0
#> 2     Aleen Minor  79.0000  15.0
#> 3          Bespin 175.0000  79.0
#> 4      Bestine IV 180.0000 110.0
#> 5  Cato Neimoidia 191.0000  90.0
#> 6           Cerea 198.0000  82.0
#> 7        Champala 196.0000   NaN
#> 8       Chandrila 150.0000   NaN
#> 9    Concord Dawn 183.0000  79.0
#> 10       Corellia 175.0000  78.5
#> # ... with 39 more rows</code></pre>
<p>This will make it much easier to eliminate copy-and-pasted dplyr code by extracting repeated code into a function.</p>
<p>This also means that the underscored version of each main verb (<code>filter_()</code>, <code>select_()</code> etc). is no longer needed, and so these functions have been deprecated (but remain around for backward compatibility).</p>
</div>
</div>
<p> <a target="_blank" rel="nofollow" href="http://feeds.wordpress.com/1.0/gocomments/rstudioblog.wordpress.com/4354/"><img alt="" src="http://feeds.wordpress.com/1.0/comments/rstudioblog.wordpress.com/4354/" border="0"></a> <img alt="" src="https://i1.wp.com/pixel.wp.com/b.gif?resize=1%2C1&ssl=1" border="0" data-recalc-dims="1"></p>
<p>
<div>
<div>To <strong>leave a comment</strong> for the author, please follow the link and comment on their blog: <strong><a href="https://blog.rstudio.org/2017/04/13/dplyr-0-6-0-coming-soon/"> RStudio Blog</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 title="The R Project for Statistical Computing" rel="nofollow" href="https://www.r-project.org/">R</a> news and <a title="R tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/tutorial">tutorials</a> on topics such as: <a title="Data science" rel="nofollow" href="https://www.r-bloggers.com/search/data%20science">Data science</a>, <a title="Big Data" rel="nofollow" href="https://www.r-bloggers.com/search/Big%20Data">Big Data, <a title="R jobs" rel="nofollow" href="https://www.r-users.com/">R jobs</a>, visualization (<a title="ggplot and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/ggplot2">ggplot2</a>, <a title="Boxplots using lattice and ggplot2 tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/boxplot">Boxplots</a>, <a title="Maps and gis" rel="nofollow" href="https://www.r-bloggers.com/search/map">maps</a>, <a title="Animation in R" rel="nofollow" href="https://www.r-bloggers.com/search/animation">animation</a>), programming (<a title="RStudio IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/RStudio">RStudio</a>, <a title="Sweave and literate programming" rel="nofollow" href="https://www.r-bloggers.com/search/sweave">Sweave</a>, <a title="LaTeX in R" rel="nofollow" href="https://www.r-bloggers.com/search/LaTeX">LaTeX</a>, <a title="SQL and databases" rel="nofollow" href="https://www.r-bloggers.com/search/SQL">SQL</a>, <a title="Eclipse IDE for R" rel="nofollow" href="https://www.r-bloggers.com/search/eclipse">Eclipse</a>, <a title="git and github, Version Control System" rel="nofollow" href="https://www.r-bloggers.com/search/git">git</a>, <a title="Large data in R using Hadoop" rel="nofollow" href="https://www.r-bloggers.com/search/hadoop">hadoop</a>, <a title="Web Scraping of google, facebook, yahoo, twitter and more using R" rel="nofollow" href="https://www.r-bloggers.com/search/Web+Scraping">Web Scraping</a>) statistics (<a title="Regressions and ANOVA analysis tutorials" rel="nofollow" href="https://www.r-bloggers.com/search/regression">regression</a>, <a title="principal component analysis tutorial" rel="nofollow" href="https://www.r-bloggers.com/search/PCA">PCA</a>, <a title="Time series" rel="nofollow" href="https://www.r-bloggers.com/search/time+series">time series</a>, <a title="finance trading" rel="nofollow" href="https://www.r-bloggers.com/search/trading">trading</a>) and more...
<img height="1" alt="" width="1" src="http://feeds.feedburner.com/~r/RBloggers/~4/lsHJ4L4TP1I"></a></div>