- 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
Python Pandas - Display unique values present in each column
To display unique values in each column, use the unique() method and set the column within it. At first, import the required library −
import pandas as pd
Create a DataFrame with two columns and duplicate records −
dataFrame = pd.DataFrame( { "Student": ['Jack', 'Robin', 'Ted', 'Robin', 'Scarlett', 'Kat', 'Ted'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'] } )
Find unique values by setting each column in the unique() method −
resStudent = pd.unique(dataFrame.Student) resResult = pd.unique(dataFrame.Result)
Example
Following is the code −
import pandas as pd # Create DataFrame dataFrame = pd.DataFrame( { "Student": ['Jack', 'Robin', 'Ted', 'Robin', 'Scarlett', 'Kat', 'Ted'],"Result": ['Pass', 'Fail', 'Pass', 'Fail', 'Pass', 'Pass', 'Pass'] } ) print"DataFrame ...\n",dataFrame # finding unique values resStudent = pd.unique(dataFrame.Student) resResult = pd.unique(dataFrame.Result) print"\nUnique values in Student Column", resStudent print"\nUnique values in Result Column", resResult
Output
This will produce the following output −
DataFrame ... Result Student 0 Pass Jack 1 Fail Robin 2 Pass Ted 3 Fail Robin 4 Pass Scarlett 5 Pass Kat 6 Pass Ted Unique values in Student Column ['Jack' 'Robin' 'Ted' 'Scarlett' 'Kat'] Unique values in Result Column ['Pass' 'Fail']
Advertisements