Data Analyst Course | Beginner's to Advance (हिंदी में) | Full Playlist | Python | Power BI | SQL | Excel | Free - Python For Data Analyst | Day 24 | Project 4 Employee Career Analysis | Free 30Day Class| Subscribe

So hello everyone and today is the day number 24 of this Python 30 days master class and today's class we are going to do a more interesting project But prior to that let me just show you here This is the class schedule, which class is it's complete? This is the complete schedule, you will get the description box below And in seven years its class took wrap as the complete last class We have just bought three budgets, the day number 21 to 22 and today's project, which we have already put into this field of development and which is this, was towardsril 2020, there were opportunity to analyze the analysis lla process ndtk ndtk ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt ndt nd ndt ndt ndt ndt ndt ndt ndt nd nd ndt لیٹٹٹ جو پروجیکس ہے اس کا پورا کا پورا دیٹہ سٹ اور ساتی ساتھ اس کا سورسکورڈ یہ ساری کے ساری چیزن جو ہیں آپ کو اوویلے بل ہے انڈسریز لپنگ ہنز کے لورنگ آپ پر مل جائے گی اور ساتی ساتھ اگر کسی کو انستینٹ لی چاہئے تو وہ ہمیں what's app number description box پر دیا گیا ہے اس میں بھی آپ ریچاٹ کر سکتے ہیں تو میں دونوںی طریقے بتا دیتیوں آپ کو سپ سے پہلا پی آپ میں Node's data set sakt putch کہہاں ملے کا تو میں آپ کو ایک video کی طرف آپ explain کر دے دیتے ہیں کہ آپ کو کہاں پہ دیکھنے کے لے ملے کا تو سکسے پہلا پر دسریز لپنگ ہنز کا learning app جو ہے وہ available ہے Play Store پہ نیچے description box پر اس کا link بھی مل جائے گا سکسے پہلا آپ app install کر لیجوے جیسے ہی آپ app install کریں گے کچھ اس طریقے سے آپ کو آپ open کرنا ہے آپ interpays آپ کو مل جائے گا جیسے آپ آپیں آپیں dsri's helping hands کا app open کریں گے After login sign up login کے بعد کچھ اس طریقے سے آپ کو app آپیں آپیں open ہو جائے گا اور یہاں پہلا آپ کو دیکھ ستنے کہ top courses and free categories کے آپیں courses dalleh wai hai here you can see so یہ جو courses dalleh wai hai this courses are available جو کی free category کے آپیں top courses available ہیں یہاں پی جانے کے بعد آپ کو data analytics کا a free course وہ آپ کو آپیں مل جائے گا آپ کو اس پی جا کے اس style پی جاک آپ کو click کرنا ہوگا then after جسی آپ کو سے select کریں گے یہاں پہ آپ دیکھ سکھنے کہ سارے کے所有 پاور بھیائے کے lectures جو کی نشان سر کی series already YouTube میں ہے industry sulting hands کے app nibi available ہیں سا atti آپ کے کچھ چاہپے sql ke lectures aur python kaplu کیا پہلو کیا دیکھ سکھنے her day ke according puri ke puri lectures nodes data set sapku چاہپے available ہے اس کے بعد آپ کو Nietzhi ek en rule now ke button dike ka gara post and like clogging karna to aap ko en rule now ke button made free course de sql ko e-cost ne en rule now ke button dike ba binau aayagab binau yai absolutely free ayagab ki wal aap ko binau ki button press karna this course is absolutely free from our end. so aap en rule yai aap successfully go jai aap ko sql aap dike jai aap my courses mi aap jai aap karna yai aap aces karna saara aap video lecture aap karna aap karna aap naut aap karna karna aap karna karna aap karna aap karna aap karna karna لے بل ہے اپنے. آپ اس طریقے سے جاہ کی اپن کریں گے.

یا آپ ایک دیکھے جو سوٹس کوٹھ جوپیٹھر نوڈبو کیاں بھی پری کی پری فائلے جو میں آپ کے سامنے آپ کو پفوم کر باتیو. یہ پورا کا پورا نوڈس آپ کو انڈسریز لیٹنگ ہانس کی لڑنگ آپ پر بل جائے گا. ساتھی اس پورٹ کو اس پر پرٹگلر پروجیف کو بنانے کر دیٹھا سٹھ بھی آپ کو ایک پر بل جائے گا. یہ تھا آپ کی پر سکتری کا جوپیٹھر نوڈسریز لیٹنگ ہانس کے اپنے جوانے کے بات پورا کا پورا پری کورس وہاں پی ایکسل بھی کر سکتے ہیں.

ویڈسکنٹنگ اس دیکھے یہ آپ کو ایک دیکھے آپ کو اگر بیسٹکلی ایک دیکھے آپ کو دیٹھا سیٹھ چیے. تو آپ ایک چیز اور کر سکتے ہیں. یہاں پی واتساپ number 780113112 یہ جو واتساپ number آپ کو میری سرین پر بھی دیکھ رہے اور ساتھی ساتھ یہ واتساپ number آپ کو نیچھے дисکریپشن وقتھ پر بل جائے گا. اس پی آپ دیٹھا سیٹھ اچھے پرٹکلر اس پروجیت کا ہمیں واتسر پر کر بھی مانگ ستے ہیں.

تو یہ دونوں طریقے آپ کے لئے اپلکے بلے ہیں. Alright so looking forward and second thing is that end to end projects and webinars are related if you want to attend more things so for that you can give a link to google form you can fill out it. Saatheer Saat if you are doing a job search where you are hiring. If you want to know the latest updates then you will get a link to the WhatsApp group and telegram channel on the link in the description.

You can join it. So we will not waste much time so let's start our class which is today's project number 4 right. We have done three projects and today's project is a little important and this is employee's career survey analysis. Now many times when we work in a data analyst and work in a company then many companies perform a lot of services and the survey is given to you to make a report and dashboard as a data analyst.

So you have proposed that if you are a data analyst then how can you complete a complete report, a complete analysis and visualisation of that report then how can you perform it. Because when you work in companies then it is very important that every time you are consulting and you conduct the surveys. So as a data analyst you should also analyze the data and come. So today's class is Employees' career survey analysis.

Here we will see the entire complete of the project. So but prior to that I will show you this data set which we will work on today. As I have told you on the industries' appearance or on what's your number and how can you take it here. So let's see here a complete data survey was conducted.

The survey employee asked where their career aspirations are. In which companies they want to work in which environment they want to work. So this is a complete survey and this is a complete data available in your field. Now these data is available in some of the the employees of India and some of the out of India.

So this is a complete data set available in your field. Now what do you do? How will we start this project? First of all, we will discuss this.

So we know we have done three projects. I hope you will be able to project with this. Because the project is very very important. Until we practice this, it will be of no use.

So just give me a second. Alright. So now after we have done three projects we understand that every project has a life cycle. Right?

So we will see what is the objective of this project. Okay? After that, where we get data first of all, what are the benefits and what are the benefits of this project? After that, we will clean data properly.

After that, we will analyze what is the analytics. We will take them out. But the analysis is the big sheet I have shown to you. I did not understand any analysis.

So we will do the visual lines here. So this is our complete step by step and we will execute the steps in the next project. So first of all, before making this project assume that you are working on a company or a company let's suppose. So now you have a data set.

You have available available. Now here you have four objectives. Let's suppose your manager is saying that you have to give five objectives in this particular project to take out these data. Because the big exit sheet, nobody will understand.

So first of all, you have to take out these data. So we will talk about young generations. So they will influence their career experience with the components and the way you have to take out these reports. How many employees are there in India?

How many people are there in this report? How many people are there? How many employees are there? The market is more carbon packed.

We are about what are available. It is the plan to inherit these data. So we can property, property sales for properties. Hey, you have become Rすごい.

Hey, guys, workflow다 کہ challenged ھاں سے پہلے ہم لوگ ہمیں بڑھے ہیں اپنے جوبیٹر نورڈ بک کی طرف so let me just open this جوبیٹر نورڈ بکھ for you Alright ھاں میں ہمیں ہمیں upnngar liya آج ہے ہمارہ دینمبر 24 تو سپ سے پہلے hending ke format més fullikle te so date 24 اور اس کے ساتھ آج کے ہماری project kanaan joki hai employee career survey analysis تو یہ اگر ہمیں ایک باری project khusamsh liya thomارہ لی اثانی ہوگی ki ki so how ki ki ki ki aagar amare pa survey agar hootein pa muska pura khapur aa complete data kanaan liya sat banan sat te aang .. .. .. ..

.. .. .. ..

.. .. .. ..

.. .. .. ..

.. .. .. aquesta requirement login ng internal requirements Visa prata Negache Cuoco цент Interim Quanta Quanta Quanta muito Q Nga Incorre Pal R Quanta Quanta Chia Quanta Quanta Quanta Quanta Kom Duge janaka,Kom Duge janaka,Lay Bredi礼�� b Necome Liebreتي Yom toe kayat Om Satj 2025 And Göklopwynendet jabwolOS 408 59course ca ports gl b fly n esp s p xémport claut Le.graph objectsMasра graph cars exist Graph objects as go Now will call Whom as 20 So all right,Library Here is data setup My Mac между now کی, jakoی کو کسی نے کہاں انڈیا ہے, دوسرا سوالن سے پچھا گیاں, کنتری کٹ کو لیکے کیا, کیا ہر کنتری کا کٹ ہوتا ہے, جس ہمارےہ, State میں Different Pin Codes ہوتا ہے.

اسی طریقے سے آپی, کنتری کٹ پچھا گیاں. اب, جس انپلاуئے کا ہم آپی ترβیلیا جا رہا تھا, اس کا جنڈر پچھا گیاں. اب, یہاں سے شروع ہوتا ہے, main questions, جسے کی, which of the below factors influence the most about your career aspirations. یہاں پی یہ سوال پچھا گیاں, کہ آپ کے کریر میں کنسی چیزے, کنسی factors جو تھا وہ سب سے زادہ آپ کو influence ھیاں.

اب, جسے کچھ لوگ یہاں پی بولڈ رہے ہیں, کی people who have changed the world better, ایسے لوگوں سے mجھنспیریشن میں لہا جنہوں نے بہت اچھا کی آپ نے کریر میں, یا کچھ لوگ بولڈ رہے ہیں, کی مجھے social media, LinkedIn سے like, ڈا دہتا رہے ہیں, کی مجھے influence ھیاں, کچھ لوگ بولڈ رہے ہیں, کی مجھے friends, ایسے different different opinions جو ہیں یہ سرவے میں پچھا گیاں, چکے, تو ایک کلم یہ ہوگیاں. اب, دیکھنے اور کیا Question's Puchے گیاں, تو یہاں پی پچھا گیاں, ایک اور Question, کی آپ, higher education, your post graduation, India ke bahar karna chaathe hai, یا نہیں کرنا chaathe hai, تو اس کے لئے کچھ لوگوں نے yes bola, کسی نے no bola, اور یہاں پی یہ بھی پچھا گیاں, کی آپ کو اپنے خود کے آپ جو اجوکیشن کرنا chaathe, India ke bahar, تو آپ کا جو آپ, higher naiyayi, اس کے according, آپ ان سے Question's Puchے گیاں. ایک اور Question Puchha گیاں, اسے how likely, آپ ایک کمپنی میں 3 سالیا اُس سے زادا کام کرنا chaathe hai, یا نہیں چاہتے ہیں, چکے, پھر نیکس طوال پچھا گیاں, اسے would you work for a company whose mission is not clearly defined and publicly posted, کیا پیسی کامپنی میں کام کریں گے جس کا missions, صحیطری کسے clearly defined نہیں ہے. تو کچھ لوگوں نے nou کسچ لوگوں نے yes, پھولا.

ایک اور Question اسے Puchha گیاں, how likely would you like to work for a company whose mission is misaligned with the public actions or even their product. As he company's whose actions which are not aligned with proper public say proper oriented ne, تو اس میں آپ کام کریں گےں. آپ, as he company mi کام کریں گےں, کیا جس جو social impact na lai, his particular working environment in the way that all these questions given to us in the column format all these questions given in the columns, all these questions employees' survey Puchha got asked. As I asked you which environment you want to work for.

You want to work from home you want to hybrid, you want to work from office you want to work for. Right. So he has so much all these questions you have done here and this is the complete survey. Name, survey, so we understand that we have some information about something that we are going to gather.

So this is our complete complete data. Okay. Now this is a very big data. Now I want to see which columns are in this.

I want this name. Okay. So when I want the name of the column we work here. We this this is our data.

I make a data name variable and read it here. Okay. Now here data. Head function call let's score.

Okay. So this is our today. Now I want to see what is the name of a column. So my store which is this entire file this is the variable of the data variable.

So I want to see what columns so I call the column function here. Data. Columns call I call. So now we are here.

All the columns are all the columns are written here. As you have current country, you have your gender, what factors you influence your career and this is the entire data that I have here. Okay. Now when we do something we will do the first objective that you have to do first be clear so that you have to do the first objective analysis of the countries.

So first we have to find out that in this survey all the employees are the who are the companies. Sorry, who are the countries. So first objective we have to pull and we are starting. All right.

So first I will take our goal objective one. What we want to do is first what you have to do first you have you show you country analysis. Now this is the survey that is for many employees. It can be an out of the country.

So we have to make a visualisation after this analysis. I have to make a pie chart here. And I have to show that let's suppose so many percent people here are India. All right.

It can be outside country. If we see in the data set, it may be Germany. So let's say this country is a visualisation. I want to make this.

Because I don't know what I have to do. How many percent people are in the survey? How many percent people are in the survey? How many percent are in the survey?

This is my first objective. Now when we make a pie chart here, we have to write that India is so many percent. Germany has made a pie chart and now let's suppose one is in India, I am showing green color. All right.

And let's suppose one is Germany. I am showing Germany in red color. All right. So I want to make a label as well.

It is a red color label. The red color represents Germany. All right. Because you don't know what is the condition of the green color.

And you will see India. So this graph is the country analysis that the employees have participated in. How many employees were in India and who were in other countries. So this objective I have explained briefly.

Now this is the objective. How to do the coding? I am going to write it. All right.

Let's start. Now we want to make a visualization. So first of all, see here. Now I will show you this data set.

Now what we want to analysis. I think you will understand. I will clear it. And we will see.

Now I will tell you what we call data set. Now we will call it data set. Now we will call it your current country. All right.

So let's take this thing. I will scroll down a little. And first of all, let's make a variable in a country name. And what column should be the name of data set.

What column should be your current country. I have shown you. So these columns are current country. All right.

I have taken it. Now what is here. We have to write here C. Now see.

What is here. We see that here India is written. How many times India is here. Okay.

If Germany is here, how many times Germany is here. If we want to do this, what we need to do. India is so many times. So what we will do is we will use the value of the columns.

So we will write the value of the columns. And we will do this. And the country we have made in our variable. So it is showing some sort of error.

Your current country. Here, it is a error. Why you will figure it out. Now see this column is also written.

But we did not write a error here. It is a very small error. Sometimes it is a very small error. So let us write a error.

Let us see what we are doing. All right. We are looking at this. This survey was in the first survey.

So we have found the count. Now the count is shown in this survey. So we will drop the column. So the country is here.

So we will drop the column. So what we will do in the country. index. Now see this country.

Here this this country we have written. So this index is in the value. So if we index in the country. So we will take the index in the country.

So we will write the index in the country. dot values ok country dot values we have set now what we need to do? we need to see the color so i am making the color's name parameter so let's suppose the colors are given in the list format i will give you one color write sorry red and i will give you one color here and i will give you light green ok, light green red or green now what we need to do? graph is to make a pie chart and use the plotly library so first of all i am making a variable called fig name and go dot figure function when i read a plotly i understood it go dot figure and after that the parameter used is data is equal to pie chart is to make you will write go dot pi so go dot pi and what we need to do here now let's see the label is equal to pi so we need to do labels equals to label and comma values equal to count ok this variable i am writing here alright now what we need to do is if i run this much i am not getting the result now i have to do this so let's see what i am trying to do here in this pie chart let me show you what i am trying to say here let's suppose this is my pie chart ok so now let me show you let me just show you guys let's see this is my pie chart ok so now what we need to do here?

let's suppose here this is the part yellow BLUE ALERT så یہ جو LINE BUNDRY یہ 1st ills a Distinguished SHOWNATHA so let's say یہ vala ju part hai, یہ vala ju portion a amara let's say یہ BLUE COLOR okay um.. دیں now after یہ vala ju portion a let's suppose یہ LOCALERT hai okay vala ju portion a amara یہ pink color okay so یہاں pin XSEPREATED LINE DICKNAR CHE E okay so یہ miko bhananay aur ye mein black color se bhananan chaatiyo so let me just show you how to write in the code so what do we need to do now? we have made so many things now we need to make these in the figure, there is no title of any graph so first of all we need to set a title to this or if i just write you should show fig.show and show it and show it so see what we get now right? so what do i get for this graph here i see this is in India so i see 98.3% okay?

and the Germany this is orange color here redish orange color 0.851% united Arab Emirates green color 0.426 and the US purple color so this is my graph and i have made this so i have made this in the code normal i have a country so i have put this in the label and this is what we make here let's say we are labels okay? what i have done in the labels this is the country.index i have put in the label and here there is a person in which country in this graph so what i have done i have calculated the value and set the count and put the count in here so this graph is here but if i just look i don't think i am so professional because what is happening in this graph what is the title of this graph what is the title of this graph what represents it? so i have to add the title now i have to add this blue color in the middle there is no outline here let me show you here let's say in this way here i want to draw a black color some outline let me draw this for you guys there is no outline in this black color so i don't want to draw this so i want to draw this now i want to draw this so that everything is represented in the text size because now there is a small amount of drawing the person who drew this is a small amount of drawing so we will set all these things and add more details okay? since we make the drawing and then we add details the drawing is not that easy even if you practice with the same color it will be easier to draw so if you are in a tech background or in a non tech background the drawing is very easy to draw just give me a second guys let me then continue alright so what is now let's add more details let's make a good graph so what am i doing?

the one that i made let's update this graph so i have set the function update the graph so what we have decided that we will add the title so let's give it a title text what do we want to add here this graph so let's add the title we want to add the current country so let's add the title now i am just running the code so see the title we added current country this title has come to us okay now what we have to do? we have to make a border so what we have to do is update the date and the underscore the traces function let's call it and here is a parameter power in punam so i have taught it so i have told it now i want the label and what do we need with it? we need the value so let's take the label plus the value now what do we have to do next? what do we have to do here?

text info so let's call it as text info text info is equal to percent then after the text is font size we also want to add it so let's add text so text font underscore parameter is equal to let's take 30 font size now color is also black color outline is what we have to do and we have color red and green so let's do this mark parameter is equal to dict color is equal to color is equal to colors and comma line outline is equal to dict and color is equal to black color so let's put it better and the line of black color is white so let's put it and we will do this okay we have seen the error what is wrong with us so we have to say we have some errors let's figure out okay see here the black color is colored double c2 so this error will be shown let's run it now some errors are saved the color is saying error in the path of color let's see what is the error we will make when we make the error but we need to rectify we need to rectify updated updated dot praises over info is equal to label plus value text is equal to present text is equal to dict now see the error is small because the parameter is colored so this is our error generated okay let's take the error and run it now we are getting the result that our graph is being created and now see the black color is set in every label where we have plot in every label we have plot plot plot plot plot plot plot plot plot plot plot plot plot okay further object able to why influencing and unnecessary root وہ ان کی کرyeh asperations mi points of factor saksa isaad hain fluens karta hai Thik hai Quill indents inspire hooram kbul rai Koi bhol rai maapni friends inspire hooram To hami pura ka pura ekseh sarwe hai Isseh analisis nikal na hai ki ki ki tani persint look social media se inspire hooray Ketneh versint look joh hai quapni friends circle sansfire hooray To kuchas tani ki se hame haapis tani analisis nikal na hai Ok To tki hai Pheelao abjaptiv saksas fully complete hooray Dhoosrao abjaptiv ki hooray baad tki hai Aad dhoosrao abjaptiv ki leh na let me just show you ha Aad dhoosrao abjaptiv kye hai hain haapi Dike hai To total yeha haapi hamei jhu banana hai ismi Saksae phele me haapo rafli haapi sansariyo ki banana hai Pheru sehi jeez ko koud kar lehnge Pheleo na jab tk chezeh dhimaak mi kliar niyo ghi to kye sae hamei moe haapi bhaa pheenge Thi kye Pheleo esko sansmajne ki objaptiv kye hai To dhoosrao abjaptiv hai let me just write it here Ok Dhoosrao abjaptiv hai hameara ki Pactors nikal na hai Joki Pactors Influencing Carrier Asperation Bhaat bhaar amlao ki saad bhi asaf bhaa hai Like when we were in 10th class Kye kar loos ko bhoa tha hai Matsle loos ko bhoa tha hai Everybody is aware about that line So abhasi chi ska amlao ko hai haapi Data analytics kye tru sarwe nikal na hai Kye kye sa amlao kye Ok Yaha phe bhaam look Ik pai chat jho hai ghi banana chhaa te hain Mee different colors se le le le te hain Ok Pactors kye tru sarwe nikal na hai Pactors kye tru My parents wala jho hai ghi red Yellow colors se and just taking an example Social media aay wala jho hai Pink color se Influencer wala green color se To ye hamei hapipana na hai Josa phele grap hamei labels and percentage dhoonu ad kye To ye hamei hapipana analytics kru nye Ok To ye hamei image Kye sti chis ko hame ko kod mein kawart ka na hai Kye kye sa karengi aage sko dekte hain So alright Dhoosa ra objectif Kye hain hamei hapipana hai hamei Hedding li kye tiyoon Taki jha bhaap look ki nodes bhi palo na To nodes maa easily available hoha jai ka And acha se sa majmei bhi haa ka So objective number two Objective two hain Pactors Influencing Kareer Aspirations Kye Tooth- Like Or whisker Ok اگر ہم لوگ پیست کر کے پیست کر دے دیگتے ہیں تو یہ ہم نے لیگیم اب کیا کرنا ہے یہ جو گراک ہمیں بنانا اس میں لیبل بھی ہنا چی جیسے پہلے ہم نے بنایا تھا تو لیبل is equal to question 1 dot index تو میں نہ سکسے پہلے آپ کو ایک بلک ایک کام کر دیا ایک نہ کو دم لیوں ران کر دیں اور میں آپ کو question 1 جو لکھا ہوا ہے اس کو میں call کر دیوں تو دیکھیں یہاں پہ توٹل 234 records آریں کچھ لوگ بول رہیں کی میکنس سے سب سے زیادہ инfluencی ہوتا ہوں تو کچھ لوگ بول رہیں کی بہت ارچنج کیا ہے کچھ لوگ بول رہیں social media lingoon کچھ لوگ بول رہیں کی میکنس سے سب سے زیادہ инfluencی ہوتا ہوں پہت کاملی ممبڑ سے نہیں ہوتا ہوں کچھ لوگ بول رہیں کی میکننس سے инfluencی ہوتا ہوں جنوں نے سب سے پولی اپنی کریل کو transform کیا ہے کچھ لوگ بول رہیں کی میکنس سے ہوتا ہوں تو ایسے سب کے Different Different Things تو یہ جو چیزے ہیں یہ ہوں میں یہاں آپ کو پتا چل گی اب میکن کیا کرنا ہے آپ کو label اور cowl 2 s ڈ کرنا ہے تو میں کیا کر دیاں یہاں پہل label label is equal to question 1 dot index اور اس کے ساتھ میں cowl 2 بیچ ہے یہ ہے اولیت سپوز اگر کوئی بول رہیں بیچنس سے инfluencی ہوتا ہوں تو کچھ لوگ از دیاں جو پیچنس سے اینfluencی ہوتا ہوں تو کچھ نے میکنس سے کاملی تو cowl 2 is equal to question 1 dot values اس کو امریکہ آپ کو پہل label اور کل گا لیتے ہیں اب کیا کرنا ہے کلار بھی کچھ سے بھی بنا لیتے ہیں تو اب ہم لوگ رکھلے تھے کلارز is equal to ایک کلار میجر پورشن کا لیت سپوز میں رکھلے تھے میں ہمیں گول کلار اور دوسرا کلار لیت سپوز ہم لوگ رکھلے تھے لیت سے لائد پرین رکھلے تھے ٹکے, لائد پرین OK کلارز لییاں اب گراف بنانہیں تو ٹکے گراف بنانہیں Pick is equal to go dot Picker اور اس کے اندر جو Parameter لگے کا کیا لگے کا پیچھاٹ بنانہیں Right تو data is equal to go dot pi function کو call کر لیتے ہیں تو کی pi chart بنانہیں So go dot pi اور اس کے بعد ہم لوگ لکھلے تھے labels is equal to label ٹکے اور values میں ہم لوگ رکھلے تھے count so values is equal to count ٹکے اس کو رنکہ کرتے ہیں اور یہ جتنا فگر بنہیں میکے لئے اتنا ہی آپ کو بھی دکھا رہیوں کی کتنا بھنا ہے اور کیا کیا بھنا نا ہے perfect.show کو ایک بہر ہم لوگیں ہمیں call کر لے تھے so we are not getting the response here ایک بہر ہمیں اگی اور کوڑ کر کے دیکھنے اسٹیس کو so first let me just run the code here again so question 1.index question 1.values colors am neset کر دیا go is equal to pi ہم نے لگا دیا data is equal to go dot pi ہم نے ہم نے ہاپے لگیا labels is equal to label and values is equal to count so we have done this and pill dot show so we are not showing this again so we do one thing here that we will reload this time and then we will reload we will sometimes get a small glitch when we solve problems so we cannot do this so we can check once we reload this time and then check we can check it so I am just going to do this I am just going to do one thing we will do one thing we have a rose and we will run it so alright as we have refreshed we are going to see that this graph has been made we can understand that let's see here 33.6% of the colors that is the same that is the same that is the same that is the same that is the same that is the same that is the same that is the same that is the same that basically that is the better for some world let's say role models that is the green one we have seen that is the same because we have influenced in our career we have taken a closer look but not family members here in purple we have seen that is the same that is the same that is the same in our career the influences which we are seeing that are the influences and the different different segments in some very good acting and the influences and 9.79% which are the influences which are the influences which are the influences which are the influences so we have made a graph which is the figure out which is the graph but now here what will be the title of this graph there is no title right? and also there should be something that is mentioned in this graph which is here in separate which I want here here I am just showing you that in each one of the three separate the black colors so we have made and this is the graph which is the circle and I have to add a particular outline in it so we have to code here so we have to code here so we have to code here so here pick dot update underscore layout I will call what we will do set the layout here so pick and first we will give the title what is the graph showing so the title underscore text is equals to title we will give this is the factor which is the carrier so factors influencing career sp racians right? this is the title what we need to do is the black color borders so we need to pick dot update underscore braces okay? and what we need to click here so the same thing we have written over info and other things so the same thing we have written over this thing for the objective so I am simply copying and pasting the same thing here so let me just do it here so we are going to copy and paste so we are going to paste this and first we need to think about particularly we have to think about that all the brackets are closed or not so hover info is equal to label plus value text info percentage font size let's say 30 now the dict we have made colors is equal to colors comma line width is thick then color width then two brackets we will run and see now we have graph and how it will come so here it is showing some sort of error okay where is the error paste it might be error in some error here it is a small error text text double double error is shown here okay let's correct the error and now we can see how these 4 prospers are going forward Now we will make the recipes here the nietis...

idea what is the tool it is we will see only وہ complete hoopaya, that objective is also completed over there. So let me show you one more thing here. Now what is our third objective? Let's figure out this.

Okay. Two objectives, both objectives successfully done. We have to take out the third objective. From that data set, how many such particular employees want to go out of India to take education?

From their own investment. So now we have to figure out the third objective. So we have to find the solution here. So let's find out what we have to find out.

Okay. So let me explain this first. What do we want to make roughly? So here we also have to make a pie chart.

Let me show you guys here. All right. So we have to make a pie chart. In this pie chart, we will have different different fragments.

The students who are saying that yes, I want to go out of India. So people are saying that I want to go out of India. I want to go out on the same money and that's okay. I don't want to go out of India.

I want to go out of India. I don't want to go out of India, but if I want to give money to go out, then definitely I will go out. Something like that. So the question of this way is related to this.

We have to take out some analysis here. These are our third objective. یہ یہاں پہ کئی والا کولم ہمارے پس ابھی لے بل ہے جس میں یہی سبال پر چاہ گیا ہے کہ آپ اینڈیا سے بہار ہائر اجوکیشن یا پوز راجوشن کے لیے بہار جانہ چاہنا چاہنا چاہنا چاہنا چاہنا چاہنا چاہنا کھڑ کے خطشے پے تو یہ ہمارا کولم ہے تو اب کیا کریں گے Question Number 2 is equal to وہ والا جو کولم ہیں اس کا ہم لوگیں آپیں نام لکھلے تھے ہیں تو یہ کولم کا نام ہے Would you like to would you definitely pursue a higher education یہ پورا کچھ لائیں ہا لکھا ہوئے ٹائٹ نہ کرنا پڑے اس لیے I am just copying and pasting the things here OK تو یہ ہم نے کر لیا اب کیا کرنا ہے اس کو ہمیں value counts بھی بنانے تو میں ہمیں ہمیں کیا کرتیوں Question Number 2 is equal to data data ke'an dhr column ka nam kiya ba mara Question Number 2 OK اب اس میں کیا کریں گے value counts لگا دیتے ہیں تو dot value underscore counts کیا میں گن کے بتا دے گا پہلے میں اتنائی رن کر کے دکھا دیو آپ کو اور یہاں پہمیں چیس کرتے ہیں یہاں پہیں Question Number 2 ارر بتا رہے ارر دیکھی اس لیے بتا رہے تو یہاں پہیں Question Number 2 کیا جگا Question Number 2 اور اپر میں Table Question یہاں پہیں اس لیے ارر دکھا رہے OK اس کو Question Number 2 اور Run کر لے ہیں All right it is again showing some sort of error Question Number 2 پہ ارر ہے تو یہاں پہیں Question Number 2 اور یہاں پہیں Question Number 2 لیکھا ہوا ہے so let me do one thing here تو یہاں پہیں انظرک دیکھ لے کہ finally here here کیا ارر کیوں شو کر رہے تو میں نے آپے لیکھا Question Number 2 or is equals to اور یہاں پہیں Data Data ke'an dhr Question Number 2 OK لے دکھا رہے لیکھا دیکھا دیکھا دبل انوبرٹٹ پوماز میں میں دال دیا ہے All right اب یہاں رہا رہا رہا رہا رہا رہا رہا اب یہاں پہ لکھتے ہیں Question Number 2 اس کو Run کر دیں تو دیکھا یہاں پہیں اس کا جواب یہاں پہیں یہ ہے کی Yes تو ایکنے لوگ پڑھنے کہ سوال یہ تکی کیتنی لوگ ایسے ہیں جو کی کیا پوست براجویشن کیا حائیر ایسین کیلی کیا کہ بہاہر جانا چاہتے ہیں تو ایسے Yes بولنے والے 110 لوگ ہیں جو کہ رہے ہیں کہ Yes میں بہاہر جانا چاہتا میں اس کے لئے ان کروں گا اور اس کے بعد بہاہر جاہکی میں اپنے studies کو پرسیو کروں گا ایسے جو ہیں سربے میں 110 لوگ ہیں اب یہاں پہ No بولنے والے No I will not pursue higher education outside India SS65 لوگ ہیں جو بہاہر جانا ہی نہیں چاہتے ہیں اور یہاں پہئے جو بولنے والے نہیں لیکن اگر مجھے کوئی میری بہاہر جانے کا کوست کا خدچہ اٹھالے تو میں بہاہر چلا جانا ہوں گا فئے ایسے 60 لوگ ہیں Right تو یہ رسپان سمیہ ہاپی ملچو گا ہے اور اسی کا ہمیں پائگ راکھ بنانا ہے تو اب دیکھیں ایک چیزا گری ہاپی میں کروں Question 2.Index کوگر میں call تو دیکھیں Index میں کیا رہے ہیں میرپس Index میں جو ہمارا Ansar ڈاکھ وہ چیزا ماریپس Index میں آ رہے ہیں اور کسی چیز کو میں اگر Question 2.Index کوگر Count کوگر call تو یہاں یہاں یہاں میری بہاہر جانگہ کوگر SX 10% میں بہاہ نہیں SX 65 لوگ ہیں میں بہاہر چاہ سکھا اگر کوگر ایک ڈاکھ کرے میں کیا ہم سمچھا گیاں اب ایس دی چیز کو گراف میں بنانا ہے تو سب سے پہلے لیبل بنالے ہیں لیبل is equal to Question 2.Index کیا ہمیں پتا ہے پائی چاٹ میں ایک لیبل آتا ہے اور ایک value آتے ہیں چاٹ کیا ہمیں اور دوسرا لیبل دیکھتا ہے کی کنی لوگ yes و لیں کنی لوگ no wale پگیام لیبل is equal to Question 2.Index اور یہاں پہ is equal to Question 2.Values چکے values تو یہاں لکھیں values اب اس کے بعد کلہ نمک سیٹ کر لے دیں ہمیں پتا چلی اس بار کلہرز رہے ہمیں پر کلہرز رہے ہمیں اور اوڑنج اور black کا کمینیشن تو لیبل is equal to Question 2.Index اور افٹر اس کے بعد کیا کرنا ہے پگر ہمیں پہ درک کرنا ہے تو یہاں پہ یہ باکی کا same code کہیں گے ہیں جو کی نہیں جانہ چاہتے بلکھل بہت اور 25.5% ایسے ہیں جو کہیں کہ ہمیں کوئی اماؤں سپونسر کر دے اوڑنجہ تو ہم جازتے ہیں تو یہ ہے یہاں یہاں بھی قمپلیت hiska analysis چاہ کی ہمیں نکالنا تھا ہمارے Objective Number 3 کے لئے تو Objective 1 complete Objective 2 complete 3 بھی ہو گیا اب یہاں یہاں یہ conclusion نکالنا ہے کی ایسے جو کی ایسی complete 3 سال 3 سال تک کام کرنا چاہتے ہیں right یا 3 سال سے دادہ تک کام کرنا چاہتے ہیں right یا 3 سال سے کام کرنا چاہتے ہیں چاہتے ہیں تو یہ analysis امیں نکالنا ہے کیا اچھ کی لئے سپو پتا ہے کی بہت جلدی جلدی لوگ سوچ کرتے ہیں company تو یہ ہمیں employees ایسے نکالنا ہے تو اس کے لئے میں یہاں کیا کر سکھنے Objective 4 اس پرٹیکولر Projecta تو لکلےتے ہیں Objective 4 اور اس کو heading ke format میں رکھلے alright so اب ہمارا Objective تمہاں سکسے پہلے بار آپ کو data frame میں ہمیں دیٹا .head کو call کر لےتے ہیں data.head اس کو run کرتے ہیں اور it is showing data frame Object تکیں ایدو بار لگ گیس لئے رہے اب یہاں ہمارے پر data frame اب دیکھنا یہ یہاں جو data کنسی call سے ہمیں help milpai تو یہ یہاں call میں جاں پیگے رکھا ہے کی کتنے ایسے لوگ ہیں جو کی ایکی company میں 3 الت ایسے ایسے ایسے نکالنا ہے OK اس کے لئے کیا کرنا ہوگا یہاں call how likely is that you work for employer more than 3 years something like that پس کو ہم لوگ جاں پیجا ہے پس call ایسے call mp kopey p s q q q q q q q q q q q q ویسے ویسے آن清楚 اع guests standalone کخ s guys whose ھاہہ ہے ھاہہہہہہ ھاہہہہہہ اس کو میں ہمہاں پہ کال کر لئے تھیو سو پہشن ٹری OK تو یہاں پہ دیکھیں ھاہہہہہہہہہہہہہہہہ جو سوال تہ کہ تین سال تک ایکی کمپنی میں کام کرنا چاہتے ہیں نا تو یہاں پہ بھی 139 دوگ ایسے ہیں جو بول رہے ہیں جو یہ سوال بھی ہوا ہوا ہوا ہوا کرنا but if it is a right company I would try کچھ لوگ یہ بول رہے ہیںentyy 3-nlpkут 2-3-1-xxkwy wehrsme'rpmf اور یہاں پہ سترا لوگ ایسے ہیں جو کے آپے بولڈ رہے ہیں نووے 3 years with one employer is crazy جو کے آپے کہیں کہیں کہ نہیں ہم کام نہیں کر سکتے 3 سالتا کہ کی کمپنی میں کام کرنا is crazy تو یہ Different Different Opinions ame hapvi survey سے پہلے ہیں ہمارہ کام کیا ہے ہم ہے ایسا دیٹانالس تو ہمیں یہاں پہ اس کو visualisation کی طرف دکھا نہ ہے تو اگر دیکھو میں ایسی میں ایک چیز دکھا ہوں آپ کو question 3. اگر میں ہمیں index لگا ہوں گی تو ایک مجھے کیا میں لگا keval or keval دیکھو یہ والا جو part ہوتا ہے نا جو question is there two part time یہ part hai آپ کا index اور جو ہمیں numbers لیکیں یہ والا part hai آپ کا cowards تو اگر میں لیسے اگر آپ کو یہ ایک dot index کو اگر میں آپے call کروں تو دیکھو یہ ایسی ایسی دکھا دی جو ہمیں پہ لکھا ہوں ہے this one kevala so یہ ہمیں دکھا ہے کہ index this index копCK kya formats க liberals کیا پیچھاٹ میں ایک لیبل ہوتا ہے یہاں پروجود کو کرنے کے بعدنا پیچھاٹ کو لے کیا پلو ایک دم اچھے سے کسینز بناپا ہوگے so here a question 3.index because here a question 4.index is very practical because everything is basically related to practice so do practice more on your own کسی کا بھی video دیکنے سے کچھ نہیں ہوگa سبسیں important tech putte سے practice کرنا so do practice a question dot values and color sum look set and color sum look let's suppose what color do we set colors so let's say colors let's say colors let's say one color and the other color let's say red color now what to do?

we have to draw a picture so we didn't make a picture I am doing copy paste so that I am taking more time but when you will project this picture then you will write the picture and type it so that you will practice copy paste definitely this things are not going to walk it out so please practice on your own so here we have to set the title what is the title? the title is how like it is that you will work in one company right? so in this company we want to work in time practice on your own the code is the same as it is copy paste if you do it with the same type because when you type it we used to be in school like a person is not used to be a plus because of the whole square so that the formula is not going to walk it out in the same way if you are coding then type it with the same type no need to copy and paste the things so I am just running this so here we are saying that error is the error because this is the question 3 but here we have just written the question so here is error we have set the 3 so let's set the 3 and then we will run it so here we are getting the result so here we have set the color right? so color is equal to colors so let's set the color okay now we are here the color we have set so here we can see 59.1% people who are saying that yes, I am definitely working in one company if the company is good then it is 59.1% people okay now people who are saying that I can work in one company more than 3 years so 33.6% and 7.2% people are according to the survey that one year one year is crazy so we have analyzed this and the fourth objective today's class total 5 tasks are also available and in 5 we have successfully done done completed that let's move forward now we are doing the question 5 what do we have to do we have asked the survey now we have to analyze this the things that are the employees they are the employees who want to do the remote working or to work so we have to analyze this so that is our final objective that we have environment because today we have a lot of companies who are offering some companies so this analysis is important so now we have our full and final objective number 5 so Python is very interesting very easy to do that but it is necessary to practice and you will feel more comfortable okay 5th objective is we have a clear so let's take the heading suppose I am making a variable but before the variable I will show you the data frame so let's call the data.head okay so now we have to take the work environment once the column is done this column is done what is the most preferred work environment for you like people are saying full remote with no option to visit offices it is a full remote but we do not want to go office so this is the way the column that is used in this data we will use this column to fill the objective 5 okay so let's make a variable here is our last question question number 5 is I will take the question number 5 variable which column we are using here is this one what is the most preferred working environment for you so I will take the column name copy or paste copy or paste and after this what do you want to do?

you have already known here the question question 5 what is the data in the column the name of the column is question 5 what will we do? we will use value so value under 4 counts showing some sort of error question 5 again the same thing here double inverted current error value counts error is shown in the error because we have already two times the error we will take the error we will run and see okay now if we have a question if we have a question 5 we have a value count which we are seeing 60 people are saying that we should fully remote with options to travel as well needed we should remote location but we should travel as well when i need to travel 57 people are saying that we should work 15 days work from office okay 50 people are saying that we should go to office 31 people are saying that we should have a 10 days or less office 26 people are saying that we should work in hybrid working and i should work in the office for 3 days and 10 people are saying that we should not go to office so this is our analysis of visualization so now what will happen here if we will index 5.5 then what will we get here the options are and if we have a count then what will we get we have to have a count so now we have taken the list we have to make a paragraph so first we will make a label label is equal to question 5.index and then what will we make and then we will make a count so count is equal to question question 5.values dot values okay we will set the colors so let's suppose we have a color is equal to what we have and then we will take a green and then we will choose the color and then we will take a yellow one and then we will draw a figure and then we will make a paragraph for the rest of the things we have done in previous code so i have done the thing i have done i have done the color but we are not doing the copy paste so i will take a yellow one and then the response okay we set the color green and the color again okay we can see here we want to do the remote working but when we need travel option the pink color is 24.3% because the hybrid working environment is less than 15 days because of the blue color which is 13.2% the reddish colors are less than 10 days the greenish color is blueish so we want to do the purple color 4.6% which is the complete complete employee's card data analysis to inform the project first we give the project to inform the project and we have done the task we have done and we will explain the project again the project we have done and we will re-pro Hause日 for this long for this the plan that will go to products and source code hai right. Code Aplogo ko Millsaay ka. Code ke li Parishan mo ni ki zurweth naay hai.

Code Industries Helping Handske Learning App me. Saati Saati jeo description box pe niji WhatsApp number dhikra hai. 7,008,001,003,001,002. This number pe WhatsApp kare ke b source code ka data set paplog do nohi moote leisakne hai.

Or anybody from my team will help you in providing the data set as well as the code also. So that's all. This 30 days skip my phone ke masterclass me aalsh ka dind tha hmaara 24. Or 24 deita kata ateita python ke basics.

Python ke patch library ske basics. Or Saati Saat 4 projects tha mlogo nik cover kak liye. Aageyam our class onei bali hai. Doubh srelated to jo bhi doubts hai.

Mujhi comment kar ke zuruur batayega jo bhi doubts kaplog ko aare hai. Or Saati Saat 4 resume kye saye banan hain. Interviews ki kye saye practice kar na hai. Interview me kye aak questions pooh che saat hai.

Aageyane baale in days me hain in deepi discussion kane baale jis ka salibas description box pe nil saayega. So looking forward to meet you in another exciting class that will be the day number 25. So keep coding, keep learning and keep practicing because practice is the thing that makes you perfect and that makes you job ready. So do practice.

Thank you so much from my side.