본문 바로가기

Category87

Union & Union All UNION: The `UNION` operator in SQL is used to combine the results of two or more SELECT statements into a single result set. It removes duplicate rows from the result set, so each row appears only once.UNION ALL: On the other hand, the `UNION ALL` operator also combines the results of two or more SELECT statements into a single result set, but it includes all rows from all SELECT statements, inc.. 2024. 5. 1.
Taitanic data analysis Today, I had a personal assignment. It involved coding questions related to passengers using Titanic data.The data was from kaggle. https://www.kaggle.com/competitions/titanic/data?select=train.csv Titanic - Machine Learning from Disaster | Kaggle www.kaggle.com    Data file  I wrote Python code based on this data. It's still quite lacking, and the way I approach coding is very inefficient and c.. 2024. 4. 30.
Mece logic tree MECE(Logical) stands for 'Mutually Exclusive, Collectively Exhaustive,' representing a principle of clear and systematic categorization in problem-solving and analysis. It is a guiding principle widely applied in various fields, particularly in management consulting and data analysis.MECE Logit Tree is a methodology used in predictive or classification modeling, where data is analyzed and specif.. 2024. 4. 29.
WIL : Weekly I Learned 26.04.2024 WIL : Weekly I Learned 26.04.2024  FactsDuring this past week, I learned a lot. I created various queries based on real data used in work in SQL. I created various SQL queries based on game data used in the field provided by tutors.  Also, as I dived into the main course of Python class, I learned about various Python tools. I not only learned basic functions but also functions for creating gra.. 2024. 4. 26.
Python Data Types Python Data Types While I was studying Python, I realized that there are lots of different data types in Python.    Numerical data types are used to represent numbers. They primarily consist of integers and floating-point numbers, used for calculations and numerical operations.  In Python, two main types of numerical data are commonly used:1. Integer:   - Integers represent whole numbers without.. 2024. 4. 25.
AARRR Funnel Analysis AARRR is a model used in digital marketing and product management to analyze and optimize the customer lifecycle.  The AARRR model, shaped like a funnel narrowing downwards, aims to reduce customer running out rates as you move down the funnel.      AARRR stands for:Acquisition: This stage focuses on acquiring new users or customers. It involves activities such as driving traffic.. 2024. 4. 24.

티스토리툴바