styling a pandas table and merging 2 dataframes

Question

I wanted to style a pandas table, but I'm not able to reshape it every other row, color it this way or set borders for it. I'd be thankful if anyone helps me with this. I uploaded both tables below. The right side table is my table at the moment and the left one is my target.

Content Based MOVIES TITLE	Content Based MOVIES ID	Colaborative Filtering MOVIES TITLE	Colaborative Filtering MOVIES ID
Ordinary People	1956	Interstate 60	6902
Firewalker	2477	Rubber	81132
Fantastic Planet, The (Planète sauvage, La)	2495	Dragonheart 2: A New Beginning	117646
Airport '77	2522	Inside Out	134853
Mister Roberts	3035	Wizards of Waverly Place: The Movie	148775

To color it, I tried to change tables properties, using style.set_properties and also used different join and merge techniques to stick two tables every other row, though none of'em worked.

Answer 1

You can lreshape your DataFrame, then use apply/applymap_index (which are Excel friendly) :

out = pd.lreshape(
    df, {
        "TITLE": ["Content Based MOVIES TITLE", "Colaborative Filtering MOVIES TITLE"],
         "ID": ["Content Based MOVIES ID", "Colaborative Filtering MOVIES ID"]
    }
)

import numpy as np

#rows
purple = "background-color: #ffff99; color: black"
yellow = "background-color: #b376e0; color: black"
border = ["border-right: 3px solid black", ""]

#header
bgray = [
    "border-right: 3px solid black; background-color: #e9e8fc; color: black",
    "background-color: #e9e8fc; color: black;"
]    

(
    out.style
        .apply(lambda x: np.where(x.index % 2, yellow, purple))
        .apply(lambda _: border, axis=1)
        .apply_index(lambda _: bgray, axis=1)
        # .to_excel("output.xlsx", index=False) #optional
)

Output :