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…
R “not in” operator, opposite of “in”
R operator %in% is handy for work with vectors, but how to use it oppositely? Something like %notin% that will exclude anything that…
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…
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…
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…
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…
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…
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.…
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.