본문 바로가기

Category91

Join, Merge, Concat, Append, and Pivot table 1. Using the join MethodThe join method in pandas is used to combine two dataframes based on their index. Here is the syntax: DataFrame.join(other, on=None, how='left', lsuffix='', rsuffix='', sort=False) other: The dataframe to join with.on: Column or index level names to join on. Default is the index.how: Type of join to perform ('left', 'right', 'outer', 'inner'). Default is 'left'.lsuffix: S.. 2024. 5. 23.
The difference between deep learning and machine learning The difference between deep learning and machine learning Artificial Intelligence: Human capabilities and functions -> ComputerMachine Learning: Learns patterns, rules, and characteristics on its own using large amounts of data. (Data-dependent - if the data is wrong, it will fail) / Advantage: Just provide the data [because it learns by itself] -> Data must be very well refined.Deep Learning: D.. 2024. 5. 21.
Project - Bank Service Status Analysis and Improvement Project for Bank Service Status I have started a new project. Our team consists of four members, and we have decided to work together on this project. I have taken on the role of the team leader. Our team plans to analyze the "Analysis and Improvement Project for Bank Service Status." We downloaded the data from Kaggle. https://www.kaggle.com/datasets/khanmdsaifullahanja.. 2024. 5. 20.
With CTE I've been solving CodeKata questions and have already completed up to question number 76. While solving these questions, I wanted to practice using WITH CTE. Mastering WITH CTE seems like it will allow me to simplify complex code in various ways.  What is a CTE?A CTE (Common Table Expression) is a temporary result set defined within the execution scope of a single SQL statement. It improves the.. 2024. 5. 20.
WIL : Weekly I Learned 17.05.2024 WIL : Weekly I Learned 17.05.2024 FactsThis week, we learned about data preprocessing and visualization techniques. Starting today, we will embark on a new project. The chosen topic is service analysis using bank customer data.- Project Name: Bank Service Status Analysis and Improvement Project- Project Objective: The goal of this project is to understand the current state and issues of bank ser.. 2024. 5. 17.
Seaborn plot (Scatter, Hist, and Box) Today, I plan to practice again by using Seaborn to recreate the plots I made last time.  Seaborn is a Python package for data visualization, built on top of Matplotlib. It provides a high-level interface for creating attractive and informative statistical graphics.Seaborn is used to visualize statistical data, particularly to explore relationships between variables. It offers a wide range of pl.. 2024. 5. 16.