Counting values from multiple columns Pandas

Question

I have a random data set which is the 2018/2019 football season

data = pd.DataFrame({'HomeTeam': ['Marseille', 'Toulouse', 'Angers', 'Nimes','Paris'...], 'FTR': ["H", "A", "D"],'FTRNUM': ["1", "2", "3"]})

I made 'FTRNUM' to get a number according to FTR : 1 equals to ['FTR' = 'H'] 2 equals to ['FTR' = 'A'] and 3 equals to ['FTR' = 'D']

dataset

I'm trying to make random statistics with it.

How can I get for exemple the win number of a specific team in ['HomeTeam'] according to ['FTR'] or ['FTRNUM']. (FTR = Full Time Result).

I'm doing it with :

data9 = data.groupby('HomeTeam')['FTRNUM'].value_counts().to_frame() data9

And adding it manually with number but How can I simply catch this number instead of adding it manually ?

The value would be for everything in HomeTeam How many time Paris SG appears with FTR = "H".

The final result would be something like this

n_matchwinPSGDOM = 17 win_ratewinPSGDOM = (float(n_matchwinPSGDOM) / (n_paris)) * 100 print ("PARIS won Home {:.2f}%".format(win_ratewinPSGDOM),"matchs")

But not with a manually 17.

I will appreciate your help.

B

Hello, please provide a reproducible example. The screenshot is not reproducible. — Steele Farnsworth
– Steele Farnsworth, Commented Nov 14, 2021 at 20:53

Steele Farnsworth · Accepted Answer · 2021-11-14 20:57:18Z

1

home_paris: int = data['HomeTeam'].value_counts().get('Paris SG') away_paris: int = data['AwayTeam'].value_counts().get('Paris SG') total_paris = home_paris + away_paris

Please let me know if this is not what was wanted.

answered Nov 14, 2021 at 20:57

Steele Farnsworth

9131 gold badge7 silver badges17 bronze badges

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

3 Comments

Bruno93600 Over a year ago

Thanks ! But this one gave me the number of matchs played by Paris as I did with : n_paris = len(data[data.HomeTeam == 'Paris SG']) n_paris2= len(data[data.AwayTeam == 'Paris SG']) n_PSG = n_paris + n_paris2 I need to catch the number of win that we can have according to 'FTR' (H= HomeTeam won, A=AwayTeam won, D= Draw)

Steele Farnsworth Over a year ago

I am sorry that this does not answer the question. I am happy to further assist once you provide a reproducible example per the instructions in my comment to the original post.

Bruno93600 Over a year ago

I actualized it, please let me know if what you get is now fine. B

Collectives™ on Stack Overflow

Counting values from multiple columns Pandas

1 Answer 1

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Linked

Related