Apply style to a DataFrame using index/column from a list of tuples in Python/Pandas

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}

I have a list of tuples that represent DataFrame index row number and a column name, in a form:

[(12, 'col3'), (16, 'col7'), ...].

I need to be able to find rows/column values that correspond to those tuple values in another dataframe and mark them red for example. Usually I use

df.style.apply(...)

from here: https://pandas.pydata.org/pandas-docs/stable/style.html and it works but in this case I am not sure how to map those tuple values with a dataframe in a function. Any help is much appreciated.

asked Jan 3 at 14:22

user8436761

778

All values always matched?

– jezrael
Jan 3 at 14:25

Only values located in a dataframe on the 12th row and in a column col3 and so on should be colored red for example.

– user8436761
Jan 3 at 14:28

add a comment |

I have a list of tuples that represent DataFrame index row number and a column name, in a form:

[(12, 'col3'), (16, 'col7'), ...].

I need to be able to find rows/column values that correspond to those tuple values in another dataframe and mark them red for example. Usually I use

df.style.apply(...)

asked Jan 3 at 14:22

user8436761

778

All values always matched?

– jezrael
Jan 3 at 14:25

Only values located in a dataframe on the 12th row and in a column col3 and so on should be colored red for example.

– user8436761
Jan 3 at 14:28

add a comment |

I have a list of tuples that represent DataFrame index row number and a column name, in a form:

[(12, 'col3'), (16, 'col7'), ...].

I need to be able to find rows/column values that correspond to those tuple values in another dataframe and mark them red for example. Usually I use

df.style.apply(...)

asked Jan 3 at 14:22

user8436761

778

I have a list of tuples that represent DataFrame index row number and a column name, in a form:

[(12, 'col3'), (16, 'col7'), ...].

I need to be able to find rows/column values that correspond to those tuple values in another dataframe and mark them red for example. Usually I use

df.style.apply(...)

python-3.x pandas

asked Jan 3 at 14:22

user8436761

778

asked Jan 3 at 14:22

user8436761

778

asked Jan 3 at 14:22

user8436761

778

asked Jan 3 at 14:22

user8436761

778

asked Jan 3 at 14:22

user8436761

778

All values always matched?

– jezrael
Jan 3 at 14:25

Only values located in a dataframe on the 12th row and in a column col3 and so on should be colored red for example.

– user8436761
Jan 3 at 14:28

add a comment |

All values always matched?

– jezrael
Jan 3 at 14:25

Only values located in a dataframe on the 12th row and in a column col3 and so on should be colored red for example.

– user8436761
Jan 3 at 14:28

All values always matched?

– jezrael
Jan 3 at 14:25

Only values located in a dataframe on the 12th row and in a column col3 and so on should be colored red for example.

– user8436761
Jan 3 at 14:28

add a comment |

1 Answer
1

active

oldest

votes

You can use custom function with at for set values by tups:

tups = [(12, 'col3'), (16, 'col7'), ...]



def highlight(x):

    r = 'background-color: red'

    df1 = pd.DataFrame('', index=x.index, columns=x.columns)

    #rewrite values by selecting by tuples

    for i, c in tups:

        df1.at[i, c] = r

    return df1



df.style.apply(highlight, axis=None)

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

1

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

add a comment |

Your Answer

StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});

}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54024183%2fapply-style-to-a-dataframe-using-index-column-from-a-list-of-tuples-in-python-pa%23new-answer', 'question_page');
}
);

Post as a guest

Name

Required, but never shown

1 Answer
1

active

oldest

votes

1 Answer
1

active

oldest

votes

You can use custom function with at for set values by tups:

tups = [(12, 'col3'), (16, 'col7'), ...]



def highlight(x):

    r = 'background-color: red'

    df1 = pd.DataFrame('', index=x.index, columns=x.columns)

    #rewrite values by selecting by tuples

    for i, c in tups:

        df1.at[i, c] = r

    return df1



df.style.apply(highlight, axis=None)

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

1

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

add a comment |

You can use custom function with at for set values by tups:

tups = [(12, 'col3'), (16, 'col7'), ...]



def highlight(x):

    r = 'background-color: red'

    df1 = pd.DataFrame('', index=x.index, columns=x.columns)

    #rewrite values by selecting by tuples

    for i, c in tups:

        df1.at[i, c] = r

    return df1



df.style.apply(highlight, axis=None)

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

1

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

add a comment |

You can use custom function with at for set values by tups:

tups = [(12, 'col3'), (16, 'col7'), ...]



def highlight(x):

    r = 'background-color: red'

    df1 = pd.DataFrame('', index=x.index, columns=x.columns)

    #rewrite values by selecting by tuples

    for i, c in tups:

        df1.at[i, c] = r

    return df1



df.style.apply(highlight, axis=None)

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

You can use custom function with at for set values by tups:

tups = [(12, 'col3'), (16, 'col7'), ...]



def highlight(x):

    r = 'background-color: red'

    df1 = pd.DataFrame('', index=x.index, columns=x.columns)

    #rewrite values by selecting by tuples

    for i, c in tups:

        df1.at[i, c] = r

    return df1



df.style.apply(highlight, axis=None)

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

edited Jan 3 at 14:38

answered Jan 3 at 14:30

jezrael

359k26325403

answered Jan 3 at 14:30

jezrael

359k26325403

answered Jan 3 at 14:30

jezrael

359k26325403

1

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

add a comment |

1

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

Brilliant, it works but instead of 'red' you need to add something like 'background-color: red', otherwise no coloring will show. Thanks!

– user8436761
Jan 3 at 14:37

add a comment |

draft saved

draft discarded

Thanks for contributing an answer to Stack Overflow!

Please be sure to answer the question. Provide details and share your research!

But avoid …

Asking for help, clarification, or responding to other answers.

Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Post as a guest

Name

Required, but never shown

Name

Required, but never shown

Name

Required, but never shown

This page is only for reference, If you need detailed information, please check here

Search This Blog

Ufyukyu