3

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?

bad_coder
  • 8,684
  • 19
  • 37
  • 59
xceej
  • 59
  • 1
  • 6

2 Answers2

5

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.

Corralien
  • 70,617
  • 7
  • 16
  • 36
2

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

venkatesh
  • 102
  • 2
  • 6