Creating a frequency distribution table in Python

Question

I'm new to Python and Pandas, and i'm struggling to create a frequency distribution table form my df.

My dataframe is something like this:

Balances	Weight
10	7
11	15
12	30
13	20
10	15
13	20

edit: The balance numbers are its respective ID

I need the frequency of each balance used (in this example, balance 10 would be 2 and so on) the min, max and mean of the measurements results.

I was to use df.groupby(['balances']) but how can i use the results form using df.groupby to creat a new table? Is that the way?

df.groupby('Balances').describe() (or df.groupby('Balances')['Weight'].describe()) will give you a lot of information for every column within the group — ALollz
– ALollz, Commented Apr 7, 2021 at 15:14
With this i can create a new df based on the values given by .describe, right? — Croyd
– Croyd, Commented Apr 7, 2021 at 18:31
Yes, if you assign it to something: df1 = df.groupby('Balances').describe(), then you have a DataFrame (with a column Multiindex) that you can select from or whatever — ALollz
– ALollz, Commented Apr 7, 2021 at 19:04

Mayank Porwal · Accepted Answer · 2021-04-07 15:20:24Z

7

You don't need to use groupby, instead use Series.value_counts:

In [1619]: df.Balances.value_counts()
Out[1619]: 
10    2
13    2
11    1
12    1
Name: Balances, dtype: int64

To create another df, do this:

In [1628]: df1 = df.Balances.value_counts().reset_index(name='Frequency').rename(columns={'index':'Balances'})

In [1629]: df1
Out[1629]: 
   Balances  Frequency
0        10          2
1        13          2
2        11          1
3        12          1

answered Apr 7, 2021 at 15:20

Mayank Porwal

34.2k9 gold badges45 silver badges65 bronze badges

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

3 Comments

Croyd Over a year ago

and to add the min, max and mean i would follow the same logic?

Mayank Porwal Over a year ago

For that you'll have to use groupby.

Croyd Over a year ago

actually that is not what i needed, it helped a bit tho. But thanks

cegarza · Accepted Answer · 2021-04-07 15:16:31Z

1

df.groupby(['balances']).count() should solve what you're looking for

answered Apr 7, 2021 at 15:16

cegarza

1358 bronze badges

Comments

Ken Galinato · Accepted Answer · 2024-11-15 05:52:50Z

-1

Class Interval f x (Midpoint) cf rf% <cf% fx 0 32-36 4 34 4 5.71 5.71 136 1 37-41 8 39 12 11.43 17.14 312 2 42-46 15 44 27 21.43 38.57 660 3 47-51 19 49 46 27.14 65.71 931 4 52-56 11 54 57 15.71 81.43 594 Class Interval f x (Midpoint) cf rf% <cf% fx 0 32-36 4 34 4 5.71 5.71 136 1 37-41 8 39 12 11.43 17.14 312 2 42-46 15 44 27 21.43 38.57 660 3 47-51 19 49 46 27.14 65.71 931 4 52-56 11 54 57 15.71 81.43 594successI've completed and displayed the frequency distribution table with all calculated columns. Let me know if you have questions or need further calculations, such as solving for the mean, median, mode, or creating graphs

answered Nov 15, 2024 at 5:52

Ken Galinato

1

1 Comment

reechard Over a year ago

please mark code with "Code sample" markup (Ctrl-K). The formatting is quite bad, it doesn't even look like python!

Collectives™ on Stack Overflow

Creating a frequency distribution table in Python

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related