Category: From Excel To R

  • read Excel files in R

    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…

  • Round, roundup, rounddown, trunc in R

    Round, roundup, rounddown, trunc in R

    Here is how to round or truncate numbers, dates, and times in R in different ways. Depending on your goals and situation, there might be different needs and efficient solutions.

  • Day of the week number in R

    Day of the week number in R

    There is R base function like weekdays that can return the name of the weekday. But what if you want to get the day of the week number in R to do calculations? Here is how to do that by using one of the most popular R packages.

  • Edit R data frame almost like in Excel

    Edit R data frame almost like in Excel

    Do you want to edit R data frame like an Excel table? It is not possible the same way. But on the other hand, there is a solution that is comfortable enough to edit a few entries.

  • Move column to a specific position in R

    Move column to a specific position in R

    The easiest way to move the data frame column to a specific position in R is by using the function relocate from package dplyr.

  • How to switch from Excel to R

    How to switch from Excel to R

    As an Excel user for many years, I’m periodically trying new things to work with data and one of them was R. If you are interested in R, then here are a few tips and inspirational words that worked for me and may work for you.