여연찌

Today1. SQL 코드카타(85번)2. 파이썬 300제(121~125)3. 파이썬 개인과제 제출4. 파이썬 심화함수 강의 복습 Today I Learned SQL 같은 테이블에서의 JOIN이 필요했던 문제https://lyj-01.tistory.com/129 197. Rising TemperatureWrite a solution to find all dates' Id with higher temperatures compared to its previous dates (yesterday).Return the result table in any order.The result format is in the following example.SELECT w1.idFROM weather AS w1JOIN wea..

문제 1: 데이터 불러오기 타이타닉 데이터를 불러온 다음 df라는 변수에 담고 데이터의 내용을 확인하세요.from google.colab import drivedrive.mount('/content/drive')root = "/content/drive/MyDrive/스파르타파이썬"file_address = root + "/train.csv"import pandas as pddf = pd.read_csv(file_address)display(df)  문제 2: 생존자 수 계산 타이타닉 전체 생존자 수와 사망자 수를 계산하고 출력하세요.생존자=[]사망자=[]total=df['Survived']for i in df['Survived']: if i == 1: 생존자.appen..

Write a solution to find all dates' Id with higher temperatures compared to its previous dates (yesterday).Return the result table in any order.The result format is in the following example.SELECT w1.idFROM weather AS w1JOIN weather AS w2ON DATEDIFF(w1.recordDate, w2.recordDate) = 1 WHERE w1.temperature > w2.temperature① FROM weather AS w1 JOIN weather AS w2# 1개의 테이블을 JOIN 해준다. ② ON DATEDIFF(w1...