machine learning in coding（python）：根据关键字合并多个表（构建组合feature）

最新推荐文章于 2023-12-22 02:10:49 发布

mmc2015

最新推荐文章于 2023-12-22 02:10:49 发布

阅读量2.3k

点赞数 1

分类专栏： ML in coding scikit-learn machine learning in coding 文章标签：机器学习 scikit-learn 合并多张表组合特征

本文链接：https://blog.csdn.net/mmc2015/article/details/47208939

版权

scikit-learn 同时被 3 个专栏收录

51 篇文章 2 订阅

订阅专栏

ML in coding

13 篇文章 1 订阅

订阅专栏

machine learning in coding

7 篇文章 11 订阅

订阅专栏

三张表；train_set.csv；test_set.csv；feature.csv。三张表通过object_id关联。

import pandas as pd
import numpy as np

# load training and test datasets
train = pd.read_csv('../input/train_set.csv')
test = pd.read_csv('../input/test_set.csv')
features = pd.read_csv('../input/feature.csv')
train = pd.merge(train,features,on='object_id',how='inner')
test = pd.merge(test,features,on='object_id',how='inner')

# drop useless columns and create labels
test = test.drop(['id', 'object_id'], axis = 1)
labels = train.cost.values
train = train.drop(['object_id', 'cost'], axis = 1)
# convert data to numpy array  
train = np.array(train)  
test = np.array(test)  


from：kaggle