How to Sort a CSV by a Specific Column in Descending Order Using Python pandas

A user asked how to sort a CSV file by a specific column while keeping the header unchanged.

Solution

The following pandas code reads the CSV, sorts by the "总价" column in descending order, resets the index, and saves the result to a new file.

import pandas as pd
# Adjust encoding as needed
df = pd.read_csv("test.csv", encoding="gbk")
print(df.head())
# Sort by "总价" column descending
df = df.sort_values(by=["总价"], ascending=[False], ignore_index=True)
print(df.head())
# Save to new CSV without the index
df.to_csv("test2.csv", index=False)

Additional notes: df.sort_values(col2, ascending=False) sorts by a single column, while df.sort_values([col1, col2], ascending=[True, False]) allows multi‑column sorting with different orders.

Summary

The article demonstrates a straightforward pandas approach to reorder CSV rows based on a chosen column, providing a practical example that can be directly applied to similar automation tasks.