Facebook-merge.py

# coding: utf-8

# In[1]:

import pandas as pd
import numpy as np
from sklearn import ensemble, feature_extraction, preprocessing
from IPython.core.display import HTML


# In[2]:

#bids=pd.read_pickle(('/home/alfard/Facebook-Robot/test.pk'))

D1_bid=pd.read_pickle(('/home/alfard/Facebook-Robot/D1_bid.pk'))
D1_auction=pd.read_pickle(('/home/alfard/Facebook-Robot/D1_auction.pk'))
D1_std=pd.read_pickle(('/home/alfard/Facebook-Robot/D1_std.pk'))


D2_bid=pd.read_pickle(('/home/alfard/Facebook-Robot/D2_bid.pk'))
D2_auction=pd.read_pickle(('/home/alfard/Facebook-Robot/D2_auction.pk'))
D2_std=pd.read_pickle(('/home/alfard/Facebook-Robot/D2_std.pk'))


D3_bid=pd.read_pickle(('/home/alfard/Facebook-Robot/D3_bid.pk'))
D3_auction=pd.read_pickle(('/home/alfard/Facebook-Robot/D3_auction.pk'))
D3_std=pd.read_pickle(('/home/alfard/Facebook-Robot/D3_std.pk'))


country_4=pd.read_pickle(('/home/alfard/Facebook-Robot/country_4.pk'))
country_4['bidder_id'] = country_4.index
country_B=country_4.rename(columns = {('bidder_id', ''):'bidder_id'})

merch_B=pd.read_pickle(('/home/alfard/Facebook-Robot/merch_B.pk'))

device_NB=pd.read_pickle(('/home/alfard/Facebook-Robot/device_NB.pk'))

ip_NB=pd.read_pickle(('/home/alfard/Facebook-Robot/ip_NB.pk'))

url_NB=pd.read_pickle(('/home/alfard/Facebook-Robot/url_NB.pk'))


# In[74]:

A=url_NB[['bidder_id']]


# In[75]:

A = A.join(url_NB[['url_NB']], on='bidder_id')

A = A.join(ip_NB[['ip_NB']], on='bidder_id')

A = A.join(device_NB[['device_NB']], on='bidder_id')


# In[76]:


A = A.join(merch_B.ix[:,0:10], on='bidder_id')

A = A.join(country_B.ix[:,0:199], on='bidder_id')


# In[77]:

A = A.join(D1_bid['D1_bid'], on='bidder_id')
A = A.join(D1_auction['D1_auction'], on='bidder_id')
A = A.join(D1_std['D1_std'], on='bidder_id')

A = A.join(D2_bid['D2_bid'], on='bidder_id')
A = A.join(D2_auction['D2_auction'], on='bidder_id')
A = A.join(D2_std['D2_std'], on='bidder_id')


A = A.join(D3_bid['D3_bid'], on='bidder_id')
A = A.join(D3_auction['D3_auction'], on='bidder_id')
A = A.join(D3_std['D3_std'], on='bidder_id')


A.fillna(0)


# In[78]:

A.to_pickle(('/home/alfard/Facebook-Robot/A.pk'))


# In[ ]: