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: makunadata@gmail.com
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
En esta página del sitio puede ver el video en línea Solving Python Data Analysis Interview Questions - Microsoft de Duración hora minuto segunda en buena calidad , que subió el usuario MaKuData 21 noviembre 2023, comparta el enlace con amigos y conocidos, en youtube este video ya ha sido visto 306 veces y le gustó 11 a los espectadores. Disfruta viendo!
