Pandas Unique Values | Python Pandas Tutorial #11 | Pandas Unique and Nunique Functions

Learn how to work with unique values in a Pandas dataframe, using the Pandas unique() and nunique() functions. You'll learn how to count unique values, generate frequencies of unique values, and count unique values across different columns.
0:00 Introduction
0:30 Pandas Unique Function
1:55 Generate List of Unique Values in Pandas Dataframe Column
3:00 Count Unique Values in Pandas Dataframe Column
3:40 Unique Values Across Multiple Dataframe Columns
4:46 Frequency of Unique Values in Pandas Dataframe
5:20 Pandas nunique Function
6:01 Conclusion
Learn Python programming the right way!
----------------------------------------------------------
✅ Check out my eBook to get started with Python for Data Science: gumroad.com/l/....
✅ Follow me on other platforms:
Website: datagy.io
Twitter: / datagyio
Mailing List: mailchi.mp/f6a.... (and get a FREE Pandas tip and tricks book and a FREE Guide to SQL)

[@jobimathew2842]

I was looking across duplicate values for multiple columns and I finally got the solution!! Thanks a lot!!

[@datagy]

I'm so glad it helped!

[@amirahmadi3025]

very useful. tnx

[@fabriciogouvea9951]

Thank you!!! i am from Brazil

[@datagy]

Thanks for your comment! 😊

[@MrRedef]

Really helpful and straight foward, thank you very much!

[@datagy]

I’m glad it was helpful!

[@sanketsan5409]

thank you. thar was really helpfull

[@datagy]

Thanks Sanket! I’m glad it was helpful.

[@ganderamu5138]

Im getting additional information in while finding unique values for a column in dataset how to fix this

[@abessesmahi4888]

Thank you so much for your efforts Please keep uploading more on Pandas. Subscribed !

[@datagy]

Thank you!! I will have more videos coming soon!

[@ilaydelrey3122]

thank you! maybe you could also publish your notebook to play around, directly :)

[@harshadapatil2854]

bestest video

[@majddabour97]

Thanks a Lot my friend, appreciate your efforts! Looking forward to the next videos ... especially the one About ML algorithms ♥

[@datagy]

Thanks so much! I have some exciting ones planned!

[@CaptainBravo87]

Thanx!

[@datagy]

Thanks Mahmoud, for your comment!

[@brendynford]

Thank you so much for this!!! It was a huge help

[@datagy]

Thank you so much Brendyn!

[@menachemgerst]

how can I create a list or a new df by drop_duplicate on more than one column? like creating a list from the unique() function?

[@datagy]

Hey there! What values would you want the list to contain? Pair-wise values of the unique combinations?

[@TheMISBlog]

Thanks for the tutorial

[@datagy]

Thanks for the comment!

[@PsPFrEaKz95]

Hi im having troubles on printing all the values of a column on my csv file which includes duplicate values. The .unique is good to print a column with all unqiue numbers. I was wondering what do i use to print all values in a column with duplicate values without the numbering column involved

[@datagy]

Hi Fikri, I think you'll need to do a few things: Chances are, there'll be too many records to print so you'll need to enlarge how many rows are printed. This can be done using: pd.set_option('display.max_rows', 500) Where 500 can be replaced by the length of your dataframe. In order to stop printing the index, I believe you can use df.style.hide_index() or print(df.to_csv(sep='\t', index=False)) Hope this helps!

[@PsPFrEaKz95]

@@datagy hello again. My csv file contains 97 rows. as an example of my problem: 0.69999 0.69999 0.69999 102.365 142.536 the pandas .unique just prints out the 1 unique value which is 0.69999 and continues the next unique. what i got printed out with .unique is: 0.69999 102.365 142.536 the 2 missing 0.6999 values are not printed. sry for the long reply

[@datagy]

@@PsPFrEaKz95 Ah ok! Are you looking to just print the whole dataframe? If your dataframe is called df, try just running print(df) If you want to just print a single column, you can use print(df["column name"]) Hope this helps!