Lemmatization is the process of converting a word to its base form. Lemmatization considers the context and converts the word to its meaningful base form, whereas stemming just removes the last few characters, often leading to incorrect meanings and spelling errors. In contrast to stemming, lemmatization is a lot more…

In this study, we will work on a real estate data . Click here for data sets. We have a data set with 56000 rows of information about the properties of a big real estate company. Our aim in this data set; To separate address information by street and district Populate…

In this article you will find 92 SQL exercises. The necessary data sets are available on the page as a drive link below. Click here for data sets. This work includes following commands; · SELECT · WHERE · UPPER · CHARINDEX · RIGHT TRIM, LEFT TRIM · REPLACE ·…

What is data definition language (DDL) ? A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc. This term is also known as data description language in some contexts, as it describes the fields and…

Git was created by Linus Torvalds in 2005 for development of the Linux Kernel with th other kernel developers contributing to its initial development. Since 2005, Junio Hamano has been the core maintainer. As with most other distributed version control systems, and unlike most client–server systems, every Git directory on…

ONE HOT ENCODING (Including Dummy Variable Trap) and ORDINAL ENCODING WHAT ARE CATEGORICAL VARIABLES? Categorical variables are qualitative data in which the values are assigned to a set of distinct groups or categories. These groups may consist of alphabetic (e.g., male, female) or numeric labels (e.g., male = 0, female = 1) that do not contain mathematical information beyond the…