Meta Thinking, Meta Working
1. Python in Excel Overview Yesterday (2023-08-22), Python in Excel was announced at Microsoft Tech Community. In the meantime, we have been using a separate library to link Excel and Python, but finally we provide linkage in a basic environment without the need for separate installation. Announcing Python in Excel: Combining the power of Python and...
There was a bug in the word extraction tool v0.41 that was released last time. Distribute word extraction tool v0.42 that fixes the bug that causes KeyError: “Column(s) ['DBSchema'] do not exist” error. Related article: Word Extraction Tool v0.41 release: Add DBSchema occurrence frequency of words item Kiyoung Kim says...
* Please also refer to v0.42, which was newly released after fixing the bug. Release of word extraction tool v0.42: Bug fix – Productivity Skill (prodskill.com) In the previously distributed word extraction tool (v0.40), Distribute after supplementing the function to add and extract DBSchema occurrence frequency items. The DBSchema_Freq entry indicates how many sources the word...
Continuing from the previous article, we look at the additional explanation of the word extraction tool. Word Extraction Tool (5): Word Extraction Tool Source Code Description (2) 5. Word Extraction Tool Additional Description 5.1. Reasons for using OLE Automation OLE Automation is defined in Wikipedia as follows. In Microsoft Windows application programming, OLE Automation (later renamed simply Automation[1][2]) is an interprocess communication (IPC) mechanism developed by Microsoft. It is based on a subset of the Component Object Model (COM) and was intended to be used through a scripting language (originally Visual Basic), but is now available through several languages on Windows. Source: https://en.wikipedia.org/wiki/OLE_Automation In Python...
Continuing from the previous article, we look at the source code of the word extraction tool implemented in Python. This is a continuation of the previous article. Word Extraction Tool (4): Description of Word Extraction Tool Source Code (1) 4. Word Extraction Tool Source Code 4.3. get_file_text function Lines 357-365: Execute the appropriate function according to the file extension and put the result in df_text...
Examine the source code of a word extraction tool implemented in Python. This is a continuation of the previous article. Word Extraction Tool (3): How to Run Word Extraction Tool and Check Results 4. Source Code of Word Extraction Tool 4.1. Overview 4.1.1. Note the source code The source code of this word extraction tool is...
Let's take a look at how to run the word extraction tool and check the results. This is a continuation of the previous article. Word Extraction Tool (2): Configuration of Execution Environment of Word Extraction Tool 3. Execution of Word Extraction Tool 3.1. Download word extraction tool The word extraction tool is uploaded to github. https://github.com/DAToolset/ToolsForDataStandard/tree/main/WordExtractor...
The word extraction tool is a tool developed in Python, and requires an environment configuration process such as installing Python and necessary packages prior to execution. Let's take a look at the configuration of the execution environment of the word extraction tool. This is a continuation of the previous article. Word Extraction Tool(1): Word Extraction Tool Overview 2. Word Extraction Tool...
An overview of word extraction tools that can be useful for data standardization work, especially for creating standard word candidates. 1. Word Extraction Tool Overview 1.1. Reasons for developing a word extraction tool The most difficult task among the initial tasks of data standardization is to register it as a standard word...
The entire table of contents of the explanation about the work distribution optimization tool using the one-dimensional bin packing algorithm is separately organized. I put a link in the entire table of contents so that you can find the contents of this article as an index. 1. Overview of 1D Bin Packing Optimization Algorithm 1.1. Necessity of Bin Packing 1.2....
English 
한국어 
简体中文 
日本語 
Deutsch 
Español