By default, there is a review form on WooCommerce product page, but customers can’t reply and discuss. If you want to add a comment form or question/answer form, you may need to install some plugins like WooDiscuz. However, we can hack comment template to achieve this without any plugin.
Add A Comment Form / Q&A Form To WooCommerce Product Page Read More »
Stock market data is valuable for analysis, but accessing it can be challenging. Yahoo Finance offers a convenient alternative, allowing users to search by stock symbols. While the free API occasionally encounters errors, it remains a viable option for manual retrieval. For automated tasks, try/except statements can help manage connection issues. Other API services exist, but verifying supported symbols is crucial before investing.
Retrieve Stock Historical Data With Python And Yahoo Finance API Read More »
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 »
When scheduling tasks on PythonAnywhere, remember to include the Python interpreter before the file path. A common mistake is omitting “python3.X” in the command. This oversight can lead to tasks appearing to execute correctly but failing to update the database. Always double-check your task command syntax.
PythonAnywhere – Tasks Executed Correctly But Inserting Database Failed 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〉.
