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 Year's from 1960-2020. I Want...
![Python - Valuecounts() Method - Display All Results [Duplicate]](https://www.alledaags.nl/uploads/python-valuecounts-method-display-all-results-duplicate_1200.jpg)
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?
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.
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 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.
