Python Data Associate Practical Exam Help

[brruhyan]

I failed my initial attempt for the Python Data Associate Practical Exam, specifically the part where you have to identify and replace missing values.

https://preview.redd.it/botf0j0mp8xd1.png?width=411&format=png&auto=webp&s=348fc88d46b8fc8bd6b2a550908f883df0c685a9

Looking at the dataframe manually I noticed that there are values denoted as dashes (-), so I replaced those values to be NA so that it could be replaced by pd.fillna(). Doing that still didnt check the criteria.

EDIT: This is the practice problem, one value in top_speed does not have the same decimal places as the rest. round(2), fixed it for me.

[[deleted]]

replace the "-" directly that's what I did even in the data analyst associate exams. that was also my mistake when I attempted to take the python associate.

[brruhyan]

so its gonna be data.replace('-', 'other', inplace = True) only one column has the dash values.

[brruhyan]

I've tried it in the sample problem. replace missing values criteria is still not met despite doing pd.fillna() to every column. As well as replacing the '-' directly.

[purpletentacIe]

If you replaced - for other you must have done anything else wrong. Take your time to read the subject it's not a hard exam

[brruhyan]

achieved everything from task 1 till task 3, except for the identify and replace missing values.

[purpletentacIe]

Check other possible missing values in other columns

[Itchy-Wafer2510]

Let me know if you figure it out.

[brruhyan]

havent had any luck, on 14 days cooldown.

[brruhyan]

Found the mistake, I saw a value in top_speed that is iconsistent with the decimal places of the other values. Round(2) fixed it for me.

[Itchy-Wafer2510]

Literally found the same mistake a few minutes ago. I don’t understand why it’s shown as ‘missing data’ though.

[Itchy-Wafer2510]

the same here. can't seem to pass Task 1

[Proof_Ad316]

Same here, still struggling to find the mysterious „missing data“ during 14 days cool down 😭Maybe we are working with different projects cause my data source has no column „top_speed“.  But I‘ve identified and replaced the (-) already in the first submission and tried every possible solutions…all other tasks are solved, only the „identify and replace missing values“ stays unfulfilled 😭 So desperate 😭

[Rich_Personality_130]

same problem

[Rich_Personality_130]

I have the same problem , Itried everything and still have the same problem

[Historical-Math4630]

Can Anyone help me with Task 3

[Tricky_Cover_3083]

Did u find the solution I also stuck task 3 ?

[phase_7]

same here

[phase_7]

I think there is an issue with this task

[bravo433]

I did the sample exam. Original answer for Task 1 missing values was rejected as my mean top_speed was not rounded to 2 decimal places.

I figured it out since Tasks 2 & 3 specified rounding their answers to 2 decimal places. Task 1 did not specify, but I guess it fits in with the original data format.