When you program with Visual Studio Code (VS Code) and import a module in Python, the code in that module is only executed once, and subsequent imports of the same module will simply use the already imported module without re-executing its code. This means that if you modify a module after it has been imported, the changes will not be applied until you reload the module.

Google Analytics and Google Tag Manager, the former also includes Google Analytics Enhanced eCommerce, which is an enhanced e-commerce feature. Facebook Pixel is similar to Google Analytics, but it was developed by Facebook, which is an extension to check whether the Pixel is working properly on the website.

There are many types of databases, such as MySQL, and Oracle. Even within the same database type, many Python packages are available, such as MySQLdb, PyMySQL, SQLAlchemy, MySQL Connector Python. Overall, the syntax is similar. The information needed to connect to a database is nothing more than the IP, database name, user account, and password, etc. The basic syntax for using MySQLdb in Python is as follows, remember to add a colon in the SQL syntax in the execute; otherwise, it will go wrong. I also fell for this stupid mistake.

Unfortunately, I dismissed that WordPress won't submit sitemaps automatically. It definitely hurt my SEO. The traffic to my website dropped in the next weeks after uninstalling the sitemap plugin.

Whether you apply Google Trends through the website or writing a program to call the API, as long as you use the service of Google Trends, you can only search for up to five keywords at a time. This is a restriction set by Google and cannot be changed. Then why can the Google Trends Enhanced search multiple keywords at once? The task Google Trends Enhanced does is to group all keywords, obtain each search interest, then merge the data, and export it into a Excel file.

I'm bold enough to call stock forecasting the best because it's a project that can monetize and accumulate experience in data analytics and investment operations. Since investment and programming have become mainstream in this era, combining these two learning paths seems natural and logical. Of course, the cost of learning will be very expensive, but it is just like the beauty of the climb over the mountains that is so appealing.

As a designer or a digital marker, building an attractive portfolio is common sense, but it is also important for data scientists and programmers, even you are not finding a new job recently. Programmers talk about side projects all the time, which create real use cases to grow your expertise, including some problems and solutions that you may never meet in your full-time job.