/Python/New column in pandas with where logic

New column in pandas with where logic

virtsizes = {
  "type1": { "gb": 1.2, "xxx": 0, "yyy": 30 },
  "type2": { "gb": 1.5, "xxx": 2, "yyy": 20  },
  "type3": { "gb": 2.3, "xxx": 0.1, "yyy": 10  },
}
d = {k:v['gb'] for k,v in virtsizes.items()}
print (d)
{'type2': 1.5, 'type1': 1.2, 'type3': 2.3}

df = pd.DataFrame({'vol-type':['type1','type2']})
df["real_size"] = df["vol-type"].map(d)
print (df)
  vol-type  real_size
0    type1        1.2
1    type2        1.5

Source: stackoverflow.com

Similar codes

0 vote336 views1 answer
Cast image to float32
Python
2 votes330 views1 answer
Python private variables
Python
0 vote363 views2 answers
User logout in django rest framework
Python Django
0 vote324 views1 answer
Remove stopwords from list of strings python
Python
0 vote360 views1 answer
"api_view" is not defined django
Python Django
10 votes344 views4 answers
Check the role of user in on_message discord.py
Python
2 votes351 views2 answers
Python program to find first n prime numbers
Python
14 votes476 views3 answers
Flask link stylesheet
Python Flask
42 votes344 views6 answers
Python regex
Python
5 votes346 views2 answers
Matplotlib background color
Python