Split DFs

Netflix_df = df[df.Platform == 'Netflix']

Hulu_df = df[df.Platform == 'Hulu']

Amazon_df = df[df.Platform == 'Amazon']

Merge DFs

Append DFs

Merged_df = Amazon_df.append(Netflix_df)

Combine DFs By Col (Vlookup)

##########################################

### Creating DFs to be merged ###

df1 = df.drop(df.columns[[2,3,4,5,6,7,8,9,10,11,12]], axis=1)

df2 = df.drop(df.columns[[1,4,5,6,7,8,9,10,11,12]], axis=1)

print list(df1)

print list(df2)

##########################################

df3 = df1.merge(df2, left_on='URL', right_on='URL')

df3.head(1)