Shulou(Shulou.com)06/01 Report--

This article shares with you the content of a sample analysis of DataFrame conditional formatting in Pandas. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Conditional formatting of Pandas DataFrame

This is one of my favorite Pandas techniques. This technique gives me the ability to visually locate data under specific conditions.

You can apply conditional formatting to a data box using the style property of Pandas. In fact, a conditional format is an operation that applies a visual style to a data frame according to certain conditions.

Although Pandas provides a large number of operations, I will show you a simple operation here. For example, we have sales data for each salesperson. What I want to check is the one with a sales value of more than 80.

Import pandas as pddata = pd.read_excel (".. / Data/salesman_performance.xlsx") datadata.styledef highlight_green (sales): color = 'green' if sales > 80 else' black' return 'color:% s'% colorformatting = data.iloc [:, 1:6] .style.applymap (highlight_green) formatting Thank you for reading! This is the end of this article on "sample analysis of DataFrame conditional formatting in Pandas". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.