Prepare for and practice interview questions from Wing Aviation.

Wing Aviation Interview Questions

Wing Aviation Interview Guides

Machine Learning

Encoding Categorical Features

Bank Fraud Model

Type-ahead Search

Food Prep Features

How to model merchant acquisition in a new market?

Merchant Acquisition

Write a query to select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Employee Salaries

User Experience Percentage

Distance Traveled

Download Facts

Select a (weight) random driver from the database.

Random Weighted Driver

Statistics

P-value to a Layman

What are the assumptions of linear regression?

Assumptions of Linear Regression

A new airline came out as the fastest average boarding times compared to other airlines.  What factors could have biased this result and what would you look into?

Boarding Times Bias

MLE vs MAP

What is the difference between type I and type II errors?

Type I and II Errors

Probability

Write a function to get a sample from a standard normal distribution.

Normal Distribution Sample

Write code to generate a sample from a multinomial distribution with keys 

Drawing Balls From Bin

Weighted Keys

Simulate rolling a dice from a continuous uniform distribution

Dice Rolls From Continuous Uniform

Write a function to get a sample from a Bernoulli trial.

Bernoulli Sample

Data Structures & Algorithms

Given a list of integers, and an integer N, write a function to find all combinations that sum to the value N.

Sum to N

Justify an array of words given an arbitrary line width.

Max Width

Maximum Profit

Explaining optimizations needed to sort a 100GB file with 10GB RAM

External Sorting

You’re given a list of people to match together in a pool of candidates.

Pool Matching

Given a <code>employees</code> and <code>departments</code> table, select the top 3 departments with at least ten employees and rank them according to the percentage of their employees making over 100K in salary.

Example:

Input:

<code>employees</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>first_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>last_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>salary</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>department_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>departments</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>percentage_over_100k</code></td>
<td>FLOAT</td>
</tr>

<tr>
<td><code>department_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>number_of_employees</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Given a table called <code>user_experiences</code>, write a query to determine the percentage of users that held the title of <code>&#34;Data Analyst&#34;</code> immediately before holding the title <code>&#34;Data Scientist&#34;</code>.

Immediate is defined as the user holding no other titles between the <code>&#34;Data Analyst&#34;</code> and <code>&#34;Data Scientist&#34;</code> roles.

Example:

Input:

<code>user_experiences</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>position_name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>start_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>end_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>percentage</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Given the tables <code>users</code> and <code>rides</code>, write a query to report the distance traveled by each user in descending order.

Example:

Input:

<code>users</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>name</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>rides</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>passenger_user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>distance</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>name</code></td>
<td>VARCHAR</td>
</tr>

<tr>
<td><code>distance_traveled</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Let’s say that your company is running a standard control and variant AB test on a feature to increase conversion rates on the landing page. The PM checks the results and finds a .04 p-value.

How would you assess the validity of the result?

Experiment Validity

A/B Testing

Given two tables: <code>accounts</code>, and <code>downloads</code>, find the average number of downloads for free vs paying accounts, broken down by day.

Note: You only need to consider accounts that have had at least one download before when calculating the average.

Note: round <code>average_downloads</code> to 2 decimal places.

Example:

Input:

<code>accounts</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>account_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>paying_customer</code></td>
<td>BOOLEAN</td>
</tr>
</tbody>
</table>
<code>downloads</code> table

<table>
<thead>
<tr>
<th>column</th>
<th>type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>account_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>download_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>downloads</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>download_date</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>paying_customer</code></td>
<td>BOOLEAN</td>
</tr>

<tr>
<td><code>average_downloads</code></td>
<td>FLOAT</td>
</tr>
</tbody>
</table>

Given a dictionary with weights, write a function <code>random_key</code> that returns a key at random with a probability proportional to the weights.

Example 1:

Input:

<pre tabindex="0" class="chroma"><code>weights = {&#39;A&#39;: 1, &#39;B&#39;: 2}
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>random_key(weights) -&gt; return A 1/3 of the time, B 2/3 of the time
</code></pre>

Example 2:

Input:

<pre tabindex="0" class="chroma"><code>weights = {&#39;A&#39;: 1, &#39;B&#39;: 1}
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>random_key(weights) -&gt; return A 1/2 of the time, B 1/2 of the time
</code></pre>

Write a Python function called <code>max_profit</code> that takes a list of integers, where the i-th integer represents the price of a given stock on day i, and returns the maximum profit you can achieve by buying and selling the stock.

You may complete, at most, two complete buy/sell transactions to maximize profits on a stock.

Input:

<pre tabindex="0" class="chroma"><code>prices = [3, 3, 5, 0, 0, 3, 1, 4]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def max_profit(prices) -&gt; 6
</code></pre>

Explanation:

<pre><code>Buy on day 4 (price = 0) and sell on day 6 (price = 3): profit = 3 - 0 = 3.
Then buy again on day 7 (price = 1) and sell on day 8 (price = 4): profit = 4 - 1 = 3.
Total profit: 3 + 3 = 6.
</code></pre>

Given the <code>transactions</code> table below, write a query that finds the third purchase of every user.

Note: Sort the results by the <code>user_id</code> in ascending order. If a user purchases two products at the same time, the lower <code>id</code> field is used to determine which is the first purchase.

Example:

Input:

<code>transactions</code> table

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Columns</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>user_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>created_at</code></td>
<td>DATETIME</td>
</tr>

<tr>
<td><code>product_id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>quantity</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

Third Purchase

Given a list of <code>integers</code>, and an integer <code>N</code>, write a function <code>sum_to_n</code> to find all combinations that sum to the value <code>N</code>.

Example: 

Input:

<pre tabindex="0" class="chroma"><code>integers = [2,3,5]
N = 8
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def sum_to_n(integers, N) -&gt;
 [
 [2,2,2,2],
 [2,3,3],
 [3,5]
]
</code></pre>

You’re a data scientist working for a smart grocery platform that helps families automatically plan their Christmas dinner based on their dietary preferences and pantry availability.

Each Christmas recipe consists of several ingredients, and each ingredient has different brands with different prices. Families want the cheapest possible ingredient combination but only using brands they have marked as acceptable and only those ingredients they do not already have in their pantry.

Write a SQL query to determine the cheapest valid shopping cost for each recipe for family_id = 1, while also identifying whether the recipe is feasible to make.

For each recipe, compute:

<ol>
<li><code>missing_ingredients</code>: number of ingredients the family does not already have in their pantry</li>
<li><code>min_total_cost</code>: total minimum cost required to buy missing ingredients</li>
<li>feasible:

<ul>
<li><code>&#39;Yes&#39;</code> if every missing ingredient has at least one acceptable brand available</li>
<li><code>&#39;No&#39;</code> otherwise (and <code>min_total_cost</code> should be <code>NULL</code>)</li>
</ul></li>
</ol>

Note: Sort results by <code>missing_ingredients</code> ASC and <code>min_total_cost</code> ASC (NULLS LAST)

Schema

Input

<code>recipes</code> Table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>recipe_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>ingredient_id</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>ingredient_brands</code> Table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>ingredient_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>brand_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>price</td>
<td>DECIMAL</td>
</tr>
</tbody>
</table>
<code>pantry</code> Table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>family_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>ingredient_id</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>acceptable_brands</code> Table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>family_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>brand_id</td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td>recipe_id</td>
<td>INTEGER</td>
</tr>

<tr>
<td>missing_ingredients</td>
<td>INTEGER</td>
</tr>

<tr>
<td>min_total_cost</td>
<td>DECIMAL</td>
</tr>

<tr>
<td>feasible</td>
<td>VARCHAR</td>
</tr>
</tbody>
</table>
Example

Input

<code>recipes</code> Table

<table>
<thead>
<tr>
<th>recipe_id</th>
<th>ingredient_id</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>100</td>
</tr>

<tr>
<td>1</td>
<td>200</td>
</tr>

<tr>
<td>1</td>
<td>300</td>
</tr>

<tr>
<td>2</td>
<td>200</td>
</tr>

<tr>
<td>2</td>
<td>400</td>
</tr>
</tbody>
</table>
<code>pantry</code> Table

<table>
<thead>
<tr>
<th>family_id</th>
<th>ingredient_id</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>100</td>
</tr>
</tbody>
</table>
<code>ingredient_brands</code> Table

<table>
<thead>
<tr>
<th>ingredient_id</th>
<th>brand_id</th>
<th>price</th>
</tr>
</thead>

<tbody>
<tr>
<td>200</td>
<td>10</td>
<td>3.50</td>
</tr>

<tr>
<td>200</td>
<td>11</td>
<td>2.99</td>
</tr>

<tr>
<td>300</td>
<td>20</td>
<td>8.50</td>
</tr>

<tr>
<td>400</td>
<td>30</td>
<td>6.75</td>
</tr>
</tbody>
</table>
<code>acceptable_brands</code> Table

<table>
<thead>
<tr>
<th>family_id</th>
<th>brand_id</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>10</td>
</tr>

<tr>
<td>1</td>
<td>20</td>
</tr>

<tr>
<td>1</td>
<td>30</td>
</tr>
</tbody>
</table>
Output

<table>
<thead>
<tr>
<th>recipe_id</th>
<th>missing_ingredients</th>
<th>min_total_cost</th>
<th>feasible</th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>2</td>
<td>12.00</td>
<td>Yes</td>
</tr>

<tr>
<td>2</td>
<td>2</td>
<td>10.25</td>
<td>Yes</td>
</tr>
</tbody>
</table>

<h3>Explanation</h3>

For Recipe 1, the required ingredients are 100, 200, and 300. The pantry already contains ingredient 100, so only 200 and 300 are missing. The cheapest acceptable option for ingredient 200 is brand 10 at $3.50, since brand 11 is not allowed. For ingredient 300, the cheapest acceptable option is brand 20 at $8.50. This makes the total cost $12.00, and the recipe is feasible.

For Recipe 2, the required ingredients are 200 and 400. The cheapest acceptable choice for ingredient 200 is again $3.50, and for ingredient 400 it is $6.75. The total comes to $10.25, and this recipe is also feasible.

Write a SQL query to determine the cheapest valid shopping cost for each recipe for family_id = 1, while also identifying whether the recipe is feasible to make.

Christmas Dinner Ingredient Optimization

Let’s say that you work at a bank that wants to build a model to detect fraud on the platform.

The bank wants to implement a text messaging service in addition that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.

How would we build this model?

Let’s say that you work at a bank that wants to build a model to detect fraud on the platform.

The bank wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.

Which statement is true?

Let's say that you work at a bank that wants to build a model to detect fraud on the platform.

The bank wants to implement a text messaging service that will text customers when the model detects a fraudulent transaction in order for the customer to approve or deny the transaction with a text response.

Which statement is true?

Suppose there exists a new airline named Jetco that flies domestically across North America. Jetco recently had a study commissioned that tested the boarding time of every airline, and it came out that Jetco had the fastest average boarding times of any airline.

What factors could have biased this result, and what would you look into?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

What could potentially bias the average boarding time in favor of an airline that only flies domestically?

Let’s say we want to improve the matching algorithm for drivers and riders for Uber. The engineering team has added a new column to the <code>drivers</code> table called <code>weighting</code>. It contains a weighted value, which they hope will lead to better matching.

Given this table of drivers, write a query to perform a weighted random selection of a driver based on the driver weight.

Example:

Input:

<code>drivers</code> table

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>

<tr>
<td><code>weighting</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>id</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>

How would you explain what a p-value is to someone who is not technical?

What does a p-value in a statistical test represent?

What does a p-value in a statistical test represent?

P-value to a Layman I

In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?

In a statistical test, how does a low p-value (less than 0.05) influence our decision about the null hypothesis?

P-value to a Layman II

Let’s say you work at Uber. You’re getting reports that riders are complaining about the Uber map showing wrong location pickup spots.

How would you go about verifying how frequently this is happening?

Note: Assume you have user location data but not external data sources.

You're getting reports that riders are complaining about the Uber map showing wrong location pickup spots. How would you go about verifying how frequently this is happening?

Uber User Journey

Analytics

Let’s say you work for Lyft.

Lyft is testing out three variants of cancellation fees: $1, $3, and $5. How would you decide which cancellation fee to go with?

Cancellation Fees

Given a table of <code>cars</code> with columns <code>id</code> and <code>make</code>, write a query that outputs a random manufacturer’s name with an equal probability of selecting any name.

Input:

<code>cars</code> table

<table>
<thead>
<tr>
<th><code>id</code></th>
<th><code>make</code></th>
</tr>
</thead>

<tbody>
<tr>
<td>1</td>
<td>Ford</td>
</tr>

<tr>
<td>2</td>
<td>Toyota</td>
</tr>

<tr>
<td>3</td>
<td>Toyota</td>
</tr>

<tr>
<td>4</td>
<td>Honda</td>
</tr>

<tr>
<td>5</td>
<td>Honda</td>
</tr>

<tr>
<td>6</td>
<td>Honda</td>
</tr>
</tbody>
</table>
Output:

<table>
<thead>
<tr>
<th>Column</th>
<th>Type</th>
</tr>
</thead>

<tbody>
<tr>
<td><code>make</code></td>
<td>Text</td>
</tr>
</tbody>
</table>

Write a query that outputs a random manufacturer's name with an equal probability of selecting any name.

Uniform Car Maker

What are the assumptions of linear regression?

Which assumption of the residuals of the standard linear regression model can not be overcome by increasing the sample size?

Regression assumptions

You are given a function that generates a floating-point number between <code>0</code> and <code>1</code> from a continuous uniform distribution.

Write a function <code>dice_rolls</code> that takes the continuous random generator and simulates a dice roll (return a number between <code>1</code> and <code>6</code>, with all numbers having a uniform distribution).

Example:

Output:

<pre tabindex="0" class="chroma"><code>dice_roll(continuous_random_generator) -&gt; 1
dice_roll(continuous_random_generator) -&gt; 2
dice_roll(continuous_random_generator) -&gt; 6
#and so on ...
</code></pre>

Let’s say that you work at a B2B SAAS company that’s interested in testing the pricing of different levels of subscriptions.

Your project manager comes to you and asks you to run a two-week-long A/B test to test an increase in pricing.

How would you approach designing this test? How would you determine whether the increase in pricing is a good business decision?

Testing Price Increase

Let’s say you have a categorical variable with thousands of distinct values, how would you encode it?

Which method can be used to extract communities from large networks, that does not require a pre-determined number of clusters like K-means?

Which method can be used to extract communities from large networks, that does not require a pre-determined number of clusters like K-means?

Build a $k$ Nearest Neighbors classification model from scratch with the following conditions:

<ul>
<li>Use Euclidian distance (aka, the “2 norm”) as your closeness metric</li>
<li>Your function should be able to handle data frames of arbitrary many rows and columns</li>
<li>If there is a tie in the class of the $k$ nearest neighbors, rerun the search using $k-1$ neighbors instead</li>
<li>You may use <code>pandas</code> and <code>numpy</code> but NOT <code>scikit-learn</code></li>
</ul>

Example:

Input:

<pre tabindex="0" class="chroma"><code>k = 5
new_point = [0.5,-2,8]
print(data)
...
 Var1 Var2 Var3 Target
0 -3.279536 3.362223 2.847892 2
1 -0.791565 1.742475 2.151587 2
2 -0.785992 -0.938681 -0.459770 0
3 -1.068190 1.461051 0.127130 3
4 -0.367568 -0.870240 -0.225734 0
.. ... ... ... ...
95 -1.327175 1.971085 -0.690689 2
96 -3.203714 1.847649 0.778901 2
97 -0.587640 0.647458 2.094385 2
98 0.363644 -0.509795 2.514191 1
99 -0.673498 2.955285 2.102122 4

[100 rows x 4 columns]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def kNN(k, new_point, data) -&gt; 2
</code></pre>

Build a k Nearest Neighbors classification model from scratch.

KNN From Scratch

Write a function to simulate drawing balls from a jar. The colors of the balls are stored in a list named <code>jar</code>, with corresponding counts of the balls stored in the same index in a list called <code>n_balls</code>.

Example: 

Input:

<pre tabindex="0" class="chroma"><code>jar = [&#39;green&#39;, &#39;red&#39;, &#39;blue&#39;]
n_balls = [1, 10, 2]
# 1 green ball
# 10 red balls
# and 2 blue balls
</code></pre>

Output

<pre tabindex="0" class="chroma"><code>sample_multinomial(jar, n_balls) -&gt; &#34;blue&#34;
</code></pre>

How does random forest generate the forest? Additionally, why would we use it over other algorithms such as logistic regression?

What happens when you average the output on multiple decision trees?

What happens when you average the output on multiple decision trees?

Average Trees

Random Forest Explanation

In the context of hypothesis testing, what are type I errors (type one errors) and type II errors (type two errors)? What is the difference between the two?

Bonus: Describe the probability of making each type of error mathematically.

Given an array of <code>words</code> and a <code>max_width</code> parameter, write a function <code>justify</code> to format the text such that each line has exactly <code>max_width</code> characters. Pad extra spaces ’ ‘ when necessary so that each line has exactly <code>max_width</code> characters.

Extra spaces between words should be distributed as evenly as possible. If the number of spaces on a line does not divide evenly between words, place excess spaces on the right-hand side of each line.

Note: You may assume that there is no word in <code>words</code> that is longer than <code>max_width</code>.

Example:

Input:

<pre tabindex="0" class="chroma"><code>words = [&#34;This&#34;, &#34;is&#34;, &#34;an&#34;, &#34;example&#34;, &#34;of&#34;, &#34;text&#34;, &#34;justification.&#34;]
max_width = 16

def justify(words, max_width): -&gt;
[
 &#34;This is an&#34;,
 &#34;example of text&#34;,
 &#34;justification. &#34;
]
</code></pre>

How would you handle the data preparation for building a machine learning model using imbalanced data?

Addressing imbalanced data in machine learning through carefully prepared techniques.

Data Preparation for Imbalanced Data

You work as a data scientist on a ride sharing marketplace.

<ol>
<li>What metrics would you look at to determine the demand for rides at any point?</li>

<li>What metrics would tell you if there is high demand and low supply? How can you determine the threshold for when there’s too much demand?</li>
</ol>

As a data scientist in a ride sharing marketplace, which metrics could help determine the demand for rides at any point?

As a data scientist in a ride sharing marketplace, which metrics could help determine the demand for rides at any point?

Demand Metrics I

In the context of a ride sharing marketplace, which situation would indicate a high demand and low supply?

In the context of a ride sharing marketplace, which situation would indicate a high demand and low supply?

Demand Metrics II

How would you identify supply and demand mismatch in a ride sharing market place?

Demand Metrics

Product Sense & Metrics

Write a function <code>knn</code> which returns the nearest data point from a list of data points to a given query point. Use Euclidean distance as the similarity measure. For the purpose of this task, consider the scenario where $ k=1 $, meaning you only need to find the single closest data point.

Note: Using external libraries such as numpy and scikit-learn is not allowed.

Example:

Input:

<pre tabindex="0" class="chroma"><code>data_points = [
[1, 2, 3],
[4, 5, 6],
[7, 8, 9]
]

querying_point = [1, 9, 7]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def knn(data_point: List[List[float]], query_point: List[float]) -&gt; [4, 5, 6] 
</code></pre>

Where k=1, write a KNN algorithm from scratch.

A Simpler KNN From Scratch

How would you build the recommendation algorithm for type-ahead search for Netflix?

Calculate Moving Average	SQL	Easy
Predict Customer Churn	Machine Learning	Medium
A/B Test Significance	Statistics	Medium
Optimize Query Performance	SQL	Hard
Feature Importance Analysis	Machine Learning	Medium
Clean Missing Data	Python	Easy
Neural Network Architecture	Deep Learning	Hard
Calculate Cohort Retention	SQL	Medium
Bayesian Probability	Statistics	Easy
Recommend Similar Products	Machine Learning	Hard

Wing Aviation Interview Questions

Wing Aviation Interview Guides

Wing Aviation Interview Questions

Challenge

Wing Aviation Salaries by Position

Discussion & Interview Experiences

Discussion & Interview Experiences