Home›Courses›Data Analytics›Section test

Section checkpoint · 07

Reshaping & Integration

Use this short test to check whether the main ideas from the section are connected in your mind. A strong score means you can recognise the concepts; revisit linked lessons when an answer feels uncertain.

5questionsTarget: 4/5 or better

Question 11 point

Which concept is most appropriate for this situation: You need labelled tabular data with row/column operations, filtering or aggregation.

Merge and Join DataframesPivot TablesGroupby Split Apply CombineMelt Wide to Long

Question 21 point

Which concept is most appropriate for this situation: You need to combine related records from two tables using one or more shared keys.

Pivot TablesMerge and Join DataframesValidate Join CardinalityGroupby Split Apply Combine

Question 31 point

Which concept is most appropriate for this situation: You need uniqueness, membership checks, or operations such as union and intersection.

Pivot TablesGroupby Split Apply CombineMelt Wide to LongConcatenate Datasets

Question 41 point

Which concept is most appropriate for this situation: You need to convert wide columns into a longer variable/value representation.

Groupby Split Apply CombinePivot TablesValidate Join CardinalityMelt Wide to Long

Question 51 point

Which concept is most appropriate for this situation: You need summary statistics calculated separately for each category or group.

Pivot TablesGroupby Split Apply CombineConcatenate DatasetsValidate Join Cardinality