Two Lists, Sorted Apart

Problem

An auction tool keeps a DataFrame `auction_book` (loaded from a CSV) with columns `(low_bid, high_bid)`. There is no key and the table may contain duplicate values.

Produce a two-column result that sorts each column independently and lines them up row by row:
1. `low_bid` sorted ascending.
2. `high_bid` sorted descending.
3. The two sorted sequences placed side by side (smallest `low_bid` beside largest `high_bid`, and so on).

The columns are sorted separately, so values that shared a source row are not kept together.

Input data

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 4 rows with the columns low_bid, high_bid.

Starter code (Pandas (Python))

import pandas as pd

def two_lists_sorted_apart(auction_book) -> pd.DataFrame:
    # Your code here
    return auction_book

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