/Python/Add a new categorical column to an existing table python

Add a new categorical column to an existing table python

d = df.groupby('Item_Identifier')['Sales'].mean().to_dict()
print (d)
{'Beef': 3030.0, 'Milk': 1233.3333333333333, 'Tea': 150.0}

print (df['Item_Identifier'].map(d))
0    1233.333333
1    1233.333333
2    1233.333333
3    3030.000000
4    3030.000000
5     150.000000
6     150.000000
7     150.000000
Name: Item_Identifier, dtype: float64

bins = [df['Sales'].min(),500, 1500, df['Sales].max()]
labels=['low','medium','high']
df['Price Category'] = pd.cut(df['Item_Identifier'].map(d), bins=bins, labels=labels)
print (df)
  Item_Identifier  Sales Price Category
0            Milk    500         medium
1            Milk   1200         medium
2            Milk   2000         medium
3            Beef     60           high
4            Beef   6000           high
5             Tea    150            low
6             Tea    100            low
7             Tea    200            low

Source: stackoverflow.com

Similar codes

0 vote179 views1 answer
How to put 2 code n 1 line in python
Python
3 votes191 views2 answers
Pandas check length of string
Python
26 votes190 views5 answers
Python square root
Python
0 vote174 views1 answer
Change date format python code
Python
0 vote212 views1 answer
Ignore transformers warning
Python
0 vote256 views2 answers
Types of methods in oop python
Python
0 vote147 views1 answer
Django admin date format
Python
0 vote171 views1 answer
Def batting(balls,runs): points=runs/2; if runs>50: points=points+5; if runs>=100: points=points+10; strikerate=runs/balls; if strikerate>=80 and strikerate<=100: points=points+2; elif strikerate>100: points=points+4; print(points)
Python
1 vote184 views2 answers
Python file open try except error
Python
0 vote203 views1 answer
Sns multiple distributions
Python