SDcols in data.table can be tricky to remember. Here are handy examples for quick reference:
1. Use lapply with .SDcols to replace NA values with 0.
2. Aggregate data by summing specific columns using .SDcols.
Keep these snippets for easy copying when needed in your data manipulation tasks.
If you are building your own modules or called codebase, it is common to split some huge functions as independent files. In other words, you may source functions in functions. In my case, I have a file named codebase, which includes many short functions. Also, I built some huge modules based on the codebase. However, when I keep improving the codebase, it is hard to update all huge modules to support the latest version of the codebase. So, the following code is really useful. Besides, it’s a great way to prevent conflicts for the same name functions.
R Tutorial – Source Function Files With Local Attributes Read More »
Enhance your R coding with a simple function to add quotations or special characters to vector elements. Particularly useful for SQL queries in R, this feature streamlines data manipulation. The provided function, add_quotation_for_vector, allows customizable quotation marks for versatile applications in data science workflows.
R Tutorial – Add Quotations Or Special Characters For Elements In Vector Read More »
data.table is a popular library in R, powerful, efficient. But the join/merge syntaxes in data.table are not so straightforward.
The common syntax as below which referred 〈JOINing data in R using data.table〉.
DataCamp offers free access to premium content during their annual free week, ending April 30th, 2021. They often follow with substantial discounts. I transformed my career from marketing to data analysis by using DataCamp to learn Python. Practicing during breaks and before work, I secured a data analyst position at an international company.
Learn Python And R On DataCamp. Start Your Data Science Career. Read More »
