Q8a: sort_values Specifically, df is currently sorted in alphabetical order by competitor name (candy). What if we were most curious about the sugar percentile of where the candy falls within the...

Use python to solve the following

Extracted text: Q8a: sort_values Specifically, df is currently sorted in alphabetical order by competitor name (candy). What if we were most curious about the sugar percentile of where the candy falls within the dataset? Arrange the rows in df such that the candy with the highest sugarpercent is displayed first and the lowest sugarpercent last. Store this in df. Also, note that when using sort_values , the original indices are retained. So, also reset the index of df so that the highest sugarpercent candy is index 0. I # YOUR CODE HERE df df.sort_values (by=['sugarpercent'], inplace True) %3D I assert df.loc[0,'competitorname'] != '100 Grand' assert np.allclose(df.loc[0,'sugarpercent'], 0.988) AttributeError Traceback (most recent call last) in -> 1 assert df.loc[0,'competitorname'] != '100 Grand' 2 assert np.allclose(df.loc[0,'sugarpercent'], 0.988) --- AttributeError: 'NoneType' object has no attribute 'loc'