Ggtcf

How to stretch the corners of this image so that it looks like a perfect rectangle?

In Bayesian inference, why are some terms dropped from the posterior predictive?

Send out email when Apex Queueable fails and test it

how do we prove that a sum of two periods is still a period?

Why is the sentence "Das ist eine Nase" correct?

Is it "common practice in Fourier transform spectroscopy to multiply the measured interferogram by an apodizing function"? If so, why?

What is the fastest integer factorization to break RSA?

What is an equivalently powerful replacement spell for Yuan-Ti's Suggestion spell?

Should I tell management that I intend to leave due to bad software development practices?

Do creatures with a listed speed of "0 ft., fly 30 ft. (hover)" ever touch the ground?

Why do I get negative height?

What are the G forces leaving Earth orbit?

Processor speed limited at 0.4 Ghz

What is the opposite of "eschatology"?

Can compressed videos be decoded back to their uncompresed original format?

Why are UK visa biometrics appointments suspended at USCIS Application Support Centers?

How to travel to Japan while expressing milk?

Getting extremely large arrows with tikzcd

Is "/bin/[.exe" a legitimate file? [Cygwin, Windows 10]

How to remove border from elements in the last row?

How dangerous is XSS

Bullying boss launched a smear campaign and made me unemployable

Can someone clarify Hamming's notion of important problems in relation to modern academia?

Could the museum Saturn V's be refitted for one more flight?

Applying Pandas style between two dataframes differences

What is the difference between old style and new style classes in Python?What is the difference between @staticmethod and @classmethod?Difference between append vs. extend list methods in PythonDifference between __str__ and __repr__?Selecting multiple columns in a pandas dataframeAdding new column to existing DataFrame in Python pandasDelete column from pandas DataFrame by column nameHow to iterate over rows in a DataFrame in Pandas?Select rows from a DataFrame based on values in a column in pandasGet list from pandas DataFrame column headers

1

I've seen a lot of questions about finding the differences between two pandas dataframes, however here i'm trying to apply a Pandas.Style difference between two dataframes. Given these two example dataframes i'm hoping to have a formatter applied to right[1, "B"] and right["D"] because they're different that lefts values or new in general:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))

Here's my idea for the formatting method guided by the pandas documentation

def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return "color: red; text-decoration: line-through;"

 elif not s.equals(new[s.name]):
 # apply per value a comparision of the elements
 # for val in s: 
 # if val != right[val.index??]:
 return "color: red; text-decoration: line-through;"

 return "color: black;"

left.style.apply(formatter, args=(right))

My thinking is that afterwards I should have something that is html like such:

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

python html pandas

share|improve this question

asked Mar 8 at 19:59

TonyTony

620526

add a comment | 

1

I've seen a lot of questions about finding the differences between two pandas dataframes, however here i'm trying to apply a Pandas.Style difference between two dataframes. Given these two example dataframes i'm hoping to have a formatter applied to right[1, "B"] and right["D"] because they're different that lefts values or new in general:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))

Here's my idea for the formatting method guided by the pandas documentation

def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return "color: red; text-decoration: line-through;"

 elif not s.equals(new[s.name]):
 # apply per value a comparision of the elements
 # for val in s: 
 # if val != right[val.index??]:
 return "color: red; text-decoration: line-through;"

 return "color: black;"

left.style.apply(formatter, args=(right))

My thinking is that afterwards I should have something that is html like such:

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

python html pandas

share|improve this question

asked Mar 8 at 19:59

TonyTony

620526

add a comment | 

I've seen a lot of questions about finding the differences between two pandas dataframes, however here i'm trying to apply a Pandas.Style difference between two dataframes. Given these two example dataframes i'm hoping to have a formatter applied to right[1, "B"] and right["D"] because they're different that lefts values or new in general:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))

Here's my idea for the formatting method guided by the pandas documentation

def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return "color: red; text-decoration: line-through;"

 elif not s.equals(new[s.name]):
 # apply per value a comparision of the elements
 # for val in s: 
 # if val != right[val.index??]:
 return "color: red; text-decoration: line-through;"

 return "color: black;"

left.style.apply(formatter, args=(right))

My thinking is that afterwards I should have something that is html like such:

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

python html pandas

share|improve this question

asked Mar 8 at 19:59

TonyTony

620526

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))

def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return "color: red; text-decoration: line-through;"

 elif not s.equals(new[s.name]):
 # apply per value a comparision of the elements
 # for val in s: 
 # if val != right[val.index??]:
 return "color: red; text-decoration: line-through;"

 return "color: black;"

left.style.apply(formatter, args=(right))

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td>1</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td>2</td>
 <td>2</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

<table border="1" class="dataframe">
 <thead>
 <tr style="text-align: right;">
 <th></th>
 <th>A</th>
 <th>B</th>
 <th>C</th>
 </tr>
 </thead>
 <tbody>
 <tr>
 <th>0</th>
 <td>1</td>
 <td>1</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 <tr>
 <th>1</th>
 <td>2</td>
 <td style="color: red; text-decoration: line-through;">5</td>
 <td style="color: red; text-decoration: line-through;">10</td>
 </tr>
 </tbody>
</table>

share|improve this question

asked Mar 8 at 19:59

TonyTony

620526

share|improve this question

asked Mar 8 at 19:59

TonyTony

620526

asked Mar 8 at 19:59

TonyTony

620526

asked Mar 8 at 19:59

TonyTony

620526

1 Answer
1

active

oldest

votes

1

It is a bit unclear exactly where you are a stuck, but the code is not far off.

This might be what you are after:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))
def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return ["color: red; text-decoration: line-through;"]*len(s)

 elif not s.equals(new[s.name]):
 return ["color: red; text-decoration: line-through;" if v else "" for v in s == new[s.name]]

 return ["color: black;"]*len(s)

left.style.apply(formatter, args=[right])

The formatter method now returns data in the same shape as the input (as per the docs).

The right dataframe is passed as a list and not a tuple.

Also changed the per value comparison to return color if they differ, otherwise keep default style.

share|improve this answer

edited Mar 9 at 6:24

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

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');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55070199%2fapplying-pandas-style-between-two-dataframes-differences%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

1

It is a bit unclear exactly where you are a stuck, but the code is not far off.

This might be what you are after:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))
def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return ["color: red; text-decoration: line-through;"]*len(s)

 elif not s.equals(new[s.name]):
 return ["color: red; text-decoration: line-through;" if v else "" for v in s == new[s.name]]

 return ["color: black;"]*len(s)

left.style.apply(formatter, args=[right])

The formatter method now returns data in the same shape as the input (as per the docs).

The right dataframe is passed as a list and not a tuple.

Also changed the per value comparison to return color if they differ, otherwise keep default style.

share|improve this answer

edited Mar 9 at 6:24

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

add a comment | 

1

It is a bit unclear exactly where you are a stuck, but the code is not far off.

This might be what you are after:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))
def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return ["color: red; text-decoration: line-through;"]*len(s)

 elif not s.equals(new[s.name]):
 return ["color: red; text-decoration: line-through;" if v else "" for v in s == new[s.name]]

 return ["color: black;"]*len(s)

left.style.apply(formatter, args=[right])

The formatter method now returns data in the same shape as the input (as per the docs).

The right dataframe is passed as a list and not a tuple.

Also changed the per value comparison to return color if they differ, otherwise keep default style.

share|improve this answer

edited Mar 9 at 6:24

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

add a comment | 

It is a bit unclear exactly where you are a stuck, but the code is not far off.

This might be what you are after:

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))
def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return ["color: red; text-decoration: line-through;"]*len(s)

 elif not s.equals(new[s.name]):
 return ["color: red; text-decoration: line-through;" if v else "" for v in s == new[s.name]]

 return ["color: black;"]*len(s)

left.style.apply(formatter, args=[right])

The formatter method now returns data in the same shape as the input (as per the docs).

The right dataframe is passed as a list and not a tuple.

Also changed the per value comparison to return color if they differ, otherwise keep default style.

share|improve this answer

edited Mar 9 at 6:24

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

left = pd.DataFrame([[1,1,1], [2,2,2]], columns=list("ABC"))
right = pd.DataFrame([[1,1,10], [2,5,10]], columns=list("ABD"))
def formatter(s, new):
 if s.name not in new.columns:
 # column doesn't exist strike through entire thing
 return ["color: red; text-decoration: line-through;"]*len(s)

 elif not s.equals(new[s.name]):
 return ["color: red; text-decoration: line-through;" if v else "" for v in s == new[s.name]]

 return ["color: black;"]*len(s)

left.style.apply(formatter, args=[right])

share|improve this answer

edited Mar 9 at 6:24

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713

answered Mar 8 at 20:38

John SloperJohn Sloper

1,126713