Last Crate Loaded on the Delivery Van

Problem

You are given a DataFrame `loadingline` loaded from `loadingline.csv` with columns `crate_id`, `label`, `mass_kg`, and `load_order`. Crates are loaded onto a delivery van one at a time in increasing `load_order` (values are unique).

The van can carry at most **1000 kg**. Loading proceeds in `load_order`; as soon as adding the next crate would push the running total above 1000 kg, loading stops and no further crate is loaded. Return a one-row DataFrame with a single column `label` holding the label of the last crate that actually makes it onto the van.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 1 row with the columns label.

Starter code (Pandas (Python))

import pandas as pd

def last_crate(loadingline) -> pd.DataFrame:
    # Your code here
    return loadingline

Related Pandas questions

• 7-Day Rolling Signup AverageMedium
• Accounts Streaming From Two Devices at OnceMedium
• Agent Resolution RateMedium
• Agents With a Dominant Contact ChannelMedium
• Airbnb Popularity Bucket PricingMedium
• Amazon Unique Shipments per MonthMedium