Advertisement
Guest User

Untitled

a guest
May 22nd, 2019
194
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.95 KB | None | 0 0
  1. import pandas as pd
  2. df = pd.read_csv('music_log_upd.csv')
  3.  
  4. genre_grouping = df.groupby('user_id')['genre_name']
  5.  
  6. def user_genres(group):
  7. for col in group:
  8. if len(col[1]) > 50:
  9. user = col[0]
  10. return user
  11.  
  12. search_id = user_genres(genre_grouping)
  13.  
  14. music_user = df[(df['user_id']== search_id) & df['total_play_seconds'] != 0]
  15.  
  16. sum_music_user = music_user.groupby('genre_name').sum()['total_play_seconds']
  17. #print(sum_music_user)
  18.  
  19.  
  20.  
  21. #count_music_user = music_user.groupby('genre_name').nunique()['track_name']
  22. #count_music_user = music_user.groupby('genre_name').count()['track_name']
  23. #count_music_user = music_user.groupby('genre_name').count().reset_index()
  24. #count_music_user = music_user.groupby('genre_name').count().reset_index()['genre_name']
  25. #count_music_user = music_user.groupby('genre_name').count()
  26. #count_music_user = music_user.groupby('genre_name').count().reset_index()['genre_name'].count()
  27.  
  28. print(count_music_user)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement