2024-03-28 18:10:38 发布
网友
一个数据帧有三列(HHID,Name,,model)标题。标题如果HHID列对应一个模型值,“model”中的值应该是“Yes”。你知道吗
有人能帮我用python代码吗。你知道吗
附加输入的屏幕截图。你知道吗
输出应为:
你可以试试^{}
hhid _NAME_ model 0 10006 flag4 NaN 1 10014 flag4 NaN 2 10047 flag4 make323 3 10055 flag4 NaN 4 10066 flag4 make268 5 10074 flag4 NaN 6 10085 flag4 NaN 7 10117 flag4 make146 8 10126 flag4 NaN 9 10136 flag4 NaN 10 10147 flag4 make148
>>> pd.get_dummies(df, columns=['model']) hhid _NAME_ model_make146 model_make148 model_make268 model_make323 0 10006 flag4 0 0 0 0 1 10014 flag4 0 0 0 0 2 10047 flag4 0 0 0 1 3 10055 flag4 0 0 0 0 4 10066 flag4 0 0 1 0 5 10074 flag4 0 0 0 0 6 10085 flag4 0 0 0 0 7 10117 flag4 1 0 0 0 8 10126 flag4 0 0 0 0 9 10136 flag4 0 0 0 0 10 10147 flag4 0 1 0 0
>>> # by setting prefix and prefix_sep to empty string >>> # you could make your values as column names >>> pd.get_dummies(df, columns=['model'], prefix='', prefix_sep='') hhid _NAME_ make146 make148 make268 make323 0 10006 flag4 0 0 0 0 1 10014 flag4 0 0 0 0 2 10047 flag4 0 0 0 1 3 10055 flag4 0 0 0 0 4 10066 flag4 0 0 1 0 5 10074 flag4 0 0 0 0 6 10085 flag4 0 0 0 0 7 10117 flag4 1 0 0 0 8 10126 flag4 0 0 0 0 9 10136 flag4 0 0 0 0 10 10147 flag4 0 1 0 0
你可以试试^{}
相关问题 更多 >
编程相关推荐