Data Engineering Zoomcamp 2024

Homework 2: Mage Statistics

Distribution of scores and reported study time for this homework.

Submissions

844

Median total score

6

Average total score

6

Score distribution

All values are points.

Questions score

Min
-
Median
6.0
Max
6
Q1
6.0
Avg
5.8
Q3
6.0

Learning in public score

Min
-
Median
0.0
Max
7
Q1
0.0
Avg
0.5
Q3
1.0

Total score

Min
-
Median
6.0
Max
14
Q1
6.0
Avg
6.4
Q3
7.0

Time distribution

All values are hours reported by students.

Lectures

Min
0.0
Median
5.0
Max
120.0
Q1
3.0
Avg
7.9
Q3
8.0

Homework

Min
0.0
Median
3.0
Max
180.0
Q1
2.0
Avg
4.4
Q3
4.0

Question breakdown

Correctness and answer distribution per question.

1. Data Loading

822 / 844 correct (97.4%)

1 266 855 rows x 20 columns 822 (97.4%)
2 544 898 rows x 18 columns 8 (0.9%)
3 544 898 rows x 20 columns 6 (0.7%)
4 133 744 rows x 20 columns 8 (0.9%)

2. Data Transformation

816 / 844 correct (96.7%)

1 544 897 rows 4 (0.5%)
2 266 855 rows 23 (2.7%)
3 139 370 rows 816 (96.7%)
4 266 856 rows 1 (0.1%)

3. Data Transformation

834 / 844 correct (98.8%)

1 data = data['lpep_pickup_datetime'].date 4 (0.5%)
2 data('lpep_pickup_date') = data['lpep_pickup_datetime'].date 2 (0.2%)
3 data['lpep_pickup_date'] = data['lpep_pickup_datetime'].dt.date 834 (98.8%)
4 data['lpep_pickup_date'] = data['lpep_pickup_datetime'].dt().date() 2 (0.2%)

4. Data Transformation

824 / 844 correct (97.6%)

1 1 2 or 3 11 (1.3%)
2 1 or 2 824 (97.6%)
3 1 2 3 4 4 (0.5%)
4 1 3 (0.4%)

5. Data Transformation

806 / 844 correct (95.5%)

1 3 16 (1.9%)
2 6 8 (0.9%)
3 2 13 (1.5%)
4 4 806 (95.5%)

6. Data Exporting

773 / 844 correct (91.6%)

1 96 773 (91.6%)
2 56 27 (3.2%)
3 67 17 (2.0%)
4 108 14 (1.7%)

Calculated: 11 October 2024, 08:34