Config Router

  • Google Sheets
  • CCNA Online training
    • CCNA
  • CISCO Lab Guides
    • CCNA Security Lab Manual With Solutions
    • CCNP Route Lab Manual with Solutions
    • CCNP Switch Lab Manual with Solutions
  • Juniper
  • Linux
  • DevOps Tutorials
  • Python Array
You are here: Home / Find the unique values in a column and then sort them

Find the unique values in a column and then sort them

August 20, 2021 by James Palmer

sorted(iterable): Return a new sorted list from the items in iterable.
CODE
import pandas as pd
df = pd.DataFrame({‘A’:[1,1,3,2,6,2,8]})
a = df[‘A’].unique()
print(sorted(a))

OUTPUT
[1, 2, 3, 6, 8]

sort sorts inplace so returns nothing:
In [54]:
df = pd.DataFrame({‘A’:[1,1,3,2,6,2,8]})
a = df[‘A’].unique()
a.sort()
a

Out[54]:
array([1, 2, 3, 6, 8], dtype=int64)

So you have to call print a again after the call to sort.
Eg.:
In [55]:
df = pd.DataFrame({‘A’:[1,1,3,2,6,2,8]})
a = df[‘A’].unique()
a.sort()
print(a)

[1 2 3 6 8]

Related

Filed Under: Uncategorized

Recent Posts

  • How do I give user access to Jenkins?
  • What is docker volume command?
  • What is the date format in Unix?
  • What is the difference between ARG and ENV Docker?
  • What is rsync command Linux?
  • How to Add Music to Snapchat 2021 Android? | How to Search, Add, Share Songs on Snapchat Story?
  • How to Enable Snapchat Notifications for Android & iPhone? | Steps to Turn on Snapchat Bitmoji Notification
  • Easy Methods to Fix Snapchat Camera Not Working Black Screen Issue | Reasons & Troubleshooting Tips to Solve Snapchat Camera Problems
  • Detailed Procedure for How to Update Snapchat on iOS 14 for Free
  • What is Snapchat Spotlight Feature? How to Make a Spotlight on Snapchat?
  • Snapchat Hack Tutorial 2021: Can I hack a Snapchat Account without them knowing?

Copyright © 2025 · News Pro Theme on Genesis Framework · WordPress · Log in