Home » Solar Destinations Hub » Python - Valuecounts() Method - Display All Results [Duplicate]

Python - Valuecounts() Method - Display All Results [Duplicate]

Sarah Jenkins • • 1 min read
Python - Valuecounts() Method - Display All Results [Duplicate]

I am a complete novice when it comes to Python so this might be badly explained.

I have a pandas dataframe with 2485 entries for years from 1960-2020. I want to know how many entries there are for each year, which I can easily get with the .value_counts() method. My issue is that when I print this, the output only shows me the top 5 and bottom 5 entries, rather than the number for every year. Is there a way to display all the value counts for all the years in the DataFrame?

0

2 Answers

Use pd.set_options and set display.max_rows to None:

>>> pd.set_option("display.max_rows", None)

Now you can display all rows of your dataframe.

0

If suppose the name of dataframe is 'df' then use

counts = df.year.value_counts()
counts.to_csv('name.csv',index=false)

As our terminal can't display entire columns they just display the top and bottom by collapsing the remaining values so try saving in a csv and see the records

Sarah Jenkins
Author

Sarah Jenkins

Sarah Jenkins is a veteran tech journalist with over 12 years of experience covering artificial intelligence, mobile innovations, and digital ethics. Her insights have appeared in leading technology publications worldwide.