Skip to main content
Back to problems
#2159
Medium Database

Order two columns independently

Database
61.6% acceptance
Mar 31, 2026
79
19

No description available.

Solution

Pandas
Time O(1)
Space O(1)
LeetCode
solution.pandas
# Table: Data
# 
# +-------------+------+
# | Column Name | Type |
# +-------------+------+
# | first_col   | int  |
# | second_col  | int  |
# +-------------+------+
# This table may contain duplicate rows.
# 
#  
# 
# Write a solution to independently:
# 
# order first_col in ascending order.
# 
# order second_col in descending order.
# 
# The result format is in the following example.
#
# Example 1:
# Input:
# Data table:
# +-----------+------------+
# | first_col | second_col |
# +-----------+------------+
# | 4         | 2          |
# | 2         | 3          |
# | 3         | 1          |
# | 1         | 4          |
# +-----------+------------+
# Output:
# +-----------+------------+
# | first_col | second_col |
# +-----------+------------+
# | 1         | 4          |
# | 2         | 3          |
# | 3         | 2          |
# | 4         | 1          |
# +-----------+------------+

import pandas as pd

def order_two_columns(data: pd.DataFrame) -> pd.DataFrame:
  return pd.DataFrame({
    'first_col': data['first_col'].sort_values(ascending=True).values,
    'second_col': data['second_col'].sort_values(ascending=False).values
  })