Prepare for and practice interview questions from Instacart across topics like Takehome, SQL, Python and more.

Instacart Interview Questions

Python

Machine Learning

Product Metrics

A/B Testing

Analytics

Statistics

Probability

Algorithms

Instacart Interview Guides

Given a list of tuples featuring names and grades on a test, write a function <code>normalize_grades</code> to normalize the values of the grades to a linear scale between <code>0</code> and <code>1</code>.

Example:

Input:

<pre tabindex="0" class="chroma"><code>grades = [
 (&#39;Jason&#39;, 94),
 (&#39;Tessa&#39;, 80),
 (&#39;Carla&#39;, 38),
 (&#39;Matt&#39;, 43),
 (&#39;Jessica&#39;, 100)
]
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def normalize_grades(grades) - &gt; [
 (&#39;Jason&#39;, 0.9),
 (&#39;Tessa&#39;, 0.68),
 (&#39;Carla&#39;, 0.0),
 (&#39;Matt&#39;, 0.08),
 (&#39;Jessica&#39;, 1.0)
]
</code></pre>

Given a list of tuples featuring names and grades on a test, write a function to normalize the values of the grades to a linear scale between 0 and 1.

Normalize Grades

You are a chef preparing for an important event. You downloaded three recipes to make and imported each as a separate table: <code>recipe1</code>, <code>recipe2</code>, <code>recipe3</code> into your database. Each recipe requires some grocery items in various quantities.

Write a query that sums up the total mass of each grocery item required across all recipes.

Input:

<code>recipe1</code> table:

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

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

<tr>
<td><code>mass</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>recipe2</code> table:

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

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

<tr>
<td><code>mass</code></td>
<td>INTEGER</td>
</tr>
</tbody>
</table>
<code>recipe3</code> table:

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

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

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

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

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

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

Write a query to generate a shopping list that sums up the total mass of each grocery item required across three recipes.

Generate Shopping List from Recipes

We have two buckets full of marbles. There are 30 red marbles and 10 black marbles in Bucket #1 and 20 red and 20 Black marbles in Bucket #2. Your friend secretly pulls a marble from one of the two buckets and shows you that the marble is red.

<ol>
<li>What is the probability that it was pulled from Bucket #1?</li>

<li>Let’s say your friend puts the marble back in and now picks two marbles. She draws one marble, puts it back in the same bucket, then draws a second. They both happen to be red. What is the probability that they both came from Bucket #1?</li>
</ol>

Instacart Interview Questions

Instacart Interview Guides

Instacart Interview Questions

Instacart Salaries by Position