new column in pandas with where logic

Solutions on MaxInterview for new column in pandas with where logic by the best coders in the world

Search
showing results for - "new column in pandas with where logic"
Gilberto
14 Jan 2020
1virtsizes = {
2  "type1": { "gb": 1.2, "xxx": 0, "yyy": 30 },
3  "type2": { "gb": 1.5, "xxx": 2, "yyy": 20  },
4  "type3": { "gb": 2.3, "xxx": 0.1, "yyy": 10  },
5}
6d = {k:v['gb'] for k,v in virtsizes.items()}
7print (d)
8{'type2': 1.5, 'type1': 1.2, 'type3': 2.3}
9
10df = pd.DataFrame({'vol-type':['type1','type2']})
11df["real_size"] = df["vol-type"].map(d)
12print (df)
13  vol-type  real_size
140    type1        1.2
151    type2        1.5
source
similar questions
create the dataframe column based on conditioncreate new dataframe from columns pandassumif in python on a column and create new columnhow to create new dataframe columns from existing columnif in df columnspython conditionally create new column in pandas dataframepandas if else new columnmaking dataframe with named columnpython create new pandas dataframe with specific columnspandas create new column conditional on other columnsselect columns to include in new dataframe in pythoncreate a new column in pandas and assign value with conditionsadd a value to an existing field in pandas dataframe after checking conditionshow to assign a new value in a column in pandas dataframecreate new columns pandas from another columnpandas add value to excel column and saveadd new column based on condition on some other column in pandas pandas create column if equalschange pandas column value based on conditionpandas create a new column based on condition of two columnshow to add a new column to the pandas dfmake a condition statement on column pandaspandas mutate new column
queries leading to this page
create a new column in pandas dataframe using if conditionpandas new column with if statementif clause pandas create new columnpython pandas new column based on conditioncreate new column pandas based on conditioni want to create a new column in the dataframe of true 2ffalse when another column is compared to a conditionnew column pandas based on conditionpandas create new column in place 3dtruecreate a new column with true values in data frame pythoncreate a new column in pandas using if statementnew column in pandas with where logicpandas new column based on conditioncreate a new column in pandas based on conditioncreate a new column that values based on condition pandaspandas new column if statementcreate a new column based on condition pandascreate new column based on condition pandaspandas create new column based on conditionadd new column in pandas dataframe based on a condition pandas new column with conditionif column not in df make column add valuenew column in pandas with where logic