<
回复: 2
收起左侧

doordash fraud takehome

匿名用户-J5DSF  2023-4-20 00:10:31
本楼:   👍  1
100%
0%
0   👎

2023(1-3月) 分析|数据科学类 本科 全职@doordash - 网上海投 - 其他  | 🙁 Negative 😐 AverageFail | 在职跳槽

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

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

x
本帖最后由 匿名 于 2023-4-19 09:21 编辑

You are given a month's worth of  delivery data for DoorDash. This isn't the complete set, but it's comprehensive enough where you should be able to draw conclusions on fraudulent transactions. Feel free to make any assumptions you need. Your job is to give me a specific set of recommendations on how to reduce our fraud losses based on this data. Please send me your recommendations and any supporting analyses and assumptions.

Below is a glossary of definitions for the variables included in the data set:Field        Definition
DELIVERY_ID        ID of Order
CREATED_AT        Timestamp for order creation
CONSUMER_ID        ID of consumer account
GOV        Gross Order Value, in cents. This includes the subtotal of all items, all fees, taxes, and tip
CX_AGE_ON_DELIVERY_BASED_ON_FIRST_ORDER        Age of consumer in days when the consumer when delivery was created, calculated from the day of the first order created by the consumer
PLATFORM        Platform of device used upon checkout
RECEIVED_CHARGEBACK        Whether or not this delivery has a chargeback associated with it
IS_FRAUDULENT_CHARGEBACK        Whether or not the chargeback received was related to fraud reasons. This is true when the dispute reason is in ('fraudulent', 'unrecognized', 'general'), based on the information submitted to the card issuer by the card owner
CHARGEBACK_COST        Chargeback cost in cents is the total potential cost of chargebacks to us. Each chargeback cost is compromised of the original chargeback amount (usually entire transaction amount) + a flat chargeback processing fee that is paid to our payment processor. If we 'win' the chargeback, this value goes to 0.
CX_DEVICE_ORDER_NUM        The order number placed by this device + consumer
CX_ADDRESS_ORDER_NUM        The order number placed to this address by this consumer. 1point3acres
CX_CARD_ORDER_NUM        The order number placed using this card fingerprint by this consumer.--
CX_ORDER_NUM        The order number placed by this consumer
CX_UNIQUE_ADDRESSES        Total number of unique addresses this consumer has ever used up to today. 1point 3acres
UNIQUE_ADDRESS_PAST_1DAY        Unique addresses this consumer has placed deliveries to in the 24 hours from this delivery creation datetime
UNIQUE_ADDRESS_PAST_7DAY        Unique addresses this consumer has placed deliveries to in the 24 * 7 hours from this delivery creation datetime
SIFT_CREATE_ORDER_PA_SCORE        Sift score of the event associated with this delivery creation
FAIL_CHARGES_1HR        Failed charge transaction attempts in the past 1 hour from this delivery creation datetime. Waral dи,
FAIL_CHARGES_1D        Failed charge transaction attempts in the past 24 hours from this delivery creation datetime
FAIL_CHARGES_7D        Failed charge transaction attempts in the past 24 * 7 hours from this delivery creation datetime
DEVICE_DELIVERIES        Total number of deliveries placed by this device up to today
DEVICE_PCT_CHARGEBACK        % of DEVICE_DELIVERIES that have received a chargeback
CCR_PAST_DELIVERIES        Total number of deliveries placed by this consumer prior to this delivery
CCR_CHARGEBACK_DELIVERIES        Total number of chargebacks received by this consumer prior to this delivery
CX_PCT_CHARGEBACK        CCR_CHARGEBACK_DELIVERIES / CCR_PAST_DELIVERIES

. 1point3acres.com Sam
您好!
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
使用VIP即刻解锁阅读权限或查看其他获取积分的方式
游客,您好!
本帖隐藏的内容需要积分高于 188 才可浏览
您当前积分为 0。
VIP即刻解锁阅读权限查看其他获取积分的方式
       3        4        2                        47.99543643        0        0        0        4        0.75        3        1        0.333333
137298413        2019-01-21T01:11:55.612066Z        50791623        13926        132        iOS        0        0                6        2        5        6        2                                0        0        0        6        0        5        0        0
131111835        2019-01-07T17:11:32.993062Z        70624886        12110        0        iOS        1        1        12860        2        2        2        2        1                        75.88508772        4        4        4        2        0.5        1        0        0. 1point 3acres
140922768        2019-01-28T17:01:43.02419Z        42558322        3557        162        iOS        0        0                26        10        12        26        19        0        2        14.50765841        0        0        0        75        0        25        0        0

评分

参与人数 1大米 +2 收起 理由
光影流转 + 2 给你点个赞!

查看全部评分


上一篇:BARD and CHATGPT solving DS brainteaser
下一篇:求问最近pintereste ds on-site 面试
wintergo 2023-5-2 04:50:50 来自APP | 显示全部楼层
本楼:   👍  0
0%
0%
0   👎
全局:   15
94%
6%
1
攒着看,感谢楼主分享!
回复

使用道具 举报

秋风扫落叶 2023-5-2 11:25:15 | 显示全部楼层
本楼:   👍  0
0%
0%
0   👎
全局:   135
99%
1%
1
请问楼主这是take home quiz还是sql题目呢
回复

使用道具 举报

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

本版积分规则

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