Spotify数据相关面经_Spotify数据相关面试真题及高频题

1.完整面试轮次题目

2.Can you tell me an algorithm behind the product?

3.How do you run the t-test?

4.How do you calculate significance from the data given? (t-test)

5.what's the difference between union and outer join?

6.what's the difference between inner join and full outer join?

7.what's the advantage of the random forest model?

8.what's the confidence interval?

9.what's the difference between set and list? (python)

10.怎么evaluate modle好坏。

11.Pandas groupby

12.用户数据分析

13.合作BQ

14.average stream time

15.新建列

16.常见问题

17.Streams data and follow ups

18.desktop total stream

19.stream data

20.p value解释

21.Pandas

22.plot insight

23.解释metric

24.基础问题

25.Evaluate ranking feature

26.DS项目介绍

27.Targeting users for new artists

28.Rank artists based on their streams

29.Loop Integers

1. 完整面试轮次题目

AB bucket: user_id, ab_bucket, first_exposure_day

Streams: user_id, date, playlist, track_id, timestamp, ms_played,stream_id metadata:track_id,artist_name（歌手），track_name(歌名)

1.Construct a SQL querythat will createa rankedlist of artistsbased on theirtotal number of streams on Spotifyusing the following two tables:

2.calculate avg streaming time forboth groups? follow up with a/b test: trade-off

3.python coding: generate all prime numbers smaller than a given number-leetcode

4. Probability: Coin flip -You need to make a choice between three different options.You want the choice to be made randomly and, to help you, you have a two sided coin.How do you pick the option?

2. Can you tell me an algorithm behind the product?

Can you tell me an algorithm behind the product?

3. How do you run the t-test?

How do you run the t-test?

4. How do you calculate significance from the data given? (t-test)

How do you calculate significance from the data given? (t-test)

5. what's the difference between union and outer join?

what's the difference between union and outer join?