Untitled
unknown
plain_text
2 years ago
418 B
4
Indexable
import pandas as pd # create sample data data = { 'id': ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'], 'industry': ['X', 'X', 'Y', 'Y', 'Y', 'Z', 'Z', 'Z'], 'rank': [1, 2, 1, 2, 3, 1, 2, 3] } df = pd.DataFrame(data) # calculate rank percentage by industry df['rank_percentage'] = df.groupby('industry')['id'].transform(lambda x: df.loc[x.index, 'rank'] / len(x)) # output the result print(df)
Editor is loading...