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…
Latest Posts
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.
Extract text based on match of multiple possible strings in R
Sometimes there are multiple possible strings that you can locate in text. If you would like to extract text based on the first…
ifelse and NA problem in R
If your data frame contains NA values, then the R function ifelse might return results you don’t desire. Missing values might be a…
Replace R data frame column values conditionally
Here are multiple examples of how to replace R data frame values conditionally. Sometimes it is a specific value like NA, but sometimes…
Check if a column has a missing values (NA) in R
Here are easy ways how to check if an R data frame column has missing values (NA). It might impact results by using…
Reader PicksAll posts
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.
Extract text based on match of multiple possible strings in R
Sometimes there are multiple possible strings that you can locate in text. If you would like to extract text based on the first…
ifelse and NA problem in R
If your data frame contains NA values, then the R function ifelse might return results you don’t desire. Missing values might be a…
Replace R data frame column values conditionally
Here are multiple examples of how to replace R data frame values conditionally. Sometimes it is a specific value like NA, but sometimes…
Check if a column has a missing values (NA) in R
Here are easy ways how to check if an R data frame column has missing values (NA). It might impact results by using…
Add week numbers to Outlook calendar
Sometimes it might be very to quickly understand what is the week numbers in the Outlook calendar. If the week number mentioned in…