/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

4 votes225 views5 answers
Python Fibonacci function
Python
1 vote208 views1 answer
How to find the length of a list in scratch
Python
0 vote228 views1 answer
Np print precision
Python
0 vote196 views2 answers
How to store data in python
Python
1 vote241 views1 answer
Python convert html to text
Python
1 vote208 views1 answer
How to search where a character is in an array in python
Python
1 vote215 views1 answer
Pandas new column from others
Python
0 vote206 views1 answer
How to loadh5 file in python
Python
7 votes192 views2 answers
How to get something from a certian possition in a list python
Python
2 votes203 views8 answers
Codegrepper
Python