Solving Python Data Analysis Interview Questions - Microsoft
In this series, I will be solving python data analysis interview questions in Stratascratch. In this particular video, I'm solving Google's interview question.
If you have any questions or feedback regarding this content, please let me know in the comments or you can contact me directly via email: [email protected]
My solution to the mentioned question is:
Premium vs Freemium:
df = ms_download_facts.merge(ms_user_dimension, on = 'user_id', how = 'left').merge(ms_acc_dimension, on = 'acc_id', how = 'left')[['date', 'downloads', 'paying_customer']]
df = df.sort_values('date')
df = df.groupby(['date','paying_customer'], as_index = False)['downloads'].sum()
paying = df[df['paying_customer'] == 'yes']
non_paying = df[df['paying_customer'] == 'no']
df = paying.merge(non_paying, on = 'date', suffixes = ['_p', '_n'])[['date', 'downloads_p', 'downloads_n']]
df = df[df['downloads_n'] (more than) df['downloads_p']]
Try out Stratascratch: https://stratascratch.com/?via=marius
Watch video Solving Python Data Analysis Interview Questions - Microsoft online without registration, duration hours minute second in high quality. This video was added by user MaKuData 21 November 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 248 once and liked it 10 people.