\n

High for the third quarter (50% to 75%)

\n

Premium for the last quarter (75% to 100%)

\n\n

Generate these categories and include them in a newly created column named RevenueCategory.

\n

Below is an illustration of what the results might look like:

\n

$\"activity10-answer\"$

","expected_outcome_html":"","has_hint":true,"has_solution":true,"points":1,"custom_number":"","code_input":false,"code_language":"","code_placeholder":"","user_status":"$48"} 4c:{"stderr":"","stdout":"","success":true} 4b:{"is_passed":true,"submitted_answer":"$4c","submitted_answer_at":"2023-11-02T10:33:44.404283Z","hint_requested":false,"hint_requested_at":null,"solution_requested":false,"solution_requested_at":null,"reactions":null} 4a:{"id":"b8626c5f-619d-4fa5-b9e9-ad994e89b3d8","activity_type":"code_validated","order":9,"title_html":"

Analyze Reorder Quantities: Segregate the 'Reorder Quantity (liters/kg)' Into Four Sections - Low, Medium, High, Very High

","content_html":"

To optimize reorder amounts for various dairy products, characterize the 'Reorder Quantity (liters/kg)' column into four categories: Low, Medium, High, and Very High.

\n

The outcome should be saved in a new column known as 'ReorderCategory'. Detailed information on how to categorize would look like this:

\n

'Low' refers to the first quarter of reorder quantities (first 25%).
'Medium' implies the second quarter (25% to 50%).
'High' comprises the third quarter (50% to 75%).
'Very High' represents the fourth quarter (75% to 100%).

\n

Please see the preview below:

\n

$\"activity11-answer\"$

","expected_outcome_html":"","has_hint"

Statement of Completion#c20cd94a

Data Wrangling with Pandas

From Continuous to Categorical: Data Wrangling with Dairy Sales data