Prepare for and practice interview questions from Flipkart across topics like Algorithms, SQL, Python and more.

Flipkart Interview Questions

A/B Testing

Algorithms

Analytics

Machine Learning

Probability

Product Metrics

Python

Statistics

Flipkart Interview Guides

You’re given a dataframe <code>df_rain</code> containing rainfall data. The dataframe has two columns: day of the week and rainfall in inches.

Write a function <code>median_rainfall</code> to find the median amount of rainfall for the days on which it rained.

Note: You may assume it rained on at least one of the days.

Input:

<pre tabindex="0" class="chroma"><code>import pandas as pd

rainfall = {&#34;Day&#34; : [&#34;Monday&#34;, &#34;Tuesday&#34;, &#34;Wednesday&#34;, &#34;Thursday&#34;, &#34;Friday&#34;], &#34;Inches&#34; : [0, 1.2, 0, 0.8, 1]}

df_rain = pd.DataFrame(rainfall)
</code></pre>

Output:

<pre tabindex="0" class="chroma"><code>def median_rainfall(df_rain) -&gt; 1
</code></pre>

Write a function to find the median amount of rainfall for the days on which it rained.

Rain on Rainy Days

Python & General Programming

Given the <code>transactions</code> table, write a query to get the max quantity purchased for each distinct <code>product_id</code>, every year. 

The output should include the <code>year</code>, <code>product_id</code>, and <code>max_quantity</code> for that product sorted by year and <code>product_id</code> ascending.

Example:

Input:

<code>transactions</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>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>Column</th>
<th>Type</th>
</tr>
</thead>

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

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

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

Max Quantity

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?

Boarding Times Bias

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?

Question	Topic	Difficulty	Ask Chance
Rain on Rainy Days	Python & General Programming	Easy	Very High
Max Quantity	SQL	Easy	Very High
Boarding Times Bias	Statistics	Medium	High

Flipkart Interview Questions

Flipkart Interview Guides

Flipkart Interview Questions

Flipkart Salaries by Position