Category87 Delete Duplicate Emails [SQL] This time, I encountered an SQL question that is supposed to be easy, but it wasn't as easy as expected. It was a problem about deleting duplicate emails. I tried to solve it using SELECT and GROUP BY, but it didn't work. Question더보기Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| id | int || email | varchar |+-------------+---------+id.. 2024. 6. 25. WIL : Weekly I Learned 21.06.24 WIL : Weekly I Learned 21.06.24 FactThis week was the project period. Our team worked on a project to analyze the failure point of NASA's turbo engine and predict the Remaining Useful Life (RUL). Through this project, I had the opportunity to practice more with machine learning and deep learning. FindingThe preparation process for machine learning and deep learning was complex. Simply inputting .. 2024. 6. 24. WIL : Weekly I Learned 14.06.24 WIL : Weekly I Learned 14.06.24 FactFrom last week to this week, I learned about machine learning and deep learning. I now have a rough idea of how to use machine learning. It seems unlikely that I will actually use deep learning in my work. Machine learning could potentially be used to estimate important indicators such as the company's financial situation, cash flow, and expenses, but there is.. 2024. 6. 14. 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. 6. 13. Movie rating - SQL Question Movie Rating.Table: Movies+---------------+---------+| Column Name | Type |+---------------+---------+| movie_id | int || title | varchar |+---------------+---------+movie_id is the primary key (column with unique values) for this table.title is the name of the movie. Table: Users+---------------+---------+| Column Name | Type |+---------------+---------+| use.. 2024. 6. 12. WIL : Weekly I Learned 07.06.24 WIL : Weekly I Learned 07.06.24 Fact This week felt short. There was a holiday, and I learned about machine learning and deep learning, but it felt quite difficult. I felt that deep learning might not be closely related to accounting data analysis, which I am interested in. Machine learning involves making predictions through regression analysis, and it might be possible to measure predictions .. 2024. 6. 11. 이전 1 2 3 4 5 ··· 15 다음 more
