C4W4A1 – Row count mismatch in deftunes_transform tables

Course Q&A Data Engineering Data Modeling, Transformation, and Serving
,
1

I’m currently working on C4W4A1 – Assignment 4: Capstone Project Part 1 (ETL and Data Modeling) on the Coursera platform.

Issue

I am unable to pass the assignment due to consistent row count mismatches reported by the grader:

  • dev.deftunes_transform tables output: Expected 34 rows, but got 54

  • deftunes_transform.sessions table output: Expected 92 rows, but got 167

What I’ve tried

  • Carefully followed all assignment instructions

  • Re-ran the assignment twice

Observation

The outputs consistently return these errors. I also found that other learners have reported the same discrepancies, but I haven’t seen a confirmed solution yet.

This issue is currently blocking my course completion, so I would really appreciate any guidance.

Thank you!

2

@namgiang Hi! As you see in the other branch of discussion with the same issue (where you also commented), Rebooting the lab and submitting it again usually helps.

3

Hi, I’m experiencing the same issue as reported here.

I have already tried rebooting the lab and rerunning the entire notebook multiple times (including clearing all outputs and following the steps strictly), but I am still getting the exact same errors:

  • ex02: Expected 34 lines, got 54

  • ex04 (sessions): Expected 92 lines, got 167

At this point, I’m stuck and unable to complete this module.

4

I have rebooted and submitted it three times and always get the same problem:

image
image1453×651 59 KB

5

@jpablo2292 sorry to hear that! I’ll look into it.