我正在为机器学习准备数据,数据在数据框中,如下所示:
Column v1 v2
first 1 2
second 3 4
third 5 6
现在我想把它变成:
Column v1 v2 first-v1 first-v2 second-v1 econd-v2 third-v1 third-v2
first 1 2 1 2 Nan Nan Nan Nan
second 3 4 Nan Nan 3 4 Nan Nan
third 5 6 Nan Nan Nan Nan 5 6
我试着这样做:
# we know how many values there are but
# length can be changed into length of [1, 2, 3, ...] values
values = ['v1', 'v2']
# data with description from above is saved in data
for value in values:
data[ str(data['Column'] + '-' + value)] = data[ value]
结果是名称为的列:
['first-v1' 'second-v1'..], ['first-v2' 'second-v2'..]
有正确值的地方。我做错了什么?因为我的数据很大,有没有更理想的方法?你知道吗
谢谢你的时间!你知道吗
您可以将^{} 用于交换和排序
MultiIndex
列:或^{} +^{} :
最后
join
到原始:相关问题 更多 >
编程相关推荐