jaman 님의 블로그

질문 'product_raw 데이터가 있고 x축은 cloth y축은 season으로 그래프 만들고 싶으면 어떻게 해?' 1. 막대 그래프import seaborn as snsimport matplotlib.pyplot as plt# cloth별 season의 빈도수를 계산season_counts = product_raw.groupby(['cloth', 'season']).size().reset_index(name='counts')# 막대 그래프 그리기sns.barplot(data=season_counts, x='cloth', y='counts', hue='season')plt.xticks(rotation=45)plt.show()  2. 히트맵# cloth와 season 빈도수를 교차 테이블로 변환heat..

Sales Funnel Data 1. Online Advertising Digital Marketing Erahttps://www.kaggle.com/datasets/naniruddhan/online-advertising-digital-marketing-data?select=online_advertising_performance_data.csv Online Advertising Digital Marketing dataAnalyze the performance of the online digital marketing data, get key insights!www.kaggle.com month, day, user engagement, banner, placement, displays, cost, click..

주어진 데이터들에 대한 설명:https://www.kaggle.com/datasets/sohyunjun0401/game-rawdata-240705account_idlzp4q7rw-z30g-8jpz-v50m-12poovfh29b5ip_addr70.30.233.132countryCNlatitude35.86166longitude104.1954age34genderMALEosiOSfirst_login_date2020-12-16last_login_date2024-12-16level88exp(획득 경험치 총량(레벨과비례아님))999972serverno16job전사action_type(주요 활동)PVEmarketing_info_yn(마케팅 정보제공 활용동의 여부)Ypay_amont(누적 결제금액)99997151refu..

IF [Guild Member Cnt] game_df = pd.read_csv('/Users/t2024-m0188/Desktop/GameProject/game_rawdata.csv', header=1)game_df.head()데이터 불러오기  print(game_df['first_login_date'].value_counts())first_login_date 컬럼에 어떤 value들이 있는지 보기(잘 까먹는 코드)  #각 나라별 first/lastlogin의 mincountry_login_min = game_df.groupby('country').agg( firstlogin=('first_login_date', 'min'), lastlogin=('last_login_date', 'min'..