Month: July 2019

  • How to create group index with Power Query or R

    How to create group index with Power Query or R

    It is possible to generate a group index (unique row ids) by one or many groups in Power Query. It comes handy when you have to detect the first or last record in each group. Here is 2 solutions: group index with M language and group index with R.

  • Incomplete final line found on Rprofile.site when installing from GitHub

    Incomplete final line found on Rprofile.site when installing from GitHub

    I was stumbling on this “incomplete final line found on Rprofile” error while installing d3rain package with the following code remotes::install_github(“daranzolin/d3rain”). In one of the previous post I was modifying my Rprofile.site file and there is definitely a connection with this error.

  • How to generate time intervals or date sequence in R

    How to generate time intervals or date sequence in R

    In this post, you will get summary and code examples for creating time intervals, date or date-time sequence different ways in R. For example, you have to make summary statistics for 15 minute time intervals in R. There might be situations wherein a 15 minute interval is no data. It is necessary to, first of…

  • How to animate Excel chart in PowerPoint

    How to animate Excel chart in PowerPoint

    Data visualizations are a great way to present your data, but sometimes you need to add some animation effects in PowerPoint to make your storytelling better. Here is a fast and easy approach on how to animate an Excel chart in a few steps.