# Data I/O and Processing with Python and SQL **URL:** https://community.deeplearning.ai/c/course-q-a/data-analytics-professional-certificate/dag-course-4/510.md [Latest](https://community.deeplearning.ai/latest.md) · [Categories](https://community.deeplearning.ai/categories.md) · [Tags](https://community.deeplearning.ai/tags.md) --- ## [C4M4 Assignment: Why does my CASE expression for rating bins give different results?](https://community.deeplearning.ai/t/c4m4-assignment-why-does-my-case-expression-for-rating-bins-give-different-results/895178)
**Author:** [@chenxi2026](https://community.deeplearning.ai/u/chenxi2026)\ **Replies:** 1\ **Last updated:** [September 17, 2026, 4:00am UTC](https://community.deeplearning.ai/t/c4m4-assignment-why-does-my-case-expression-for-rating-bins-give-different-results/895178 "2026-09-17T04:00:31Z")
My first attempt was: WHEN rating \> 3.5 THEN 'High' WHEN rating \< 2.5 THEN 'Low' ELSE 'Medium' The output is: While the expected output is: Then I tried this version: WHEN rating \> 3.5 THEN 'High' WHEN rati… --- ## [C4M4\_Assignment - Graded Exercise 3](https://community.deeplearning.ai/t/c4m4-assignment-graded-exercise-3/894504)
**Author:** [@Peter\_Donovan](https://community.deeplearning.ai/u/Peter_Donovan)\ **Replies:** 1\ **Last updated:** [August 10, 2026, 5:40pm UTC](https://community.deeplearning.ai/t/c4m4-assignment-graded-exercise-3/894504 "2026-08-10T17:40:42Z")
Directions state: However, the expected output includes records that have a NULL rating as well. Written according to the directions the output is: This could be clarified or corrected in future. Thank you. --- ## [Data I/O and Preprocessing with Python and SQL — Module 2 grader mismatch (Exercises 3, 5, 6, 8) despite correct output](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-module-2-grader-mismatch-exercises-3-5-6-8-despite-correct-output/894455)
**Author:** [@Grigori\_Azaryants](https://community.deeplearning.ai/u/Grigori_Azaryants)\ **Replies:** 2\ **Last updated:** [August 7, 2026, 7:36pm UTC](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-module-2-grader-mismatch-exercises-3-5-6-8-despite-correct-output/894455 "2026-08-07T19:36:17Z")
I’ve executed all the steps 1-4, but the error is still with me: I’m unable to pass the grader for Module 2’s graded lab, despite extensive manual verification that my code and output are correct. Details below: Exerci… --- ## [Data I/O and Preprocessing with Python and SQL (Instructor - Sean Barnes)](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-instructor-sean-barnes/884875)
**Author:** [@DeepaNZ](https://community.deeplearning.ai/u/DeepaNZ)\ **Replies:** 5\ **Last updated:** [August 6, 2026, 10:33pm UTC](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-instructor-sean-barnes/884875 "2026-08-06T22:33:05Z")
Kia Ora! I am starting this as a new post as I didn’t receive any resolution. I am having trouble with final exercise I do so far, throwing 401 error. If it’s right, kindly share the fix you found. And I have tried acce… --- ## [Data I/O and Preprocessing with Python and SQL](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql/875739)
**Author:** [@ainhyeok](https://community.deeplearning.ai/u/ainhyeok)\ **Replies:** 13\ **Last updated:** [August 3, 2026, 8:46am UTC](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql/875739 "2026-08-03T08:46:53Z")
I wrote all the code and got the same output as the correct answer, but my grade is 0. Is there a way to fix this? The assignments I could not get the score are: Identifying Vulnerable Communities using the U.S Censu… --- ## [API Keys In Exercises Not Working](https://community.deeplearning.ai/t/api-keys-in-exercises-not-working/894278)
**Author:** [@Ember1](https://community.deeplearning.ai/u/Ember1)\ **Replies:** 10\ **Last updated:** [August 3, 2026, 5:33am UTC](https://community.deeplearning.ai/t/api-keys-in-exercises-not-working/894278 "2026-08-03T05:33:12Z")
Hello, I’m having trouble with the API key working on an assignment. I think it is the key that’s the issue and not the code, which I explain below. COURSE - Data I/O and Preprocessing with Python and SQL MODULES - 2, … --- ## [Module 2 Graded Lab Issues - GRADER ERROR](https://community.deeplearning.ai/t/module-2-graded-lab-issues-grader-error/824647)
**Author:** [@rangerick555](https://community.deeplearning.ai/u/rangerick555)\ **Replies:** 4\ **Last updated:** [June 9, 2026, 9:20am UTC](https://community.deeplearning.ai/t/module-2-graded-lab-issues-grader-error/824647 "2026-06-09T09:20:13Z")
Hi \[Instructor/Support Team\], I’m running into repeated grading issues in the lab. Although my code produces correct results — including valid API responses and correctly named columns — the grader continues to fail my … --- ## [Unexpected Error grading on Module 4 assigment on the Data with SQL on the Data I/O and Preprocessing with Python and SQL course](https://community.deeplearning.ai/t/unexpected-error-grading-on-module-4-assigment-on-the-data-with-sql-on-the-data-i-o-and-preprocessing-with-python-and-sql-course/890384)
**Author:** [@Maialen](https://community.deeplearning.ai/u/Maialen)\ **Replies:** 2\ **Last updated:** [March 16, 2026, 3:27pm UTC](https://community.deeplearning.ai/t/unexpected-error-grading-on-module-4-assigment-on-the-data-with-sql-on-the-data-i-o-and-preprocessing-with-python-and-sql-course/890384 "2026-03-16T15:27:43Z")
I am currently doing the DeepLearning.AI Data Analytics, which contains 5 different courses. On the fourth one, called Data I/O and Preprocessing with Python and SQL, I have been having a problem with the grading on the … --- ## [Analyzing Movie Data with SQL](https://community.deeplearning.ai/t/analyzing-movie-data-with-sql/889295)
**Author:** [@angeleyes](https://community.deeplearning.ai/u/angeleyes)\ **Replies:** 5\ **Last updated:** [February 23, 2026, 5:56pm UTC](https://community.deeplearning.ai/t/analyzing-movie-data-with-sql/889295 "2026-02-23T17:56:28Z")
There is a programming assignment about analyzing movie data with SQL In the module 3, Course 4 of the Data Analytics Professional Certificate on Coursera. The link that was provided to the database dataset used in this… --- ## [Solved: Analyzing Movie Data with SQL - cannot pass programming assignment as locked cell won't complete](https://community.deeplearning.ai/t/solved-analyzing-movie-data-with-sql-cannot-pass-programming-assignment-as-locked-cell-wont-complete/887408)
**Author:** [@araigon](https://community.deeplearning.ai/u/araigon)\ **Replies:** 1\ **Last updated:** [January 19, 2026, 4:44pm UTC](https://community.deeplearning.ai/t/solved-analyzing-movie-data-with-sql-cannot-pass-programming-assignment-as-locked-cell-wont-complete/887408 "2026-01-19T16:44:35Z")
I am trying to complete my programming assignment C4M3\_Assignment and have entered all the required code but when I run all the cells manually or via Run \> Run All Cells, below one doesn’t complete. plt.figure(figsize=(… --- ## [My problem](https://community.deeplearning.ai/t/my-problem/884226)
**Author:** [@AbdulRehman2278](https://community.deeplearning.ai/u/AbdulRehman2278)\ **Replies:** 11\ **Last updated:** [December 26, 2025, 11:10pm UTC](https://community.deeplearning.ai/t/my-problem/884226 "2025-12-26T23:10:50Z")
This is my assesment in coursera course: NYC Restaurant Inspections Grader Error: Grader feedback not found This error comes every time i complete the complete assesment. --- ## [Invalid or missing API key- Data I/O and Preprocessing with Python and SQL Capstone](https://community.deeplearning.ai/t/invalid-or-missing-api-key-data-i-o-and-preprocessing-with-python-and-sql-capstone/823277)
**Author:** [@MiloAndelic](https://community.deeplearning.ai/u/MiloAndelic)\ **Replies:** 6\ **Last updated:** [December 11, 2025, 1:56am UTC](https://community.deeplearning.ai/t/invalid-or-missing-api-key-data-i-o-and-preprocessing-with-python-and-sql-capstone/823277 "2025-12-11T01:56:24Z")
API key seems incorrect in Data I/O and Preprocessing with Python and SQL Capstone. Could someone check it out and resolve the issue ? --- ## [Help! Missing Programming Assignment in Module 2 of Data I/O and Preprocessing with Python and SQL](https://community.deeplearning.ai/t/help-missing-programming-assignment-in-module-2-of-data-i-o-and-preprocessing-with-python-and-sql/884280)
**Author:** [@Hello\_Sammi](https://community.deeplearning.ai/u/Hello_Sammi)\ **Replies:** 2\ **Last updated:** [December 9, 2025, 4:00am UTC](https://community.deeplearning.ai/t/help-missing-programming-assignment-in-module-2-of-data-i-o-and-preprocessing-with-python-and-sql/884280 "2025-12-09T04:00:04Z")
Hello! I tried accessing the grading programming assignment titled “Identifying Vulnerable Communities using the U.S. Census API” under Module 2 of the Data I/O and Preprocessing with Python and SQL course on Coursera, b… --- ## [Module 4 Capstone - Invalid or missing API key](https://community.deeplearning.ai/t/module-4-capstone-invalid-or-missing-api-key/883596)
**Author:** [@bradmg](https://community.deeplearning.ai/u/bradmg)\ **Replies:** 2\ **Last updated:** [November 18, 2025, 7:32pm UTC](https://community.deeplearning.ai/t/module-4-capstone-invalid-or-missing-api-key/883596 "2025-11-18T19:32:17Z")
I am unable to load data in Ex 2. I can successfully print an API\_KEY so there is an environment variable, but the request fails and it says that API key is missing or invalid. --- ## [Data I/O and Preprocessing with Python and SQL | Capstone: NYC Restaurant Inspections](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-capstone-nyc-restaurant-inspections/882916)
**Author:** [@naman777rathore](https://community.deeplearning.ai/u/naman777rathore)\ **Replies:** 2\ **Last updated:** [November 7, 2025, 2:03pm UTC](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-capstone-nyc-restaurant-inspections/882916 "2025-11-07T14:03:02Z")
{removed by mentor} stuck in ex 6 as no mention of what column to use for average as there’s no such column like rating in the table named inspections and question explicitly says to use inspections table here is the s… --- ## [Grading: Module 2 Assignment: Identifying Vulnerable Communities using the U.S. Census API](https://community.deeplearning.ai/t/grading-module-2-assignment-identifying-vulnerable-communities-using-the-u-s-census-api/882768)
**Author:** [@fotiskb](https://community.deeplearning.ai/u/fotiskb)\ **Replies:** 1\ **Last updated:** [November 5, 2025, 12:17pm UTC](https://community.deeplearning.ai/t/grading-module-2-assignment-identifying-vulnerable-communities-using-the-u-s-census-api/882768 "2025-11-05T12:17:42Z")
Hello there, I did the assignment, i get all the expected values when i run the code and it seems very much correct. I always get 65% as i have errors like the below: Failed test case: The following columns in census\_… --- ## [Module 3 Programming Assignment- Analyzing Movie Data with SQL](https://community.deeplearning.ai/t/module-3-programming-assignment-analyzing-movie-data-with-sql/879720)
**Author:** [@Stakesishigh](https://community.deeplearning.ai/u/Stakesishigh)\ **Replies:** 10\ **Last updated:** [October 3, 2025, 3:43pm UTC](https://community.deeplearning.ai/t/module-3-programming-assignment-analyzing-movie-data-with-sql/879720 "2025-10-03T15:43:21Z")
I have entered in the correct code, or at least the code that is giving me the correct result. However, I am getting 0/15 on all of them. This is the error message I am getting: “There was a problem compiling the code … --- ## [/lab/workspaces/auto-G/tree/C4M2\_Assignment.ipynb](https://community.deeplearning.ai/t/lab-workspaces-auto-g-tree-c4m2-assignment-ipynb/879870)
**Author:** [@Kemiron](https://community.deeplearning.ai/u/Kemiron)\ **Replies:** 1\ **Last updated:** [September 22, 2025, 3:41pm UTC](https://community.deeplearning.ai/t/lab-workspaces-auto-g-tree-c4m2-assignment-ipynb/879870 "2025-09-22T15:41:08Z")
How to restart the lab? --- ## [Module 3 Programming Assignment - Analyzing Movie Data with Sql - Other issue](https://community.deeplearning.ai/t/module-3-programming-assignment-analyzing-movie-data-with-sql-other-issue/879723)
**Author:** [@Stakesishigh](https://community.deeplearning.ai/u/Stakesishigh)\ **Replies:** 1\ **Last updated:** [September 21, 2025, 8:28am UTC](https://community.deeplearning.ai/t/module-3-programming-assignment-analyzing-movie-data-with-sql-other-issue/879723 "2025-09-21T08:28:17Z")
Hi again - I tried to look at the mubi\_mubi db in jupityr in the assignment and got this error message: File Load Error for mubi\_movies\_ratings.db /home/jovyan/work/mubi\_movies\_ratings.db is not UTF-8 encoded Would th… --- ## [Programming Assignment: NYC Restaurant Inspections](https://community.deeplearning.ai/t/programming-assignment-nyc-restaurant-inspections/878735)
**Author:** [@CamLiv8](https://community.deeplearning.ai/u/CamLiv8)\ **Replies:** 7\ **Last updated:** [September 10, 2025, 8:14am UTC](https://community.deeplearning.ai/t/programming-assignment-nyc-restaurant-inspections/878735 "2025-09-10T08:14:39Z")
To Create a post, follow these guidelines: A clear title for the post Include one of these tags per post (in the tag option) daily-streak course-topics social-sharing recommendation Hi all, issues here: He… --- ## [The time-consuming fiend which is Programming Assignment: Deeper Analysis of the Movie Data with SQL](https://community.deeplearning.ai/t/the-time-consuming-fiend-which-is-programming-assignment-deeper-analysis-of-the-movie-data-with-sql/877712)
**Author:** [@CamLiv8](https://community.deeplearning.ai/u/CamLiv8)\ **Replies:** 8\ **Last updated:** [September 7, 2025, 12:57pm UTC](https://community.deeplearning.ai/t/the-time-consuming-fiend-which-is-programming-assignment-deeper-analysis-of-the-movie-data-with-sql/877712 "2025-09-07T12:57:08Z")
Hello Raymond and everyone in this digital realm! Here, are screenshots for your records: --- ## [Vote Programming Assignment: Analyzing Movie Data with SQL](https://community.deeplearning.ai/t/vote-programming-assignment-analyzing-movie-data-with-sql/877529)
**Author:** [@CamLiv8](https://community.deeplearning.ai/u/CamLiv8)\ **Replies:** 5\ **Last updated:** [August 25, 2025, 1:01pm UTC](https://community.deeplearning.ai/t/vote-programming-assignment-analyzing-movie-data-with-sql/877529 "2025-08-25T13:01:46Z")
Hi guys, sorry to be a pain! I have passed all the tests for this assignment , yet a fail from the grader: --- ## [Data I/O and Preprocessing with Python and SQL graded assignment zero marks](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-graded-assignment-zero-marks/860027)
**Author:** [@Palwasha\_Shoukat](https://community.deeplearning.ai/u/Palwasha_Shoukat)\ **Replies:** 9\ **Last updated:** [August 6, 2025, 12:21pm UTC](https://community.deeplearning.ai/t/data-i-o-and-preprocessing-with-python-and-sql-graded-assignment-zero-marks/860027 "2025-08-06T12:21:56Z")
Data I/O and Preprocessing with Python and SQL graded assignment zero marks even update latest version and did it again with so concentration still zero marks plz help me…i am receiving following statement while submitti… --- ## [Capstone: NYC Restaurant Inspections C4 Module 4 - no json data](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-c4-module-4-no-json-data/859340)
**Author:** [@DanielleG](https://community.deeplearning.ai/u/DanielleG)\ **Replies:** 3\ **Last updated:** [July 25, 2025, 5:52pm UTC](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-c4-module-4-no-json-data/859340 "2025-07-25T17:52:28Z")
It sems the server returns no data, the status\_code is 200 but when trying to extract the json from “https://2eraiuh.dlai.link/api/business\_info”, I get this error stack: File /opt/conda/lib/python3.11/json/decoder.py:3… --- ## [Module 2 Graded Lab Ex. 6 Vulnerability Score](https://community.deeplearning.ai/t/module-2-graded-lab-ex-6-vulnerability-score/859333)
**Author:** [@carmuna](https://community.deeplearning.ai/u/carmuna)\ **Replies:** 3\ **Last updated:** [July 25, 2025, 12:13pm UTC](https://community.deeplearning.ai/t/module-2-graded-lab-ex-6-vulnerability-score/859333 "2025-07-25T12:13:26Z")
Hi, I keep getting 0 points for exercise 6, even though the vulnerability score distribution seems to exactly match the expected output. I don’t know how I can review this. Here are the error messages: Failed test cas… --- ## [Capstone: NYC Restaurant Inspections. Ex. 4](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-ex-4/857086)
**Author:** [@shofagbile](https://community.deeplearning.ai/u/shofagbile)\ **Replies:** 5\ **Last updated:** [July 24, 2025, 11:59am UTC](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-ex-4/857086 "2025-07-24T11:59:54Z")
I am having trouble with exercise 4 of the capstone i forwarded my feedback error message with no respond and I’m stocked. Please kindly help below is the error I got. --- ## [Capstone: NYC Restaurant Inspections - Autograder not grading assignment](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-autograder-not-grading-assignment/856287)
**Author:** [@Rephael](https://community.deeplearning.ai/u/Rephael)\ **Replies:** 2\ **Last updated:** [July 21, 2025, 1:30pm UTC](https://community.deeplearning.ai/t/capstone-nyc-restaurant-inspections-autograder-not-grading-assignment/856287 "2025-07-21T13:30:02Z")
I waited 24 hours, and the autograder is still not accepting my work. I went through the Coursera chatbot without any resolution. Please help me submit my workk. --- ## [Module 4 Assignment: Deeper Analysis of the Movie Data with SQL](https://community.deeplearning.ai/t/module-4-assignment-deeper-analysis-of-the-movie-data-with-sql/835521)
**Author:** [@Yaecob](https://community.deeplearning.ai/u/Yaecob)\ **Replies:** 8\ **Last updated:** [July 20, 2025, 12:40pm UTC](https://community.deeplearning.ai/t/module-4-assignment-deeper-analysis-of-the-movie-data-with-sql/835521 "2025-07-20T12:40:03Z")
Dear all, Greetings! I wanted to share my experience with the assignment auto-grader in “Module 4 Assignment: Deeper Analysis of the Movie Data with SQL” in case it helps others who may encounter similar issues to mine… --- ## [Capstone Project Ex.4](https://community.deeplearning.ai/t/capstone-project-ex-4/853919)
**Author:** [@shofagbile](https://community.deeplearning.ai/u/shofagbile)\ **Replies:** 2\ **Last updated:** [July 18, 2025, 10:37am UTC](https://community.deeplearning.ai/t/capstone-project-ex-4/853919 "2025-07-18T10:37:22Z")
I am having trouble with the Ex.4 of the capstone project. I have attempted several options but I still get error from my code. Based on the direction i think my code is right. Please help. --- ## [Module 3 Graded Lab ex6: expected output incorrect](https://community.deeplearning.ai/t/module-3-graded-lab-ex6-expected-output-incorrect/849151)
**Author:** [@carmuna](https://community.deeplearning.ai/u/carmuna)\ **Replies:** 1\ **Last updated:** [July 15, 2025, 4:09pm UTC](https://community.deeplearning.ai/t/module-3-graded-lab-ex6-expected-output-incorrect/849151 "2025-07-15T16:09:57Z")
Hi team, in module 3 exercise 6, the expected output (which is shown below the code cells) seems incorrect. When I match the expected output, I score only 8/15 for that exercise. The upper part of the screenshot shows… [Next page](https://community.deeplearning.ai/c/course-q-a/data-analytics-professional-certificate/dag-course-4/510.md?page=1)