Pandas bins dummy

df['ageD'], bins = pd.qcut(df.iloc[:, 0], 2, retbins=True)
left = (df["age"].values <= bins[:,None]).T.astype(int)
dl = pd.DataFrame(left, columns=["(-inf, {}]".format(b) for b in bins])
dr = pd.DataFrame(1-left, columns=["({}, +inf)".format(b) for b in bins])
dout = pd.concat([pd.get_dummies(df), dl, dr], axis=1)

Source: stackoverflow.com

Pandas bins dummy

>>> dout
   age  ageD_[5, 30]  ageD_(30, 70]  (-inf, 5]  (-inf, 30]  (-inf, 70]  (5, +inf)  (30, +inf)  (70, +inf)
0    5             1              0          1           1           1          0           0           0
1   23             1              0          0           1           1          1           0           0
2   43             0              1          0           0           1          1           1           0
3   70             0              1          0           0           1          1           1           0
4   30             1              0          0           1           1          1           0           0

Source: stackoverflow.com

Similar codes

1 vote279 views2 answers
Assign multiline string to variable in python
Python
7 votes252 views4 answers
'numpy.ndarray' object is not callable
Python
8 votes287 views1 answer
Input stdin python
Python
-1 vote301 views1 answer
Modin python
Python
0 vote281 views1 answer
Python decorator *args **kwargs
Python
0 vote329 views1 answer
Python list of dictionaries to excel
Python
6 votes287 views3 answers
Python open folder
Python
0 vote293 views1 answer
How to group multiple test in pytest
Python
2 votes262 views1 answer
How to separate a string or int with comma in python
Python
1 vote307 views2 answers
Python write request must be str not bytes
Python