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.
Month: January 2021
R “not in” operator, opposite of “in”
R operator %in% is handy for working with vectors, but how to use it oppositely? Something like %notin% that will exclude anything that is in a vector.
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.
Find min or max for each row in R
If you want to calculate min or max for a range of columns in each row of the data frame in R, then here is how to do that easily.
dcast : Aggregation function missing: defaulting to length
If you are having this dcast warning Aggregation function missing: defaulting to length there might be a simple solution to this problem.
How to create reproducible R data frame from existing one
Short answer – create a reproducible R data frame with function dput. Dput will give you a good reproducible piece of code that you can use for examples.
R ignoring NA value?
Sometimes it might be very confusing when it looks like R is ignoring the NA value. When some of the code relying on that values, the results might be confusing.
How to change datetime timezone in R
Here is a simple way how to change datetime timezone in the R data frame. If the timezone is not present or is different, there can cause a problem in your calculations. Usually like incorrect results of time difference.
rbind error: numbers of columns of arguments do not match
If you are having this rbind error “numbers of columns of arguments do not match”, there might be a solution to this problem. It is caused by different column names in data frames. The good news is that there is a quick solution to that.
How to connect to PostgreSQL database with Excel or Power BI
Here is how to connect to the PostgreSQL database with Excel or Power BI using the ODBC data source.