How to Adjust the Style of Pandas DataFrame

Key Takeaways

welcome back to the data professor YouTube channel if you new here my name is Tim in Nanta Sanomat and I'm an associate professor of bioinformatics on this YouTube channel we cover about data science concepts and practical tutorials if you're into this type of content please consider subscribing are you using pandas for your data science project are you bored of the same old styling of the pandas dataframe if you answered yes to both of these then you're gonna be happy with what is in store for you today so in this video I'm going to show you how you can adjust the style of the pandas dataframe to a customized color of your choice so without further ado let's get started so the first thing that you want to do is head over to the github of the data professor and click on the code repository and then scroll down click on Python down find Panda dialing data frame click on that okay and right-click on the raw link save the gas and save it into your computer if you have a google collab you can follow along as well by clicking on the file open notebook and then click on the github tab type in data professor and find panda styling data frame and click on it okay but because I already have it open I'm going to use this version and so let me start by clearing all outputs before we begin so that we can start together all right so let's begin and so the first step here is to import the necessary libraries which is numpy and pandas okay and then the next step is we're going to download the NBA player stats data for our example and as you might recall this was collected by scraping from the website in a previous video so please find the link to the video in the video description down below and also in the link up here okay let's continue okay and so we're gonna download this from our github and then we're going to read in the panda's data frame and we're gonna display selected columns as shown here in the selection variable and then to make the selection into the data frame we're going to define the f equals to DF open and closing bracket and inside as the argument will be selection and so we're going to display only the selected columns here not the entire data set okay so let's have a look how does it look like and so this is the typical data frame that you're gonna see when you're using Google collab or when you're using your tubular notebook or even your aqua notebook so it's going to have this plane look okay not that it's not good but it is a little bit boring so let's say that you want to color this to something else can you do it well yeah so I'm gonna show you and so the styling trick of the pandas dataframe is brought to you by this article in towards data science and so if you would like to see other tips from this please have a look at this article and so here we're gonna show you selected tips in styling the pandas table or the pandas dataframe with CSS styling and so let's look at the code so we're gonna start by defining the data frame DF and then we're gonna show only the first 20 rolls so we're gonna have the head function and inside the argument we're gonna be 20 so that will display 20 rolls and then it's gonna be dot style dot and then we're gonna use the set table Styles function and as argument it's going to be right here as highlighted here and so here we're gonna select the background color of the header row and this is going to be the font color which is going to be white and the background color will be green and here we're gonna display the font using verdana and then we're gonna display the background color of the odd rows and even rolls differently so in the odd rows we're gonna have it in the gray color but in the even rows we're gonna show it as a white color and then we're gonna hide the index number from the display okay so let's run this code alright so this is the before okay and this is the after okay so you can color this any other color that you like okay but in this example I'm using green color and you're gonna see here that the odd number is gray dcdcdc which is the hex code for grey color and you see here that we also use the common name as well white so you can use the common name as well as the caps code to define the color okay so the odd rows are gray even rows are white okay so this might help you to quickly scan the table alright so actually the default also has light grey color okay and the difference here is that in the collab you have this over highlight as well meaning that when your mouse hovers over a particular roll you see that the background color becomes darker gray color okay but in this style nothing happens but I'm gonna show you in just a moment how you can make that highlight in a different color okay and so let's move on alright and here we're gonna add the yellow highlight color so the only different here is this block of code so this will tell us that upon hovering the mouse the background color will be changed to yellow so it's gonna be the background color of the particular role that the mouse hovers over okay so let's have a look so when we hover the mouse over the particular roll it changes the background color to be yellow okay so this might be more clearer than the default color of darker gray okay so you can change this to other color that you like if you make it read right could it be pink okay it could be pinkish color as well oh hi MA purple okay maybe too dark okay so let's say that you want to have other colors you can head over to this link that I provided at the bottom of this notebook so select a color that you like maybe you want some orange looking color right maybe this is orange so it could be any gradient color any that you like here let's it I like this color I'll just copy this tax code and I'm going to paste it here and remember to add the hashtag or the pound key and there you go or is color okay so let's say that you want to perform some conditional coloring in this example I'm gonna show you how you can color the values of a particular column based on conditions so here we have three scenarios right if the value is less than five it will be colored black if the value is greater than five but less than twenty it will be colored red and if the value is greater than twenty it will be colored green okay so whenever each of this condition returns to be true then it will return this statement and this statement will output color : and then it's gonna make use of the modulo operator meaning that the color variable here will be replaced with the respective string of the color either green red or black and so this value will be placed in here and so it will be color colon and then the name of the color that we want inside here okay and so in this example we're gonna use the points column and so let's have a look and so you're gonna see that the color of value squinted at twenty will be green and if it's greater than five it'll be red but less than twenty and other values less than five will be black okay so this might come in handy when you are eyeballing the data set and you just want a quick glance of the relative distribution of the values so based on your own binning the three color binning the green red and black frequency of each of these three classes okay and so make note that the index number is also shown here and so if you see that values having green color it has a index number of seven and index number of nineteen and so you could also display the player name the position and the team okay also for the first twenty row and then you're gonna see the index number right here so if it's green its number nineteen and number seven right so number seven is right here and number nineteen okay just in case you would like to know the name alright so this will allow you to quickly have a look all right and so this is a quick tips and tricks on how you can style your pandas dataframe and if this video was helpful to you please give it a thumbs up and subscribe if you haven't yet done so and as always the best way to learn data science is to do data science and so please enjoy the journey thank you for watching please like subscribe and share and I'll see you in the next one but in the meantime please check out these videos