📣 黑五价提前开抢|VIP一年通行证5折,蓝莓、Offer多多同步特惠
查看: 2129| 回复: 6
跳转到指定楼层
上一主题 下一主题
收起左侧

data scientist 求职刷题记录

全局:

注册一亩三分地论坛,查看更多干货!

您需要 登录 才可以下载或查看附件。没有帐号?注册账号

x

在这里记录我准备ds面试的python和SQL题目,因为这方面因公司而异,比较难系统的准备,有同样求职的小伙伴欢迎一起!另外,求大米求大米,想多看看面经求求了1. Simulate a biased coin with P(H) = p
def biased_coin(p):
  return 1 if random.random() < p else 0
print(sum(biased_coin(0.2) for i in range(100000)) / 100000)
# Simulate a fair coin
# Toss a coin twice.
# If you get HT call it Heads..google  и
# If you get TH call it Tails.
# If you get HH or TT ignore and repeat your coin toss.
def fair_coin(p):
  while True:
    first_toss = biased_coin(p)
    second_toss = biased_coin(p)
    if first_toss == second_toss:
      continue
    elif first_toss == 1 and second_toss == 0:
      return 1
    else:
      return 0
print(sum([fair_coin(0.2) for _ in range(100000)]) / 100000)

上一篇:换工作or not
下一篇:现在找data science实习很难吗
推荐
lewesyru93 2024-3-1 05:42:03 | 只看该作者
全局:
本帖最后由 lewesyru93 于 2024-2-29 16:45 编辑
AndersonNAGT 发表于 2024-2-24 17:40
.google  и3. Facebook经典题 leetcode 602 Friend Requests II: Who Has the Most Friends
WITH request AS (. 1point 3acres
   S ...

602 我是用了dense_rank和union all,貌似高赞答案也是这么写,你可以试试。不过题目的test case并没有并列第一的情况,所以dense_rank有点多余其实。很多答案都是limit 1
回复

使用道具 举报

全局:
感谢分享。 好运+加油!
回复

使用道具 举报

推荐
Frankford 2024-2-25 07:11:09 | 只看该作者
全局:
楼主,你这是python 刷题了。
我也不知道力扣有无python 针对DS 的题目,好像有SQL 的。
回复

使用道具 举报

🔗
 楼主| AndersonNAGT 2024-2-25 06:37:12 | 只看该作者
全局:
sry前段时间面试太忙 分享一道经典的sql题
2. leetcode 1280. Students and Examinations
  1. SELECT s.student_id, s.student_name, sub.subject_name, CASE WHEN e.subject_name IS NULL THEN 0 ELSE COUNT(e.subject_name) END AS attended_exams
  2. FROM students s
  3. CROSS JOIN subjects sub
  4. LEFT JOIN Examinations e
  5. ON s.student_id = e.student_id AND sub.subject_name = e.subject_name
  6. GROUP BY student_id, sub.subject_name
  7. ORDER BY student_id, subject_name
复制代码
回复

使用道具 举报

🔗
 楼主| AndersonNAGT 2024-2-25 06:40:04 | 只看该作者
全局:
3. Facebook经典题 leetcode 602 Friend Requests II: Who Has the Most Friends
WITH request AS (
   SELECT requester_id AS id, COUNT(*) AS count_request
   FROM RequestAccepted
   GROUP BY requester_id
),
accept AS (
   SELECT accepter_id AS id, COUNT(*) AS count_accept
   FROM RequestAccepted
   GROUP BY accepter_id
)-baidu 1point3acres
SELECT
   id,
   COALESCE(SUM(count_request), 0) + COALESCE(SUM(count_accept), 0) AS num.1point3acres
   FROM (
       SELECT id, count_request, NULL AS count_accept FROM request
. 1point3acres       UNION ALL
       SELECT id, NULL AS count_request, count_accept FROM accept
   ) combined
   GROUP BY id
   ORDER BY num DESC. 1point3acres.com
   LIMIT 1
回复

使用道具 举报

🔗
 楼主| AndersonNAGT 2024-3-14 16:20:35 | 只看该作者
全局:
leetcode 1212. 很有意思的题 想问问大家有没有不一样的解法
# Write your MySQL query statement below
WITH temp AS (.
    SELECT *,
    CASE
        WHEN host_goals > guest_goals THEN 3
        WHEN host_goals = guest_goals THEN 1. 1point3acres
        ELSE 0
    END AS host_score,
    CASE
        WHEN guest_goals > host_goals THEN 3
        WHEN guest_goals = host_goals THEN 1
        ELSE 0
    END AS guest_score
    FROM Matches
)
SELECT team_id, team_name, . Waral dи,
COALESCE((SELECT SUM(host_score) FROM temp WHERE host_team = team_id),0) + COALESCE((SELECT SUM(guest_score) FROM temp WHERE guest_team = team_id),0) AS num_points. Χ
FROM Teams
ORDER BY num_points DESC, team_id ASC
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册账号
隐私提醒:
  • ☑ 禁止发布广告,拉群,贴个人联系方式:找人请去🔗同学同事飞友,拉群请去🔗拉群结伴,广告请去🔗跳蚤市场,和 🔗租房广告|找室友
  • ☑ 论坛内容在发帖 30 分钟内可以编辑,过后则不能删帖。为防止被骚扰甚至人肉,不要公开留微信等联系方式,如有需求请以论坛私信方式发送。
  • ☑ 干货版块可免费使用 🔗超级匿名:面经(美国面经、中国面经、数科面经、PM面经),抖包袱(美国、中国)和录取汇报、定位选校版
  • ☑ 查阅全站 🔗各种匿名方法

本版积分规则

>
快速回复 返回顶部 返回列表