Dinosaur CSV Data Integration | Dataford Interview Questions

Dinosaur CSV question: given dataset1.csv (NAME,LEG_LENGTH,DIET) and dataset2.csv (NAME,STRIDE_LENGTH,STANCE), process the data (prompt partly walled).

Asked in the video screen during the coding stage. Implement find_running_dinosaurs(dataset1, dataset2), where each argument is a list of dictionaries containing the corresponding CSV columns as strings. Join rows by NAME. A dinosaur can run only when STANCE is bipedal and its calculated speed is greater than 1.0: speed = (STRIDE_LENGTH / LEG_LENGTH - 1) * sqrt(LEG_LENGTH * 9.8).

Return matching names in alphabetical order. For example, a bipedal dinosaur with leg length 2.5 and stride length 5.0 qualifies; a quadrupedal dinosaur does not.

Constraints

Each dataset is a list of dictionaries using the specified column names.
NAME values are unique within each dataset.
0 <= len(dataset1), len(dataset2) <= 10^5
LEG_LENGTH and STRIDE_LENGTH are positive numeric strings.
STANCE comparison is case-insensitive.
A dinosaur must appear in both datasets to be evaluated.
A speed exactly equal to 1.0 does not qualify.

Function Signature

def find_running_dinosaurs(dataset1, dataset2):

Your question is Dinosaur CSV Data Integration. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Dinosaur CSV question: given dataset1.csv (NAME,LEG_LENGTH,DIET) and dataset2.csv (NAME,STRIDE_LENGTH,STANCE), process the data (prompt partly walled).

Return matching names in alphabetical order. For example, a bipedal dinosaur with leg length 2.5 and stride length 5.0 qualifies; a quadrupedal dinosaur does not.

Constraints

Each dataset is a list of dictionaries using the specified column names.
NAME values are unique within each dataset.
0 <= len(dataset1), len(dataset2) <= 10^5
LEG_LENGTH and STRIDE_LENGTH are positive numeric strings.
STANCE comparison is case-insensitive.
A dinosaur must appear in both datasets to be evaluated.
A speed exactly equal to 1.0 does not qualify.

Function Signature

def find_running_dinosaurs(dataset1, dataset2):

Your question is Dinosaur CSV Data Integration. Start with the requirements in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.