How do I approach Data Manipulation (SQL/Python) interview questions?

Data Manipulation (SQL/Python) questions require understanding of core concepts and practice. PracHub provides solutions with explanations to help you master data manipulation (sql/python) interviews.

What difficulty level is this interview question?

This is a hard difficulty Data Manipulation (SQL/Python) question, commonly asked during Technical Screen rounds at Walmart Labs.

What role is this question designed for?

This question is commonly asked for Data Scientist candidates at Walmart Labs during technical interviews.

Convert Dictionary to DataFrame | Walmart Labs Interview Question

Convert Dictionary to DataFrame

Last updated: Apr 2, 2026

Quick Overview

This question evaluates proficiency in Python data manipulation and pandas DataFrame construction, specifically handling nested list structures and aligning rows by identifiers.

Walmart Labs

Jan 18, 2026, 12:00 AM

Data Scientist

Technical Screen

Data Manipulation (SQL/Python)

Using Python and pandas, convert the following dictionary into a DataFrame. Each top-level key is a target column name, and each value is a list of [row_id, cell_value] pairs. Use the first element of each pair as the row identifier, align rows by row_id across all keys, and produce a wide DataFrame with one row per row_id and one column per top-level key.

Input:

data = {
    'text1': [[123, '2'], [345, '3']],
    'text2': [[123, '4'], [345, '4']]
}

Expected structure:

row_id = 123 -> text1 = '2' , text2 = '4'
row_id = 345 -> text1 = '3' , text2 = '4'

Write Python code to create the DataFrame.

Comments (0)

Loading comments...

Browse More Questions

More Data Manipulation (SQL/Python)•More Walmart Labs•More Data Scientist•Walmart Labs Data Scientist•Walmart Labs Data Manipulation (SQL/Python)•Data Scientist Data Manipulation (SQL/Python)