A review export writes missing scores as NULL, N/A, - or an empty field - in any letter case. Treat all four as missing.
Return review_id, score, quality sorted by review_id:
score is an int, or null when the raw token is missingquality is 'missing' for those rows and 'complete' otherwiseNormalise with upper(trim(...)) before comparing, so n/a and N/A behave the same.
These files are loaded into this browser when you run. Their paths are handed to your code as the third argument: solve(spark, dfs, paths). Read one with spark.read.csv(paths['users'], header=True), or skip the read and use dfs['users'].
reviews]