Advertisement
Guest User

Untitled

a guest
Nov 19th, 2019
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.92 KB | None | 0 0
  1. import pandas as pd
  2. df = pd.read_csv('music_log.csv')
  3.  
  4. rock = df[df['genre'] == 'rock']
  5. rock_time = rock['total play']
  6. rock_haters = rock_time.loc[rock_time <= 5].count()
  7. pop = df[df['genre'] == 'pop']
  8. #print('Количество пропущенных треков жанра рок равно', rock_haters)
  9. pop_time = pop['total play']
  10. pop_haters = pop_time.loc[pop_time <= 5].count()
  11. #print('Количество пропущенных треков жанра рок равно', rock_haters)
  12. total_play = df.shape[0]
  13. rock_skip = rock_time / total_play
  14. print('Доля пропущенных композиций жанра рок равно: {:.1%}'.format(rock_skip))
  15. pop_skip = pop_time / total_play
  16. print('Доля пропущенных композиций жанра поп равно: {:.1%}'.format(pop_skip))
  17. #print('Количество пропущенных треков жанра поп равно', pop_haters)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement