Junior аналитик данных | Собеседование | karpov.courses

Analyst Simulator: https://bit.ly/3S0YWLu Open interviews for Junior Analyst positions continue! This time, live, we'll be coding in Python, analyzing data in Pandas, and calculating product metrics in ClickHouse. Learn Data Science with us: https://karpov.courses/ Chat link: https://t.me/karpovcourseschat 00:00 Introduction and presentation 5:19 Interview structure 6:04 First task: rotate a list 9:29 Calculate a data frame 12:08 Unique sections 12:52 Top 10 users by music listening 19:54 The most popular section for those who don't check the feed 29:05 Who has been using the product the longest 37:45 The best graph for data 39:06 Feedback and transition to the second user 41:54 Data description 42:55 Number of events by day 45:10 Views and likes by day 51:48 Life hack 53:28 Adding a new column 54:30 Filtering unique posts 56:49 Median active number days 1:03:32 The only active day is September 1 1:12:29 Feedback