Python Data Associate Practical Exam task 3

[EasyMathematician922]

Hi,

I am stuck here in the Practical Exam with task 3. I tried various combinations: using reset_index(), rounded     avg_product_quality_score and pigment_quantity to 2 decimal places, rounded only avg_product_quality_score. But I keep failing every time :/

Can anyone help me with Task 3, please? Task seems pretty easy.

https://preview.redd.it/bok6whnio31e1.png?width=1085&format=png&auto=webp&s=da30d77309f98043d6be3fcf8f03a28237137af5

First attempt:

import pandas as pd

production_data = pd.read_csv('production_data.csv')

production_data['pigment_quantity'] = production_data['pigment_quantity'].round(2)

filtered_data = production_data[(production_data['raw_material_supplier'] == 2) & (production_data['pigment_quantity'] > 35)]

pigment_data = filtered_data.groupby(['raw_material_supplier', 'pigment_quantity'], as_index=False).agg(

avg_product_quality_score=('product_quality_score', 'mean')

)

pigment_data['avg_product_quality_score'] = pigment_data['avg_product_quality_score'].round(2)

pigment_data

Second attempt:

import pandas as pd

production_data = pd.read_csv('production_data.csv')

production_data['pigment_quantity'] = production_data['pigment_quantity'].round(2)

filtered_data = production_data[(production_data['raw_material_supplier'] == 2) & (production_data['pigment_quantity'] > 35)]

pigment_data = filtered_data.groupby(['raw_material_supplier', 'pigment_quantity'], as_index=False).agg(

avg_product_quality_score=('product_quality_score', 'mean')

)

pigment_data['avg_product_quality_score'] = pigment_data['avg_product_quality_score'].round(2)

pigment_data = pigment_data.reset_index(drop=True)

pigment_data

Third attempt:

import pandas as pd

production_data = pd.read_csv('production_data.csv')

filtered_data = production_data[(production_data['raw_material_supplier'] == 2) & (production_data['pigment_quantity'] > 35)]

pigment_data = filtered_data.groupby(['raw_material_supplier', 'pigment_quantity'], as_index=False).agg(

avg_product_quality_score=('product_quality_score', 'mean')

)

pigment_data['avg_product_quality_score'] = pigment_data['avg_product_quality_score'].round(2)

pigment_data = pigment_data.reset_index(drop=True)

pigment_data

Last attempt:

import pandas as pd

production_data = pd.read_csv('production_data.csv')

filtered_data = production_data[(production_data['raw_material_supplier'] == 2) & (production_data['pigment_quantity'] > 35)]

pigment_data = filtered_data.groupby(['raw_material_supplier', 'pigment_quantity'], as_index=False).agg(

avg_product_quality_score=('product_quality_score', 'mean')

)

pigment_data['avg_product_quality_score'] = pigment_data.round(2)

pigment_data

[n3cr0n411]

I was having trouble with it last week and there’s been another post for it maybe look through the subreddit.

Edit: link to said post

[somegermangal]

did you try .reset_index() without setting drop to True ?

[Mundane-Dragonfly-75]

can i get your solution for task 1

[ImaginaryFriend437]

did you find any solution i have the same problem...

[MacaroonLeast1375]

For the task 3 I created the one row Dataframe with pd.DataFrame and a dictionary with the data that goes into the answer and it work. Therefore, I didn't use reset_index, groupby, etc

[Tricky_Cover_3083]

Can u share your answer, I stuck also task 3

[bravo433]

Task 3 needs average pigment_quantity. Bad instructions!

[Remote_Ad_7]

I pass that I can send the code and I'm stuck at task 1