Category: DA(Data Architecture) Tools

Word Extraction Tool (2): Configure the Word Extraction Tool Execution Environment

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...

Word Extraction Tool(1): Overview of 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...

Naver Korean Dictionary/English Dictionary Search Tool_v1.01_20220708

Distribute “Naver Korean Dictionary/English Dictionary Search Tool_v1.01_20220708” with one error corrected. The outline of Naver Korean and English dictionary search tools and how to use them are summarized in the article below. Overview of Naver Korean Dictionary/English Dictionary Search Tool Today (2022-07-08) the following comments were posted. https://prodtool.tistory.com/28#comment9159871 #ToDo: After reviewing whether to change the comment link, the following error message occurs. I checked with Fiddler...

Overview of Naver Korean Dictionary/English Dictionary Search Tool

An overview of the Naver Korean Dictionary/English Dictionary search tool is explained. 1. Overview of Naver Korean Dictionary/English Dictionary Search Tool 1.1. Necessity Have you ever searched Naver Korean and English dictionaries and copied and pasted the search results manually into Excel? If you only have a few words (or terms) to search for, you can do it manually. But that...

black and white ceramic tea cup with saucer on black wooden table

Work distribution optimization tool using one-dimensional bin packing algorithm Full Contents, Download

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....

One-dimensional Bin Packing Tool Recent Changes (as of March 21, 2021)

1. The description of the one-dimensional bin packing tool written on the summary of changes blog is based on 2017-11-19. Related article: Work distribution optimization using one-dimensional bin packing algorithm_1. Overview – Productivity Skill (prodskill.com) There are improvements while carrying out the K company project on 2021-03-21, so they are organized separately. Item Size from Integer (Long) to Real (Double)...

Optimization of work distribution using one-dimensional bin packing algorithm_4.Attachment

The source code of this article is based on the first version of the Bin Packing tool. Please refer to the latest version with improved functions. 1D Bin Packing Tool Recent Changes (as of 2021-03-21) 5. Attachment 5.1. Excel VBA-based tool source code Bin implemented with Excel VBA...

Optimization of work distribution using one-dimensional bin packing algorithm_3.Implementation (2)

3.2. Using the Python Bin Packing Package 3.2.1. Introduction and Installation of Python Bin Packing Package The Bin Packing package that can be used in Python is provided at https://pypi.python.org/pypi/bin-packing-problem/1.0.0 on the Pypi (Python Package Index) web page. A brief description of the Bin Packing package and example source code can be found at this URL,...

Optimization of work distribution using one-dimensional bin packing algorithm_3.Implementation (1)

3. Bin Packing Algorithm Implementation A development environment is required to enter the list of items and constraints, implement the algorithm, and check the result. There are various development environments such as Excel VBA, Python, and R. Among them, Excel VBA does not have an open library, so most of the source code must be written by hand. Python and...

en_USEnglish