ShawnIncrease productivity by Using ChatGPT with Microsoft Excel.ChatGPT is a powerful language model developed by OpenAI that can be used for a variety of tasks, including data analysis and automation.Mar 22, 20231Mar 22, 20231
ShawnDimensionality reduction in python: t-SNE,Remove features with missing values or little varianceDec 7, 20221Dec 7, 20221
ShawnThe only article you need to understand Linear Classifier:SVMThis article I will try to introduce SVM in easy way.Nov 24, 2022Nov 24, 2022
ShawnNested query in SQLIf you haven’t read my previous article, please click below, that definitely will be helpful :) !Nov 11, 2022Nov 11, 2022
ShawnCharacter data types and common issues in SQLIf you haven’t read my previous article, please click below, that definitely will be helpful :) !Nov 10, 2022Nov 10, 2022
ShawnNumeric Data Types and Summary Functions in SQLLet’s first take a look at what kind of Numeric data type in SQL:Nov 9, 2022Nov 9, 2022
ShawnExploratory Data Analysis in SQLBefore we start, if you haven’t read my previous article for SQL, it would be helpful if you read it first.Nov 9, 20222Nov 9, 20222
ShawnFunctions for manipulating data in POSTGRESQLPostgreSQL is an object-relational database management system (ORDBMS), It supports most of the SQL standard and provides many other modern…Nov 2, 20221Nov 2, 20221
ShawnWindow function in SQLIn day-to-day work, it is common to encounter the need to rank within each group, this is when we need to use window functionOct 25, 20221Oct 25, 20221
ShawnUNSUPERVISED LEARNING IN PYTHON: Hierarchical clustering / t-SNEHierarchical clustering(also called hierarchical cluster analysis or HCA) is a method of cluster analysis which seeks to build a hierarchy…Aug 31, 2022Aug 31, 2022