Data Engineering Zoomcamp 2024

Workshop 1: Data Ingestion Statistics

Distribution of scores and reported study time for this homework.

Submissions

608

Median total score

Average total score

Score distribution

All values are points.

Metric	Min	Q1	Median	Average	Q3	Max
Questions score	2	4.0	4.0	4.0	4.0	4
Learning in public score	-	0.0	0.0	0.4	1.0	3
Total score	2	4.0	4.0	4.5	5.0	8

Questions score

Min: 2
Median: 4.0
Max: 4
Q1: 4.0
Avg: 4.0
Q3: 4.0

Learning in public score

Min: -
Median: 0.0
Max: 3
Q1: 0.0
Avg: 0.4
Q3: 1.0

Total score

Min: 2
Median: 4.0
Max: 8
Q1: 4.0
Avg: 4.5
Q3: 5.0

Time distribution

All values are hours reported by students.

Metric	Min	Q1	Median	Average	Q3	Max
Lectures	0.0	2.0	2.0	4.0	3.0	124.0
Homework	0.0	1.0	1.5	2.6	3.0	76.0

Lectures

Min: 0.0
Median: 2.0
Max: 124.0
Q1: 2.0
Avg: 4.0
Q3: 3.0

Homework

Min: 0.0
Median: 1.5
Max: 76.0
Q1: 1.0
Avg: 2.6
Q3: 3.0

Question breakdown

Correctness and answer distribution per question.

1. What is the sum of the outputs of the generator for limit = 5?

599 / 608 correct (98.5%)

1 10.234 7 (1.2%)

2 7.892 2 (0.3%)

3 8.382 599 (98.5%)

4 9.123 0 (0.0%)

2. What is the 13th number yielded by the generator?

595 / 608 correct (97.9%)

1 4.236 4 (0.7%)

2 3.605 595 (97.9%)

3 2.345 2 (0.3%)

4 5.678 6 (1.0%)

3. Append the 2 generators. After correctly appending the data, calculate the sum of all ages of people.

608 / 608 correct (100.0%)

1 353 594 (97.7%)

2 365 7 (1.2%)

3 378 3 (0.5%)

4 390 1 (0.2%)

4. Merge the 2 generators using the ID column. Calculate the sum of ages of all the people loaded as described above.

608 / 608 correct (100.0%)

1 215 20 (3.3%)

2 266 540 (88.8%)

3 241 9 (1.5%)

4 258 6 (1.0%)

Calculated: 13 October 2024, 16:29