목록DAU (2)

세조목

심화 프로젝트 4~5일차(DAU, WAU, MAU구하기)(24.02.09~10)

DAU # data type을 날짜로 변환 train_df2['date'] = train_df2['date'].apply(lambda x: pd.to_datetime(str(x), format = '%Y%m%d')) # DAU 라인 차트로 표시 a = train_df2.groupby(['date'], as_index=False).agg({'fullVisitorId' : pd.Series.nunique}) sns.lineplot(data = a, x = 'date', y = 'fullVisitorId') WAU train_df2['date_week'] = train_df2['date'].dt.isocalendar().week WAU = train_df2.groupby(['date_week'], as_ind..
데이터 분석 공부/프로젝트 2024. 2. 11. 21:58
TIL(Today I Learned)62일차(24.02.09)

SQL, PYTHON 예제 1. SQL https://leetcode.com/problems/immediate-food-delivery-ii/description/ WITH FIRST AS ( SELECT DELIVERY_ID, CUSTOMER_ID, ORDER_DATE, CUSTOMER_PREF_DELIVERY_DATE, RANK() OVER(PARTITION BY CUSTOMER_ID ORDER BY ORDER_DATE) RANKING FROM DELIVERY ), SECOND AS ( SELECT DELIVERY_ID, CUSTOMER_ID, ORDER_DATE, CUSTOMER_PREF_DELIVERY_DATE FROM FIRST WHERE RANKING = 1 ), THIRD AS ( SELEC..
데이터 분석 공부/TIL(Today I Learned) 2024. 2. 9. 23:04
이전 Prev 1 Next 다음