方块PA职位 面经

Interviewed for Square‘s Product Analyst position back in May.

Interview process rounds: HR --> HM --> Live coding phone interview --> Virtual Onsite

HR and HM are just standard chatting about experience, interest, and fit.

Live coding phone interview:

First, was SQL then Python. In total about 75 minutes. Uses coderpad. 30 minutes for SQL then 45 minutes for python. Both are not too difficult in my opinion.

SQL is split into 5 different problems. Tests various standard/common usages like JOINs,

您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式

游客，您好！
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限 或 查看其他获取积分的方式
Unlock interview details and practice with AI
Curated Interview Questions from Top Companies

or not.

Python is focused on data manipulation and visualization. Provided csv file(s), and asked to create various charts, clean ups and some simply math like sum or medium.

Hope this helps everyone else who is looking to interview with Square for PA! 大家加油！！

请问一下，visualization也是要求python做么？大概需要做哪些类型图表？technical考察方式，是有具体的问题，然后要求面试者去回答，还是就是根据数据自己发散，寻找insights?另外楼主有被考建模类问题么？

Visualization 要，他们会给你csv data, 就一般的time series, line graph, bar graph 等等。一个面试考察具体问题，另一个会要你自己找insight, data 不同。Machine Learning 稍微考了一点但不是主题。

请问onsite的python更多的是考察data wrangling还是visualizatuon还是insight呢？

data wrangling需要哪些操作呢（是groupby再agg这类吗）？这轮python只准备pandas足够吗？感谢

bartowski13 发表于 2020-12-2 03:16
请问onsite的python更多的是考察data wrangling还是visualizatuon还是insight呢？

data wrangling需要哪些 ...

你好请问你面完onsite了吗 可以请教一下面经吗 非常感谢！