Always import all columns from CSV file with Power Query
Here is how to manage that you always import all columns from the CSV file with Power Query. There is no difference in solution if you want to import data from the CSV file into Excel or Power BI by using Power Query. That might be very useful in situations when the CSV file is…
dplyr: Adding missing grouping variable
The dplyr message about adding missing grouping variable might appear during a data wrangling process. In my case, when I was using function select from dplyr, the “Adding missing grouping variable” message was displayed, and an unnecessary column appeared in the result. You cannot remove this column as easily as usual.
How to add legend title in Excel chart
At this moment, there is no default and easy way how to add a legend title in an Excel chart. The good news is that you can create that on your own. Here is a simple instruction on how to add legend titles in Excel efficiently.
in
How to create a glowing line chart in Excel
Besides creating a glowing line chart in Excel, here is a possible solution how to deal with seemingly too many series in one plot. There might be different situations where you have to deal with many series. If you have some outliers in your data, this might work for you. Vizualtion has to explain the…
filter in R
Here are more than 5 examples of how to apply a filter in R to take a look or get a subset of your data. Depending on your goals solution might differ.
in
find and change where R packages are installed
Here is how to quickly find out where R packages are installed. You can change the location where R packages are stored or loaded if necessary.
in
How to add a column to the R data frame
If you are new to R, one of the first questions might be how to add a column to the R data frame. Here are multiple scenarios that will help you to handle this task.
in
read Excel files in R
Excel is possibly the most popular tool in work with data, and it is good to know how to read Excel files in R. Unfortunately, there are multiple possible scenarios and Excel file formats that might be necessary to deal with. Some of the problems by reading Excel files in R might be prevented by…
in
determine rank in R
Sometimes you have to calculate a rank in R to indicate an order by one or multiple criteria. It is done by using multiple principles and in various order. I will use dense rank that will not create gaps between ranks, and in the situation when something is identical, the ranks will also be identical.
in
Use data frame row as a column names in R
Here is how to use data frame row as a column names in R, or, in other words, convert the data frame row as a header in R.
in