PyGWalker Crash Course - Data Visualization Like Tableau In Python

hello everyone welcome back again my name is Jesse and in this wonderful and exciting tutorial I'll be trying to explore a very nice Library called Pig Walker right so pick workout or pie G Walker is a data visualization library that is similar to Tableau right that gives you the option of being able to explore your data in a very simple way right with the drag and drop and stop as we already know about Tableau but this is in Python and it's very very useful so let's see how to work with it so in case you don't have it I just install it on a standard pick install Pi chip worker that is how to install it on your system then after installing it it can work with pandas polars and the rest so let's see an example I'm going to load my package foreign so we can explore these data sets into several ways to get more insight into it let's see how to use Pi G Walker or pick worker to help us with that so first of all I'm going to check the matters of it so as I always do the metals they are out Pi y g pick then you can see that we have the G workout we have the four specs and the most important thing that you need is you need your work work right so this is what you'll be using to do most of the things there are other stuff but this is the most important for now so let's start with it so to explore your data to explore the data right it's just simply like this so pick dot work and this work takes in the data frame right and then it takes in some other parameters right and some other parameters so you can explore those things by just going with my question question mark in case you are in PG pg.org and make it bigger so that you can see support like this right if I go with walk you can see that we have the data frame right and then some other parameters right so that that is the team that you want okay to want to return it as HTML we can just do that so let's see how to use it on our system so digital frame and then your other parameter so let's specify that I want my team to be say light team and then that is also if I run it is going to analyze data and give us a very nice pleasant feature which is this one which is very cool right so that is pi G work or pick worker right so we have the data and by default it's going to give you the data it's going to analyze the data and then gives you the data types right so the measure is quantitative that is the other the numbers so most of the time they are the quantitative and we also have the dimensions right which are isolated numerical ones right so we have the quantitative like the index the H is also odd now it's automatically identified and this is on now and this is nominal right very cool and very smart and you can scroll up so the entire table is there we can't scroll like this to see the entire step which is very cool and you can also move on to the nest right all right previous list very very cool right it just looks the face 100 but you can move on to the nest and you can see that it's changing very cool you can also switch it right in case you want to switch to your dimension you can also change it but let's keep it as measure perfect that is the phase aspect of exploring data you can also click on the visualization and by default when you come back to the visualization you can be able to visualize your data right so you have the S assets and the Y as is and then we have the quantitative which was the same thing that we saw here those are doing numbers like quantitative are only automatically put down here and the remaining data's disappoints are here right so let's start with the rule count so I'm just going to plot the row count as my X as this right that's my wireless right and then I can just plug something like let's say let's close State six and then if you're not going to give us this particular data right so the number of females in the middle this thing could have been done in case you're in Python in previously you could have done it like this if I come back here I can just do the SS distribution could have been done it's like DF then I'll just pass in the access column right and I can just go back to Value count if I go read this option he said I will get the same thing and in case I wanted to plot this I could have plotted it with I think because I have math plus label or something I'm just go with plot then I kind let's go to bar right right so this is the same thing that has been closed idea but automatically it gives you that deployed after the boss you can actually see the actual data by going back to this icon here right and then this is the different visualization types the different types of table you can have by default it will pick the best one which is a bar chart so you have the bar chart which is here you can change it from bar chart to a line chart which is a deformity for now you can change it to scatter you can change it to DS right so in case you want to see the data I just click on table and now you can see that this is the same thing that we had here right very cool so out of the box it gives you all of these things outside the box right so let's move from here from this to Auto perfect okay that is one of the things you can also by just copying whatever you want to do in case I want to check for the marital status which is this and the account I just drag it like Tableau into myself going to plot the distribution of the female male as well as the marital status which is very cool right and you can click on it to see the image which is cool you can also do some other stuff right that is some very nice things I can also add more to it so in case I want to add the Rays to it I can also add erase and then have multiple plots right and I can also change it from this option in case I want to give it change the color of this I can drag the let's say I want to drag the access to the color and now it's going to give us two different colors right which is very very intuitive right so I can even think of this to take it off you just drag it back and now there you have it here which is having the color and then the American Assassin erase very simple very cool but that is a very nice feature that's this particular Library gives you it gives you the key here and everything is cool okay so let's say we want to also add some other stuff so at least I want to add the occupation to it and I can have all of them here right but it's a lot of data I can change it I can do some photoing for this entire stuff so in case I want to filter this stuff I can just go back again and then compare the occupation whatever I want to filter because these are the options we have filter we have color we have opacity we have size we have sheet and we have the details right but in case I want to do some filtering I can just go back to this place copy it and then filter automatically give me all of this option and I can select I don't want to unpause this I don't want farming text tech support machine Ops take off the others right right and once I go with this option I can click on confirm and it's going to automatically filter them and give us what is being floated here right very cool for the completion I'm just filtering these columns in case you also want to reduce the the size of the image right you can just go back to this icon this icon here right if we go back here you can make it fifth or Auto so first it's going to fix the entire data set here right there image which is fist you can also change it from here to Auto and in case you want to change the size you can just go back here and then change the size like this right so now I'm changing the size of the entire data set as you could see I can take off some of them so that it becomes more clearer this you can actually change the size by clicking on this changing the width and the height you can also drag it right so let's take off all of this so let me take off this and let's make it simple so I'll just go with this okay let's take off all of this yeah this is okay and I can't drag it right okay you just take off the auto and you can copy and like let me make it simple okay so perfect there's also the option of Auto uh resizing the X and Y of this so if I click on it so now it is being automatically resized right very cool and very nice you can also change the order so I can go with ascended author let's certain it in descending order I can also sort it in ascending order which is very cool then let's move on from here to some other stuff you can also do so all of this we are doing is just aggregation I can change it from aggregation to something else right so perfect let's move on from here to some other stuff here so do I can change the different plots let's move on to area charts and you can see that it's giving us an area chat you can change the blood to your scatter chat but for now there is no pie charts right there is hack but there is no pie charts as I wanted but it's very cool it's a very nice feature okay so let's go back to auto how do you export all of these things we have done so in case you want to export it how do you do that you just go back to here and Export the image so you can expect as PNG and you can see that you still get the image here right which you can use in your website or your presentation you can also export it as SP uh support vector graphics SVG that is how to export it you can also click on it here and then save the image right as you wish okay the other option of exporting that you can also come back again to here right there to this option and you can do some configuration stuff for the entire plot you can export the entire code right which is behind the scene and then it's going to give you the option of some Json which you can use to re-render the plot again so you can copy to clipboard you can export us you can cancel the nice thing is that it's going to give you the code here right that you have to run so if I go with export as code it's going to give me the option of exporting as code or export as a file instead automatically downloading it here as a Json and then if I go down if I scroll down here right I can actually run it right so and I can also cancel that is a very nice stuff about pi GE worker of course there are a lot of things you can do with it but these are some of them in finally in case you also want to create a new chat you can click on new and can also add some more chat to it so you know just only one chat you can also create multiple chats so I can put education and then I can also put let's say something here right which is not a good chat but yeah you get a point so you can do more multiple chat so that is very cool and very nice right I can switch in the color so let's go with this or I can also add this one rather right and instead of this given as a different chat perfect so thank you for watching this video I hope you have learned something so there are a lot of things you can do with this wonderful and nice library in case you want to change the theme from this to a different team you can also do that you can just copy this one from here and go back here and then let's say I want the lighting or attack team I can just give a duck and now it's going to render the entire stuff in a dark mode for us so this is the dark mode and you can't see it better there's something interesting right you can see that it's working as expected right perfectly you can also change the team in case you want perfect so that is some nice thing you can do with this wonderful Library you can also export it as HTML and then use it in your code sometime right so we remember that here we exported it as Json if I go back to the exports not here but if I go to the export I can export it as Json right it's far get this file in case I want to load this fallback again I can go back again so let's reload it so in case I want to load there Json pick walk up how do I do that I just give it pick okay right to work they're not passing my data right I'll pass in my data right and I'll pass in my after passing the data you need to pass in your configuration for just a spec right so spec then my configuration file a part which is conf dot Json so you have to make sure that this file so I can just show in folder and then copy it and name it well right so here is it so this is the file I switch I've named and it's in the same location right and now turn this on so if I go with this I can specify the dark go to say light and then it's going to give me the particular data type I have above right and you can now re-get it back again see that today I've gotten back again I'll uploaded you want to plot and you can also continue from there that is something very nice a very cool with workout so thank you for watching see you in the next session and then stay blessed

Channel: JCharisTech

Views: 5,132

Keywords: pygwalker, tableau, python, tableau in python, pygwalker python, crash course, data visualization, streamlit, pygwalker and streamlit, plotly, ipyvizzu, chatgpt, pandasai, pandas, exploratory data analysis, jcharistech, jesse jcharis

Id: 68dFRqdxSrI

Length: 14min 26sec (866 seconds)

Published: Sat Jul 01 2023