CSV وفاصلة داخل حقل

بيانات محلية كاملة وقاعدة معالجة محددة؛ يمكنك الحل يدويًا أو ببرنامج صغير على جهازك.

CSV BEGIN
id,label,status,score
7,"red, archived",closed,90
8,North,open,12
9,East,open,17
10,South,closed,50
CSV END
RULES: first row is a header. A comma INSIDE double quotes belongs to the field.
Select status exactly equal to open. Convert score from decimal text to integer. Sum selected scores.
PYTHON 3 APPROACH: csv.DictReader parses the supplied CSV body; int(row["score"]) converts a score.
TARGET: OPEN_ followed by the sum in decimal.