#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)
# 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
})