Data Science – Page 3

Import A Deep Learning Embedding Model To A Traditional Machine Learning Model

AI, Data Science | 2024-09-19

Importing deep learning embeddings into traditional machine learning models combines the strengths of both approaches. This technique leverages rich feature representations, enables transfer learning, and improves computational efficiency. It allows for hybrid models that balance complexity with interpretability, offering customization and fine-tuning options for specific tasks and datasets.

Import A Deep Learning Embedding Model To A Traditional Machine Learning Model Read More »

Python Pip/Pipenv Explanation And Most Used Command

Data Science, Python | 2025-06-02

pip is a basic package installer, while pipenv offers comprehensive project environment management. pip installs packages globally or in virtual environments, whereas pipenv automatically creates and manages virtual environments, resolves dependencies, and locks versions. Choose based on project complexity and environment isolation needs.

Python Pip/Pipenv Explanation And Most Used Command Read More »

Machine Learning / Deep Learning Algorithm And Where To Find Them

AI, Data Science | 2024-09-19

Machine Learning / Deep Learning Algorithm And Where To Find Them Read More »

MySQL Threw “1062 – Duplicate Entry” Even There Are Not Duplicated Rows

Data Science | 2024-09-19

When inserting broker-level trading data for Taiwan stocks into MySQL, an error occurs indicating duplicate entries for the primary key. Possible causes include null values, case-insensitive collation, and using float columns as primary keys. These issues can lead to unexpected insertion errors despite data appearing unique.

MySQL Threw “1062 – Duplicate Entry” Even There Are Not Duplicated Rows Read More »

Fix Python AttributeError: module ‘lib’ has no attribute ‘OpenSSL_add_all_algorithms’

Data Science, Python | 2024-09-19

Creating a Python 3.7 virtual environment with conda failed due to conflicts between pyOpenSSL and Cryptography. The error stems from missing OpenSSL algorithms. To resolve, install pyOpenSSL version 22.1.0 using pip, which automatically installs the compatible cryptography 38.0.4.

Fix Python AttributeError: module ‘lib’ has no attribute ‘OpenSSL_add_all_algorithms’ Read More »

How to Reload Custom Python Modules To Apply Changes in Visual Studio Code Using importlib

Data Science, Programming, Python | 2024-09-19

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.

How to Reload Custom Python Modules To Apply Changes in Visual Studio Code Using importlib Read More »

Encoding Issues To Connect MySQL With Python

Data Science, Programming, Python | 2024-08-15

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.

Encoding Issues To Connect MySQL With Python Read More »

A Day in The Life of A Data Scientist 1

AI, Data Science | 2025-03-12

Data scientists mine business value from data and need to possess skills in statistics and machine learning. Different industries in Taiwan have varying definitions for this position, but it primarily supports decision-making. Although the retail industry offers lower salaries, it provides a broad and interesting range of analysis, making it suitable for newcomers to enter the field.

A Day in The Life of A Data Scientist 1 Read More »

Google Trends Enhanced – Search Multiple Keywords At One Time

Data Science, Python | 2024-09-19

Google Trends Enhanced revolutionizes keyword research by allowing users to search more than five keywords simultaneously. It groups keywords, obtains search interest data, and merges results into an Excel file. The tool overcomes data comparison challenges by using a benchmark keyword for scaling. It also provides daily data for periods exceeding nine months, offering greater flexibility for various analytical purposes.

Google Trends Enhanced – Search Multiple Keywords At One Time Read More »

Stock Market Prediction With Machine Learning. The Project Grow Your Analytic And Investment Skills.

Data Science, Investment, Python | 2024-09-19

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.

Stock Market Prediction With Machine Learning. The Project Grow Your Analytic And Investment Skills. Read More »