python – 将两个不同数据帧中每行的值相乘
发布时间：2020-12-20 12:04:18 所属栏目：Python 来源：网络整理
导读：我正在构建遗传算法以在 python中进行特征选择.我从我的数据中提取了特征,然后我分成了两个数据帧,“训练”和“测试”数据帧. 如何将“填充”数据框(每个单独)和“训练”数据框中的每一行的值复用？ ‘火车’数据帧： feature0 feature1 feature2 feature3 f
|
我正在构建遗传算法以在
python中进行特征选择.我从我的数据中提取了特征,然后我分成了两个数据帧,“训练”和“测试”数据帧.
如何将“填充”数据框(每个单独)和“训练”数据框中的每一行的值复用？ ‘火车’数据帧： feature0 feature1 feature2 feature3 feature4 feature5 0 18.279579 -3.921346 13.611829 -7.250185 -11.773605 -18.265003 1 17.899545 -15.503942 -0.741729 -0.053619 -6.734652 4.398419 4 16.432750 -22.490190 -4.611659 -15.247781 -13.941488 -2.433374 5 15.905368 -4.812785 18.291712 3.742221 3.631887 -1.074326 6 16.991823 -15.946251 8.299577 8.057511 8.057510 -1.482333 ‘人口’数据框： 0 1 2 3 4 5 0 1 1 0 0 0 1 1 0 1 0 1 0 0 2 0 0 0 0 0 1 3 0 0 1 0 1 1 将’population’中的每一行乘以’train’中的所有行. 1)从人口第1行： feature0 feature1 feature2 feature3 feature4 feature5 0 18.279579 -3.921346 0 0 0 -18.265003 1 17.899545 -15.503942 0 0 0 4.398419 4 16.432750 -22.490190 0 0 0 -2.433374 5 15.905368 -4.812785 0 0 0 -1.074326 6 16.991823 -15.946251 0 0 0 -1.482333 2)从人口第2行： feature0 feature1 feature2 feature3 feature4 feature5 0 0 -3.921346 0 -7.250185 0 0 1 0 -15.503942 0 -0.053619 0 0 4 0 -22.490190 0 -15.247781 0 0 5 0 -4.812785 0 3.742221 0 0 6 0 -15.946251 0 8.057511 0 0 等等… 解决方法
如果需要循环(如果大数据则缓慢)：
for i,x in population.iterrows():
print (train * x.values)
feature0 feature1 feature2 feature3 feature4 feature5
0 18.279579 -3.921346 0.0 -0.0 -0.0 -18.265003
1 17.899545 -15.503942 -0.0 -0.0 -0.0 4.398419
4 16.432750 -22.490190 -0.0 -0.0 -0.0 -2.433374
5 15.905368 -4.812785 0.0 0.0 0.0 -1.074326
6 16.991823 -15.946251 0.0 0.0 0.0 -1.482333
feature0 feature1 feature2 feature3 feature4 feature5
0 0.0 -3.921346 0.0 -7.250185 -0.0 -0.0
1 0.0 -15.503942 -0.0 -0.053619 -0.0 0.0
4 0.0 -22.490190 -0.0 -15.247781 -0.0 -0.0
5 0.0 -4.812785 0.0 3.742221 0.0 -0.0
6 0.0 -15.946251 0.0 8.057511 0.0 -0.0
feature0 feature1 feature2 feature3 feature4 feature5
0 0.0 -0.0 0.0 -0.0 -0.0 -18.265003
1 0.0 -0.0 -0.0 -0.0 -0.0 4.398419
4 0.0 -0.0 -0.0 -0.0 -0.0 -2.433374
5 0.0 -0.0 0.0 0.0 0.0 -1.074326
6 0.0 -0.0 0.0 0.0 0.0 -1.482333
feature0 feature1 feature2 feature3 feature4 feature5
0 0.0 -0.0 13.611829 -0.0 -11.773605 -18.265003
1 0.0 -0.0 -0.741729 -0.0 -6.734652 4.398419
4 0.0 -0.0 -4.611659 -0.0 -13.941488 -2.433374
5 0.0 -0.0 18.291712 0.0 3.631887 -1.074326
6 0.0 -0.0 8.299577 0.0 8.057510 -1.482333
或者每行分开： print (train * population.values[0])
feature0 feature1 feature2 feature3 feature4 feature5
0 18.279579 -3.921346 0.0 -0.0 -0.0 -18.265003
1 17.899545 -15.503942 -0.0 -0.0 -0.0 4.398419
4 16.432750 -22.490190 -0.0 -0.0 -0.0 -2.433374
5 15.905368 -4.812785 0.0 0.0 0.0 -1.074326
6 16.991823 -15.946251 0.0 0.0 0.0 -1.482333
或者对于MultiIndex DataFrame： d = pd.concat([train * population.values[i] for i in range(population.shape[0])],keys=population.index.tolist())
print (d)
feature0 feature1 feature2 feature3 feature4 feature5
0 0 18.279579 -3.921346 0.000000 -0.000000 -0.000000 -18.265003
1 17.899545 -15.503942 -0.000000 -0.000000 -0.000000 4.398419
4 16.432750 -22.490190 -0.000000 -0.000000 -0.000000 -2.433374
5 15.905368 -4.812785 0.000000 0.000000 0.000000 -1.074326
6 16.991823 -15.946251 0.000000 0.000000 0.000000 -1.482333
1 0 0.000000 -3.921346 0.000000 -7.250185 -0.000000 -0.000000
1 0.000000 -15.503942 -0.000000 -0.053619 -0.000000 0.000000
4 0.000000 -22.490190 -0.000000 -15.247781 -0.000000 -0.000000
5 0.000000 -4.812785 0.000000 3.742221 0.000000 -0.000000
6 0.000000 -15.946251 0.000000 8.057511 0.000000 -0.000000
2 0 0.000000 -0.000000 0.000000 -0.000000 -0.000000 -18.265003
1 0.000000 -0.000000 -0.000000 -0.000000 -0.000000 4.398419
4 0.000000 -0.000000 -0.000000 -0.000000 -0.000000 -2.433374
5 0.000000 -0.000000 0.000000 0.000000 0.000000 -1.074326
6 0.000000 -0.000000 0.000000 0.000000 0.000000 -1.482333
3 0 0.000000 -0.000000 13.611829 -0.000000 -11.773605 -18.265003
1 0.000000 -0.000000 -0.741729 -0.000000 -6.734652 4.398419
4 0.000000 -0.000000 -4.611659 -0.000000 -13.941488 -2.433374
5 0.000000 -0.000000 18.291712 0.000000 3.631887 -1.074326
6 0.000000 -0.000000 8.299577 0.000000 8.057510 -1.482333
并按 print (d.xs(0))
feature0 feature1 feature2 feature3 feature4 feature5
0 18.279579 -3.921346 0.0 -0.0 -0.0 -18.265003
1 17.899545 -15.503942 -0.0 -0.0 -0.0 4.398419
4 16.432750 -22.490190 -0.0 -0.0 -0.0 -2.433374
5 15.905368 -4.812785 0.0 0.0 0.0 -1.074326
6 16.991823 -15.946251 0.0 0.0 0.0 -1.482333
（编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |