注册一亩三分地论坛,查看更多干货!
您需要 登录 才可以下载或查看附件。没有帐号?注册账号 
x
真的想说,不容易!
之前只有staffing company 来找我,慢慢的有fulltime position了,然后阴差阳错有个学长内推了我,然后简历竟然过了,填了一堆基本信息之后竟然到了笔试环节了!!!
对于我这种**来说真的太不容易了,努力还是有收获的!!!.google и
还没定日期,今天才收到的
发个他们给我发的mock interview 题把,等面试之后会在更新或者开帖
在发点邮件里说的考察的技术细节给大家参考!
. 1point 3acres
希望能过!
Mock Data and Questions:. 1point 3 acres
This example doesn't pertain to Facebook but is representative of the data and questions you may see:
An attendance log for every student in a school district. check 1point3acres for more.
attendance_events : date | student_id | attendance
A summary table with demographics for each student in the district.--
all_students : student_id | school_id | grade_level | date_of_birth | hometown
Using this data, you could answer questions like the following: - What percent of students attend school on their birthday?
- Which grade level had the largest drop in attendance between yesterday and today?. check 1point3acres for more.
Core skills
Regardless of your language, you should be familiar with ALL of the following skills
- Work with grouping and aggregate functions
- Utilize different types of joins (left, inner, outer, etc.) including when and how to use a self-join
- Append multiple data sources (union in SQL, concat in Pandas, bind_rows in R)
- Filter data by multiple, complex conditions
- De-duplication, sorting, handling missing/incomplete data
- Assess efficiency. This will not be a primary focus, but you may be asked to think of more efficient ideas or to explain why you are making certain efficiency/simplicity tradeoffs
[size=14.6667px]
. ----
最后的最后!!!!求!!!积!!分!!!!。。。。
有的东西要180+ 积分根本看不。。心痛
|