frequency table in python

Question

I have a continuous value Tone. How do I create a frequency table from the dataframe?

dataframe.Tone = [-0.9, -0.8, -0.6, -0.3, -0.2, 0, 0.1, 0.2, 0.4, 0.7, 1.2, 1.3, 1.4]`

resultDF:

class interval | frequency 
(-1.0) - (-0.6) | 3
(-0.5) - (-0.1) | 2
   0   -  0.4   | 4
  0.5  -  0.9   | 1
   1   -  1.4   | 3

BENY · Accepted Answer · 2018-12-13 02:26:22Z

2

IIUC using cut

pd.cut(l,[-1,-0.6,-0.1,0.4,0.9,1.4]).value_counts()
(-1.0, -0.6]    3
(-0.6, -0.1]    2
(-0.1, 0.4]     4
(0.4, 0.9]      1
(0.9, 1.4]      3
dtype: int64

answered Dec 13, 2018 at 2:26

BENY

324k22 gold badges176 silver badges250 bronze badges

Sign up to request clarification or add additional context in comments.

9 Comments

Ruzannah Over a year ago

how to automatically change the class interval range? without defining [-1,-0.6,-0.1,0.4,0.9,1.4]. range = 0.4

It_is_Chris Over a year ago

@Ruzannah the second param of cut can be an int which is the number of bins you want

BENY Over a year ago

@Ruzannah something like pd.cut(l,np.arange(-1,1.4+0.5,0.4)).value_counts()

Ruzannah Over a year ago

how about float ?

BENY Over a year ago

@Ruzannah what you mean float ?

|

Collectives™ on Stack Overflow

frequency table in python

1 Answer 1

9 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

9 Comments

Your Answer

Sign up or log in

Post as a guest

Related