Google Trends Enhanced overcomes limitations by grouping keywords, merging data, and exporting to Excel. It tackles the challenge of comparative values by using a benchmark keyword for scaling. The tool also provides daily data for periods over nine months, offering flexibility for various analyses without manual Excel work.
Google Trends Enhanced – Search Multiple Keywords At One Time Read More »
CircleDNA offers genetic testing services through saliva sample analysis of personal genetic information. Test results cover multiple aspects including health, nutrition, and exercise, serving as reference for lifestyle adjustments. While not as precise as specialized testing, it’s suitable for those wanting comprehensive genetic insights. Watch for limited-time promotions when purchasing, and the testing process includes receiving packages, sampling, and returning samples.
Scientific Healthy Living Proposal 1 – CircleDNA Genetic Testing Report Read More »
When you try to read a csv file in Python, pd.read_csv() is the most common method. However, the process of decoding sometimes causes errors as below, and it may not work even you tune several arguments.
Python Custom CSV Reader Function To Prevent Codec Error Read More »
Iterating a path to list all subdirectories and files is an extremely helpful function. You can read bulk excel files with several pretty simple codes. As a lazy guy like me, wrap it to a function make me write code effectively. The code below seems huge, but it contains multiple pieces of functions. All of them are used to operate lists, and the main function to list paths and files is os_get_dir_list()
List All Subdirectories And Files In Python, Then Assign Depth And Extensions. Read More »
So many Python programmers complained about the inconvenience of datetime package. This function was inspired by the lubridate library in R, and there is a ymd() that can convert an integer series to date.
R lubridate ymd Function in Python, Convert Integer To Date Read More »
In Shopee’s data analysis competition, tight time constraints were the biggest challenge. I recommend dividing teams into Data Handlers, Utility Player (PM), and Model Builder, with multiple contingency plans. When internet download speeds are slow, split into WiFi and mobile data groups. Proper process planning and risk management are essential for completing tasks within limited time.
Project Management Skills Learned from Shopee Data Analysis Competition Read More »
If you want to bulk convert WordPress posts to WooCommerce products, the best way is to operate in the database, without any plugins. If you enter phpMyAdmin and check wp_posts table, you can find the columns as the screenshot The column we truly need is ‘post_type’. The post_type of WordPress posts is ‘post’, and post_type of WooCommerce products is ‘product’. As a result, the mission we need to do is change the post_type.
Bulk Convert WordPress Posts To WooCommerce Products Read More »
Implementing Google Ads conversion tracking on WordPress requires adding a global site tag and event snippets. The global tag goes between
tags, while event snippets trigger on specific actions. For security, use post_meta to add conversion code, and employ jQuery to activate the gtag function on desired elements.Add A Google Ads Conversion Tracking Tag To Your WordPress Website Read More »
Apriori is a common algorithm for retail analysis. But it will be heavy if you load huge transaction data. You may want to focus on association rules of specific SKU (or called CUG) in some cases. Based on apyori package 1.1.2 for Python, I hacked it to be liter and faster. Most of the arguments are the same with apyori, but with an additional list argument, target.
Target_Apyori – Improved Apriori Algorithm For Specific Products In Python Read More »
Password-protected posts typically hide excerpts, but hacking this can boost marketing efforts. By displaying teasers and requiring newsletter subscriptions for access, you can engage users. Alternatives to built-in functions exist, allowing excerpt display on archive or single pages. For WooCommerce, extend templates to show excerpts alongside password forms, enhancing user experience.
Display Excerpts Of Password Protected Posts For WordPress Read More »
