- Data Structure
- Networking
- RDBMS
- Operating System
- Java
- MS Excel
- iOS
- HTML
- CSS
- Android
- Python
- C Programming
- C++
- C#
- MongoDB
- MySQL
- Javascript
- PHP
- Physics
- Chemistry
- Biology
- Mathematics
- English
- Economics
- Psychology
- Social Studies
- Fashion Studies
- Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Sort CSV by a single column in Python ?
To sort CSV by a single column, use the sort_values() method. Set the column using which you want to sort in the sort_values() method.
At first, let’s read our CSV file “SalesRecords.csv”with DataFrame −
dataFrame = pd.read_csv("C:\Users\amit_\Desktop\SalesRecords.csv")
Sort according to a single column “Car” −
dataFrame.sort_values("Car", axis=0, ascending=True,inplace=True, na_position='first')
Next, sort according to a single column “Reg_Price” −
dataFrame.sort_values("Reg_Price", axis=0, ascending=True,inplace=True, na_position='first')
Example
Following is the code
import pandas as pd # DataFrame to read our input CS file dataFrame = pd.read_csv("C:\Users\amit_\Desktop\SalesRecords.csv") print("\nInput CSV file = \n", dataFrame) # sorting according to Car column dataFrame.sort_values("Car", axis=0, ascending=True,inplace=True, na_position='first') print("\nSorted CSV file (according to Car Names) = \n", dataFrame) # sorting according to Reg_Price column dataFrame.sort_values("Reg_Price", axis=0, ascending=True,inplace=True, na_position='first') print("\nSorted CSV file (according to Registration Price) = \n", dataFrame)
Output
This will produce the following output
Input CSV file = Car Date_of_Purchase Reg_Price 0 BMW 10/10/2020 1000 1 Audi 10/12/2020 750 2 Lexus 10/17/2020 1250 3 Jaguar 10/16/2020 1500 4 Mustang 10/19/2020 1100 5 Lamborghini 10/22/2020 1000 Sorted CSV file (according to Car Names) = Car Date_of_Purchase Reg_Price 1 Audi 10/12/2020 750 0 BMW 10/10/2020 1000 3 Jaguar 10/16/2020 1500 5 Lamborghini 10/22/2020 1000 2 Lexus 10/17/2020 1250 4 Mustang 10/19/2020 1100 Sorted CSV file (according to Registration Price) = Car Date_of_Purchase Reg_Price 1 Audi 10/12/2020 750 0 BMW 10/10/2020 1000 5 Lamborghini 10/22/2020 1000 4 Mustang 10/19/2020 1100 2 Lexus 10/17/2020 1250 3 Jaguar 10/16/2020 1500
Advertisements