Study Note
-
Tableau Practice 1
This week, I attended Tableau classes. Instead of listing out the detailed tool content and information one by one, I decided to upload the final practice work that I completed. Through this course, I created a dashboard. There are still many areas that need improvement, and I would like to upload various features to my blog. However, unlike Python code, there are limitations to how Tableau c..
2024.07.04
-
Machine Learning [Regression] practice
Machine Learning [Regression] practice Question 1.from sklearn.datasets import load_irisimport pandas as pdiris = load_iris()df = pd.DataFrame(iris.data, columns=iris.feature_names)df['target'] = iris.targetdf['target_name'] = iris.target_names[iris.target]#X standardscalefrom sklearn.preprocessing import StandardScalerscaler = StandardScaler()X, y = iris.data, iris.target#X 값 표준화X_sc = scaler.f..
2024.06.13
-
Machine Learning [scikit-learn] practice
#Validate the modelmean_squared_error(y_true_tip, y_pred_tip)#result1.036019442011377r2_score(y_true_tip, y_pred_tip)#result0.45661658635167657Machine Learning#import librariesimport sklearnimport numpy as npimport pandas as pdimport matplotlib.pyplot as pltimport seaborn as sns sklearn.linear_model.LinearRegression:- coef_- intecept : Bias- fit : training data- predict weights = [87, 81, 82, 9..
2024.06.04
-
pygwalker
"Pygwalker" is a recently made statistical library. Through this, it is possible to create various statistical graphs more easily and simply. However, it is not usable when the amount of data is very large. https://colab.research.google.com/drive/171QUQeq-uTLgSj1u-P9DQig7Md1kpXQ2?usp=sharing PyGWalker TestColaboratory notebookcolab.research.google.com import pygwalker as pygwalker = pyg.walk(df)
2024.05.30
Cover ex
-
Amazon Data Analysis for Sales Growth [Final project]
Amazon Data Analysis for Sales Growth The objective of this project is to analyze Amazon's sales, customer, and product data to gain insights into the current state through visualization and identify opportunities for revenue improvement. By examining Amazon's sales trends, customer behavior, and product performance, the aim is to develop effective business strategies. The expected outcomes incl..
2024.07.12
-
WIL : Weekly I Learned 05.0.24
WIL : Weekly I Learned 05.07.24 FactThis week was the project period. During this time, my team members and I focused on selecting a topic, preprocessing data, analyzing the data, and creating a dashboard. The dashboard was made using Tableau. For this project, I wanted to dedicate a lot of time to learning Tableau. Using Tableau was enjoyable. However, the downside is that Tableau is a paid so..
2024.07.08
-
Tableau Practice 1
This week, I attended Tableau classes. Instead of listing out the detailed tool content and information one by one, I decided to upload the final practice work that I completed. Through this course, I created a dashboard. There are still many areas that need improvement, and I would like to upload various features to my blog. However, unlike Python code, there are limitations to how Tableau c..
2024.07.04
-
WIL : Weekly I Learned 28.06.24
WIL : Weekly I Learned 28.06.24 FactThis week, I worked on the project and learned Tableau. I successfully analyzed the NASA turbo engine RUL prediction system for the project. Tableau's tools were not as difficult as I thought, and I am enjoying learning it. Unlike Python, various tasks are accomplished without code. However, setting calculated fields requires some formulas. I want to learn as ..
2024.07.04
-
Group sold products by the date - SQL
I encountered an issue while solving the LeetCode question "Group sold products by date. Question더보기Table Activities:+-------------+---------+| Column Name | Type |+-------------+---------+| sell_date | date || product | varchar |+-------------+---------+There is no primary key (column with unique values) for this table. It may contain duplicates.Each row of this table contains the p..
2024.06.27