Complete Data Analytics Course in Malayalam 2025 | Learn Excel, SQL, Power BI, Python & More

Key Takeaways

Hi everyone, so today we are covering What to do is data It is a tutorial on analytics. Okay, this is a terribly full one. The tutorial is about one to two hours long. A three-hour tutorial Okay, Dad, that's us in Malayalam. Cover What are you going to do? Very simple to capture Okay, then we'll cover it. What is going on in Data Analytics? Why Data Analytics Data What can you do after studying analytics? Let's go to careers. No, what are those skills? Things we should discuss Okay, let's go, Sohar Kamsar Data. Analytics Tutorials for Everyone Welcome, okay, let's have our What is the outline of the course? Let's just run it and see. Okay, so what do you mean by first one? Introduction to Data Analytics Data We know what analytics is. First, let's understand, then, one of its Introduction and data Some applications of analytics We have to discuss it. Let's take a look at the app Hatubikkam Data Analyst A data analyst What should we do to become what? You need to learn the skills and tools needed for that. And many other things like that. Data Analytics Workflow We are a data science tutorial. As soon as I said it, some work on it. We had already said that. A few steps It was said the same thing. Here too, we have to follow many steps. There is something to do, so here are the steps. What are the essential tools for Data Analyst Okay, here's the data. Tools that analysts should know Okay, so what are we doing now? The tools being used are now Tools that will have scope Many such things in this one area We will discuss then. Statistics for Data Analytics Okay Statistics Without data analytics, there is no such thing as Let's talk about statistics. There's a small portion to cover then. NumPy and Pandas in our Python The libraries used are NumPy and So that's what we call pandas. Must cover and pandas Data cleaning and EDA using Python, that's it. We're covering things, okay? So let's look at this again. There are a few things about data visualization. Using Map Liban Sabon and Namukoru Maybe I should do a small mini project. Sales Analysis Something Like Us It can be done with a career roadmap and Portfolio building is okay, that's it. Things we should discuss Okay, so this is one of them. What is meant by overall structure? What is data analytics? So data When we say analytics, we mean maybe... The only thing we know is that Insights from the data at hand Data is a process that takes It's okay to say analysis. Before going in to this Let's talk about what data is. First of all, the date. There are many ways to say OK. Data is probably text. Format may be available or It may be in a number format. Or audio data image data Video data is of various types. Data is created for example. If I were to say my age What is that? It's an age. Okay, now I'm If you mean to say my name What is that? It's a text file, okay? And I'm giving you an image. What is an image-related Data is data and I am video. If there is giving, what is it? Video is video data, right? To collect data together, many We have sources, right? In the case of traffic jams We are not in the traffic, we are in the road case. When we look at our There are cameras to capture this. What about the cameras that do that? Data is stored in all cameras. How to become a large amount of That's where data comes in and gets stored. Now, any person who follows traffic rules If there is a violation, there is that one particular This is our camera, a photo of the person. The seat is captured just like that. People who drive without wearing seat belts Capturing the photo. Then Driving without a helmet People are often captured in photographs. So many photos in that one short time. These cameras capture I do. That's the kind of data. What is meant by Big Data? What if you say, "Okay, big data"? What is a huge amount of data? Handle our traditional systems The data is so big that it can't be done. We call data big data. An example is given. If you say so, on Facebook. In one minute on Facebook we If you take the world wide web Only on Facebook in one minute How many image posts will there be? There will be a lot. So such data That's a huge amount of data. We call it big data. Okay So there are so many of these I fish. Types of data are available. So That is data. Okay Then I said yes, then data. What was given was data. This data What do we perform by using Doing? Analytics Perform Doing. Oh, we are recent. A little while looking at it The fish have been scarce for some time. For years, data analytics The field called data science Scope or its demand? Saying too much It is a growing period. What if you ask why? The increase in data is its Okay, so the reason is data. It's not a thing to say now. Okay, that's our earl. A scene that happened on stage It's okay to say that the thing is data. Then I took the like stoneage itself. If you are looking What do we do at Sculptures? Old people used to note down the data. Data is being etched into stone. Oh, so what is data? What happened to the data on paper later? So then we got printers. Computers came along and so did data. The use of saying has been brought up. And when it was 200, the internet came along. Communication came, data collection came. In 2005, Big Data came along and sparked the idea of ​​Hada Spark. Technologies like... Then it Then, around 2015, this Data science and data that says Declining popularity of analytics Even more. Later there He became an MLA there in 2018. The demand for that one area that is said It's so big that it's scary. Let's just say that. Really In other words, this data analytics and data The term science is still used. Nothing, it's early 1960s. It was a term that came up, but Its demands have only increased recently. If you are giving an example, now What are we doing? If you are doing it, let's go online. Online shopping is available. What are we to do when we say Purchase any products I need to buy a phone now. Or some things If we want to make a purchase, we What does Amazon depend on? It is used. Fipkart It is used. So each one It's apps. Order food items now. If you want to do it, let's go to Swiggy. There is Zomato and many more. There are things. Grocery Let's go shopping in Blinket. Can be used, can So in the case of fashion, purple There is so much, so many. The apps are currently unavailable. So, this is it. We purchase each item in each app. What do we enter when we do? We are the data that is being provided. What is entered is data. What comes up when we say our name? We give our location. Giving, giving, our age. Our date of birth is ours. I give a lot of things like that. We give our preferences. We are beating this. What is this customer data? Our data is being hacked. This is customer data, and these are other things. What do we collect? When was the item purchased? How much quantity was purchased? How much did you pay for the purchase? Months we purchase Or what we purchase What are the seasons? Who is collecting the details? The company is collecting, so... Let's collect and do this next time. Amazon or Swiggy, you say? When opening Zomato These are the things we like to do. We will do it, which means maybe we are the next one. Are you going to make a purchase? This is what I will be purchasing. I will give it to you. So what we are saying is Data science or data Some applications of analytics Is. So this is the data for me. What I want to say is, okay, so this is data science. And the demand for data analytics It's more like this now Bikos data is increasing. Every minute is like this Generating now. Searches per minute on Google Think of it as a request. Okay, so that's 5.9 million. One day we will consider If you are doing it, 8.9 billion Okay, it's coming. How to generate data so quickly I am telling you now. Talking, what am I doing? I am. What is create here too? What is happening is data creation. It's happening, okay then. Demand for data As it grows, this one What is called the scope of the area? It's getting bigger, okay, so this is it. About data is what data is. Analytics data analysis says: We use both terms interchangeably. Used here and there They are used but the two are not the same. There is a slight difference in data analysis. What do we do when we say We collect data first. From the data we collect, we That process of gaining insights We use data to gain insights. Data is called analysis. When we say analytics, we mean data. A little more about the analysis itself Data is one of the advanced Analytics is like a Data with a small prediction part Coming to the case of analytics Okay, so that's the definition. Let's take a look at what it is. If we say data analytics What is the process of examining? Data Sets to Draw Conclusions About the author Okay, okay, from our data. Draw conclusions from the data. What is the data we get? It says many things from many websites. Not websites, but many sources You can do it via Meby Webscribing. We can collect that data. Okay, okay. These company databases Let's get data from the bases. It's okay. So in many ways We will collect the data. Then, by collecting it like that, you get What is not data? Never meet Maybe not. Okay, then something like that. We perform many things on data. There is work to be done. So I told you. There are a few steps to discuss. So those steps are completely We have to finish it. We did it. We only get into this process after What is the process and what is the data? Okay, examine the sets. Examining the Data Set Examining the Data Set What do you mean by data sets? The data we have is completely Understand what data is If I say set, what am I now? As an example said a while ago Our customer is a particular The customer's name and address His location is probably his birthplace. Date and then what items did he have? How many have you purchased? How much did you pay for the purchase? Done, now when I say this, every Things are like every detail. I was saying this. Number When I counted, what did I get? Seven. Data I mean, I got seven dates. Like Name Address Location Date of Okay, so everything is fine. How is this actually happening? This data is probably sitting there. Saying in a table format He must be sitting there, say for Examples I have a card like this in my hand here. Now I think there is a table. What is the customer name? Maybe first the customer name is C. A customer name that says Column and maybe my age What is being said is another column, okay? Location is another column. How many items did I purchase? There is another column called How much did I purchase for? That's what another column says. It becomes a data store every now and then. The details of the people are like this, one by one. It must be coming out as a rose. Details of the first customer The whole store will be like this here. Second customer details This will make the store the third Store customer details and so on. Oh, there are so many customers. Purchase each product like this. Either way, their data will be lost. It will keep increasing like this, okay then? What can we learn from such data? You have to examine the data. Let's complete that data set. You have to understand its ins and outs. We need to know completely, but only What do we get from it? Get insights from the data set. Take the exam. Why take the exam? Conclusion about what is being done Information provider Information from that data To understand completely Let's examine this data set. Doing this is what the one doing this is doing. Data analytics is a process. Now we can call through that. What can be done to transform raw data? Inu actionable insa now I said that one I showed you the table-like structure. So what does that data look like? Just like Rose and Columns Let's just leave it at that. What can't be done with that one? Let's set up a specific table. There's nothing I can do about it, Dad. How can we make that raw useful? What is this data, our raw data? What we are saying is that we can make that raw data actionable. Insights should be changed to Insights What does that mean? Take the information, that information. When we take, we have many questions. We'll get the answers there, okay? Now, Informa Decision Making and From there, we can make the decisions we need. Main data that can be taken When we say analytics, there What Nuk has to say about data analytics Speaks about the past okay Data is about the past. Analytics says that in the past We are wondering what happened. Okay, what can be understood here? What's up with that, Dad? From understanding that Let's make the right decisions now. What's next? Identify that anda The patterns we have got We can learn a few things from the data. We have examined it and from it we We also got some conclusions, didn't we? From the conclusions, this data Is there any train or Are there any patterns? Let's understand that now. Customers Maybe Customers Maybe Christmas items for this Christmas season Like we decorate the Christmas tree Items used to do this Maybe they bought a lot of it. You must be doing it, then like it. They will purchase these for next Christmas too. These are purchases for Christmas beyond that. A kind of pattern of doing They can track it. That's why such a trend Patterns are also what we need here. It is possible to do it. What can I do to understand? Optimizing Process and Improving Efficiency, father, efficiency is our one. From the particular information we can To understand many things We can and also we need decisions. Helping our business We can make decisions there too. What's next? Competitive advantage then this We have a lot of data analytics to talk about. Okay, now let's use it in areas. Let's say it's a competitor of Amazon. What is called a Fipkart? Something in this one insight Any offers from or Something like that. After giving them everything, Their sales can be increased. Okay, that kind of thing. They can do things here too. Okay, that's what we're talking about. What is meant by analytics? Okay Now let's discuss an example here. Okay, Dad, I have one in my hand. Okay, ice cream is sitting at the table. That table is for sales. I visualize the table here. Okay, I've done it. Instead of looking at the table or Instead of looking at the numbers in the table, This is what we will see when we see the visual. A little more to understand After looking here, we can easily You can see the most Where did the sales come from? It came in August. How much is 77% of sales? Okay 77/96 Where did we get 96 96? The ice cream we have Sales are OK in August because What was in August's case? The temperature here was the highest. The most you can see is OK 22. And in July, 22.9 came. But when looking at comparative The most ice cream is in August. Let's say sales have come in. I understand, okay then. We plot that data. The visual that has been done is ours. We use the data at hand We use it from Creating visuals So from this visual I get What do we get? Insight is being gained from this data. It's not enough to just look at the numbers. That's what we can do quickly. When we look at it, it gives us It doesn't have to be correct to understand. Okay, what should we do instead? We need to visualize it, then our Visualize the data at hand Make it happen, show it, like it. Now the bar chart Even though it is used, the pie chart Whether used or Using any other visuals That one process or that one that shows Data visualization is a technique We are here when you call. Bar charts are used. Bread here on the X axis we are months What is the name of the place? We at Andy Axis have given Sales have also been given, so let's You can see it here. The highest sales are in August. We can understand at a glance The highest sales are in August. What has come and what has come It is in June. Okay, so it's July. What happened to Dad when he saw that? That's correct for us. I understand, okay then. That's what we do in data analytics. When using visualization, its It's okay to call it an advantage. Fine now types of data analytics So when we talk about data analytics... There are many types of it, Dad. What is that and more? Discus It is essential to do it first. One is Descriptive analytics What is Descriptive Analytics? As I said a while ago, young man. What happened in the past? It is descriptive. Analytics says it's up to us. I have a past date in hand. Okay, let me give you an example. Last Onam season Last Onam season From Bangalore to Kerala What is the number of tickets? Two days before Onam, two days before It sold out quickly and then... Because like what is this? What happened? What happened? Tickets sold out quickly. Okay, so what happens during the Onam season? Who says that? Descriptive analytics says Next Diagnostic Analysis What is diagnostic analysis? Understand why something happens in the Why did it happen? Diagnostic analysis is Sorry Diagnostic Analytics What do you mean by diagnose? Understand what happened. Diagnose as its name suggests What happened? Understanding is diagnostic. Analytics is that one thing we talked about. Onam example, that one Onam We have seen the example. Why is it doing more? Asked if the tickets were sold out. Then we can understand there. It was Onam season. That's why Onam is celebrated in Bangalore. Tickets from Kerala That one number is very Suddenly Okay, that's it, what's next? Predictive Analytics Predic Predict what will happen in the future? What will happen in the future? Okediva is going to predict there. It will happen in the future. What will happen then, our time will come again? An Onam example If you are saying Next Onam and next year The same will be true for Onam next year. More tickets coming soon We know that it will be sold out. While I was standing here, this one As the year stands, the next year Predict what will happen. What can be done? Predictive analytics Saying Next Prescriptive Prescribe analytics We have a solution for that. Understand that this is the same in the future. Understanding that it will happen Once you understand that it will happen What can we do to solve it? Give it some prescription. Okay, so what should we do with it? Or how to solve it? We are a solution that In prescriptive analytics What is action? Out comes the father who is there for it. What is taking solutions? What Prescript Analytics says Okay, if we want to talk about our Onam season... Maybe Railway Team Just an Example Just to understand, The railway is an example of this. What do they say to the team? Multiple From locations to Kerala The number of trains can be increased, maybe. What does Mumbai say about Kerala or maybe from here? Chennai to Kerala trains Maybe we can increase the number, but it's just one. The solution is or Tatkalkota Let's make it a little more open. They have every solution like that. Okay, so that's it. Its use is said to be When you say descriptive What happened in the past? Or in the past, this is the past. What happened in the past? Why when we say diagnostic It happened because we Understand the third is predictive Once you understand the reason, it Will happen in the future or What is going to happen? We predict then What will happen with the prescriptive saw? Once it is predicted, it Providing solutions for Prescriptive analytics It's very difficult to say all these things. It is important that we are a business. Even after taking the domain and looking at it, this There will be completely, okay then we Now when I go to KFC... Saying "Wednesday Offers" There are so many offers, why is that? What they are doing is to increase their sales. They just offer it. A term that says we are the people we are now. We like to purchase when we go on an offer. So what are we actually doing? What they do is increase their sales. All this is being done by giving. What is this business? Okay, so this is what strategies are. Or what are we doing in this way? Doing data analytics Or data science is one of our What about decisions for business? Okesa is helping to pick it up. These are the different types of analytics. What does Next Apps say? What is off-data analytics? Its applications are in areas Okay, energy, then it's coming. Finance and Banking Government and Public Sector Healthcare Manufacturing Marketing and Advertising then Real estate has retail and Ecommerce Insurance Transport and Logistics in this area Apart from this, there are many other areas There will be, okay, Dad, that's what he says. AreaSilaOKE Data Analytics Applications are coming for energy What can we say in the case, maybe? How much was the power consumption or power How can we optimize? Such various types of analysis Let's do it there Finance and In the case of banking Has there been any fraud? Or risk analysis and so on. Let's understand things then. In the case of the public sector If so, are there any resources? Should I allocate it or something like that? Let's see things and then health. What can disease say about Care's case? Hospital Data Analysis Patient Data analysis and many other things We or many such One of its applications is in areas. What's the reason for coming here? Data analytics is in the areas Applications Other Areas Like In many areas like agriculture We have applications for this. Okay, now it's time to become a date. Analyst to become a data analyst Key skills we need to know What is First One Technical? When we talk about skills, we The most basic things you need to know It's one thing to say a sequel. What does sequel mean? What is Structured Query Language? Why do we use To manage databases We used to beat this. All the data provided is in the database. It's time to go to the store. How to retrieve data from a database Let's take it out or data How to store or How to remove data How to update data Telling us many such things It can be done using the sequel. Okay, so we need a sequel. If so, then maybe a sequel. We have a lot of software available. Okay, then there's a sequel to Like Me. Then there is the sequel server, Pos. So many types of sequels Actually, okay, so we're first. A sequel to our basic Must be covered. Now let's look at our case. If you're talking about my sequel cover It would be best to do so. So we need a sequel. And then Coming in to Pine or Are you any father? A programming language like Python or R Do you know any of them? It would be good. Okay data. Why Python is needed in analytics Not actually mandatory. Butt Good to know anyway. It is an advantage. Okay, then one thing. Let's go to Python or R. In six If it is, a lot. Statistical Methods Like Statistically a lot All the things that are supportive It is available in the language that says "R". When coming to Python What can I say a little more? A little more. It's simple for us to understand. My general purpose is very easy. It is a programming language. A lot Applications, web applications, even We can use Python for web applications. To create using Okay. Okay. And Python's one Advantage means its There is a huge amount of libraries. Each Built in to do the job There are many libraries that exist. This one We are using algorithms in machine learning. Even if it is built-in Many algorithms are in our Python. Supporting. Besides that We also have many pretrained models. What can you say about using Python? It can be done. Okay, I mean. It can be reused. So that And is an advantage of Python. Like in other programming languages Lots of heads of files and stuff. We don't have to give anything. Just now I have two. If you want to add numbers What should I give, both numbers are enough? Just the formula to add to it Just give it in Python. But other Programming Languages ​​Like Java Or something like Cplus Plus Programming Languages ​​We Consider Its header files when doing There will be plenty of them. Head Files Type In addition, each integer We declare what is. There are many things that need to be done. There are things. But what is that? No complications in Python Not coming. So, the pine cover is very simple. To do it. So what about Python? It would be nice to say cover I am doing very well. If you want to say it, it is. I just say it's mandatory. Excel says Next One. What does Excel mean? Excel maybe? We are little children. Maybe we excel in time. You may have seen it, but Excel is not. Everyone is just when they say It's just a spreadsheet. What everyone considers is BaExcel. Ackley Ri Powerful Okay Apo Excel We have many things to do. Can we clean our data? Let's do the missing values. If it exists, it can be treated. So many things we can do in Excel. Okay, I can create it. NL has many billable functions. Everything is also available. Let's create visualizations and whatnot. Let's create using Excel. Okay, Excel, I can do it. Then we need to cover Visualization tools are visualization tools. Why Visualization Tools Excel? There are already visualization tools. Why are we saying this? When you say other visualizations In Excel's case, we have a disadvantage. What I mean is that it's over rose. When saying too much becomes too much Or that one number of data When saying too much becomes too much Excel less performance wise The possibility of a decrease in Excel's case is low. Performance may be given sometimes but Other visualization tools like MaybePower When using BI, it It's a little more supportive that way. I can't hang up, okay, Dad, that's it. There is an advantage besides that. When we say visualization tools Mainly powered by BI and Tableau Okay, I suggest Power BI. When you say do power BI It also has advanced graphs. Visuals also help us create a lot. There are so many slices to do. Visuals and drill downs and so much more. We set things up there. Bookmarks are available for giving. So we can create each one there. It's super beautiful, you can do it. Pawaba is a dashboard that has been Let's create with If only Pawaba Asian Go for Tableau Can cover any one Statistics okay. What is statistics? Up Info Inferential is mandatory. Statistics, descriptive Statistics etc. There are a few things to say. So We'll cover all that. Okay. And Then the next one. What is Next One? Analytical things. Now we have covered the technical It's skills. What technical They said they needed skills. Now We need analytical skills. Is. Okay. Okay. Okay, fine. So-called analytical skills What do we need there at the time? Critical thinking, problem solving, Attention to detail. Okay? So What do you mean? Let's have a If you have a problem, Maybe a large data set If it has been given, that data To understand what a set is The talent is okay, it's kind of like that. Logical thinking is there for us. It is necessary, no matter what the problem. There is no logic to solve it. If so, let's do it. No, so you need logical skills. We have problem solving skills there. It is very necessary and then comes Soft skills are the backbone of so-called skills. What's up when it comes to the case? Communication Storytelling and The business is about communication. If you say so, maybe our stake When they say holders, they mean Like a technical background It doesn't have to be, then we have this Told them what to do The ability to give said it. The ability to understand is a Story requires communication skills. How much is this telling capability? Let me tell you nicely, okay? A story like that, bread We need telling capabilities. Besides that, business activity is a A story about a particular area Knowledge is also essential for us now. What are we doing next? What to do? To become a data analyst We now have the skills needed. Said. Technical skills, analytical Skills, soft skills, that's what we do. Said. What do you need now? Next Unit Continuous Learning Continuous When you say learning, it's a week away. Each technology while watching the week This is how it is being developed. There is a lot we need for our field. Technologies like this It is growing. Let's have bread. So what are the technologies needed? You have to stay updated. We do all things. You have to keep learning. That's what we are Here with continuous learning Meant. Staying updated With new tools and techniques. Okay So what is mandatory? Okay So, these are the skills that make up a data. You've got it covered by becoming an analyst. Gotta go. Okay Now Data Analytics Workflow Data Analytics Work How is the flow? So first one problem Clearly understand the definition What is the first reason for the business question? Problem definition That is ours or we That one domain that's going to work We must first clearly state what it is. It is necessary to understand. What do we do after understanding? The problem is to be solved. I mean that one complete Let's understand things first. That's what we're here for. By problem definition Meant What data collection will come later? In the case of accidental data collection If it is, what are we saying? Gathering relevant data from various sources So I said, "Already, let's collect." There are many different ways to say data. Okay, maybe one from the sources. Our company data will be Not to have on hand If so, I'm web scripting. That website I mentioned a while ago A method called scribbling Data will be collected through It is done in many ways. What is coming? Data collection is coming. Okay, so we have a lot of information from various sources. Just by collecting data There may be some mistakes in it. It's possible, okay, then collect data. The next important thing is to do it. Step by step gathering Data is very huge. Process update collection It says it comes third. What is data cleaning and preparation? Data cleaning and many more things We have to do handling missing. Values ​​one of the main okay missing What is meant by handling values? Is there a mandate inconsistency? If so, How do I remove it? Are there any formatting issues? Let's be in the case of the like spell. Or in the case of white space Maybe there is some issue like that. Is there a way to handle it completely? In the process called data cleaning Not only these things happen. There are many things like Outlaya. Manajia Ques and so on Okay, that's all for us. There is no data clean that needs to be done. If so, what should we do? We need to clean up the rest of our analysis. We are in the process of This is what you need to do to prepare the data. Things are happening, what's next? Exploratory data is coming. Analysis exploratory data What is that thing called analysis? From a cleaned data Understand its patterns. Understand the trend in its entirety. Details and summary of it Description and complete things EDA means understandable. Exploratory data says Analysis Okay, is there an analysis? Look, let's test the hypothesis. Where are things coming from? In exploratory data analysis Data visualization and Communication Presenting the most effective reason why we What can be learned from that one data set? Are things invented that are very Show off your efficiency. Or clear Take insights and stake the business Give to the holders or whoever It is clear to them that it requires Please explain. Their data visualization is It's okay to come to and communication. So this is a five-step process now. What did we say? Our problem definition is data collection. Data Cleaning and Preparation Exploratory Data Analysis and Data visualization is okay now. Few tools for data analysts We said how to become a data That data is now for the analyst. Tools for the analyst are OK. In the case of spreadsheets, which A spreadsheet is all we need. Microsoft Excel Essential Sheets We need to use all of this to our advantage. What can basic analysis do? Now you can do cleaning and visualization. In the case of Database Enquiry Let's go to the post office together. Or my sequel can go or Sequel server is gone, okay then data. How to manipulate data How to extract it We have many things here. Can I program it to do this? In the case of languages, Python It is very important to know very Good data cleaning analysis In the case of machine learning visualization, we can Can be used if you want to get to the six. That's for statistical analysis too. We can also use visualization. Now you can use the power of business intelligence tools. We call BI Business Intelligence. That's what tools are for. Or that business intelligence thing Let's use one as a tool. Which one is suitable: Tableau or Power? Okay, so using this is very useful. Interactive dashboards Can be created and taken. What comes next is the cloud? Platforms okay a little more When you are going to be advanced What we need are cloud platforms. One is AWUS Okay, Microsoft's Usher. Then Edubuys is our Amazon. Then the product of GCPgal Clafo Gin So what is this for? Use big data and that This is for scalable solutions only. We are talking about cloud platforms. We can use or we can So, let's use all the things mentioned in the first part. Things are very important, okay? Our first Four Points That It's spreadsheets and then databases. The programming language and the Business Intelligence Tools Are Mandatory And the next one is a little higher. What happens when you reach the level? This is where cloud platforms come in. If you cover any one, it will be very That would be good. Okay, that's all. What is a data analyst? Essential things to know It's okay to say tools now. Statistics for data Analytics without data analytics What we need to know in the case Statistics one Descriptive Statistics The second is inferential. Statistics and so on Things we need to know First one was descriptive. Statistics Okay, so that's descriptive. In other words, the description is in our hands. That one about the data set What is a description? Calling is descriptive What is called statistics Okay, so our data set Describe the main features. When you say "Let's do it" main features Whatever it is, there will be fish, median. There will be a mode, there will be a count. There will be, right? It's 25% We are the median of this 50th century, which is 75 years old. That's what it's called a lot. Things are so that the data set Complete information about In descriptive statistics we Say goodbye to annoying features Audrey Hepburn The next one is included in this In descriptive statistics Rain is one thing that is included. Off Central Tensi Mesha Off Central Tensi We are in small classes. Learning what the mean is and what the median is Okay, what is the mode? What was our fish? If you have IP 10 data in hand, then 10 dates or those 10 numbers Add it and divide it by 10. What do we get if we do that? We get fish. What is another name for the fish itself? What is the average or They say arithmetic mean. Next, if we say median, median What is the median? A data in hand If it has been given, then in that data We call the middle number the median. But to find the median, Formatted data Either in ascending order or First we arrange in descending order. And then from that we will Find the middle one again there. We have a couple of cases coming up. This is what is meant by given data. Number of numbers in our data How much is 10 times 10? When you say numbers are numbers How many odd numbers are there? I was given ninety dates. If so, from those ninety data I find the middle number. Okay, after sorting it out, Finding a middle number If so, what is it? It's the median. Now, this is my number, number, I have it. If it is 10 data, then what is it? If so, from the disaster data We will use the two numbers in the middle We take it and divide it by Okay, so what do we do? We get the median, we get the median. So to find the median, we use these two There are cases, what is the mode of the final? What does the word "mode" mean? Repeating number or most Let the repeating What's up? Whatever data is in it. Coming up frequently That one member or that one What do we mean by number? What is called mode? Okay, so these are the measures of central The trend took note of its name. We will understand after watching. Measures of Central Tendency Central What does it mean when you say "Okay Central"? It comes in the middle of this one. When you say fish, you mean In the data given to us in it When adding all the numbers, A mid-number between a set of data. We will get it. Likewise In the case of the median, a middle number You will get it. In the case of the mod It will still be a mid-range number. Get it. That's why that one name is Measures. It's called off-central tendency. Because then what are the measures of Dispersion Measures of Dispersion When we say variance standard deviation If you say range ok variance Whatever the variance, the standard Whether it's deviation or range, date How much is the spread? Why is that? Means Measures of Dispersion What do you mean by okay then? Frequency distribution frequency What is meant by distribution? How much of each product is there in the given dates? I have five of the sups that came once. Okay, assuming the product exists. One in five products is a laptop. There is another laptop again. There is another laptop and a There is a laptop bag and a mouse. There are so many products. Imagine three laptops. How many laptops did you get? Three came in a laptop bag. How many came? One came, I said. Next product, okay, how much is that? It says "Mouse Mouse Mouse" How many times have you come? You came once. Okay, so that's its frequency. Laptop three times then What is the frequency of a laptop? Saying three is three times. Come, that's why we are here. What is meant by frequency? What is meant by distributions? Okay, that's descriptive. This is what comes up in statistics. Measures of Central Tendency Measures of Dispersion and then frequency Distributions Okay, so this is ours. The reason is very important in the case. Missing values ​​something If there is, we manage it. Even with this fish, the median Even if you put it on or put it on mode That's okay. There are many cases for that too. Yes. So what is called an outlier? I said one term. So our If there are outliers in the data That one particular outlier If there is a missing value in the column We would have put it as the median. Replace. No outliers If so, we will fish it. It will be replaced as it is. Dad, for each of them. Unique techniques Okay, so this is all. Being aware is very important. It is necessary and then it is next. Inferential Statistics We just said descriptive, didn't we? It is said that the information of data If we say inferential, then in that data What conclusions can we draw from Taking that is inferential. With statistics we What is meant by "make children"? Prediction about population based on The sample of data given to us What we take from a data What is inference? Okay, now on to the statistics. What will happen in hypothesis testing? That is, the one we have brought The matter or us Any matter raised To test if it is correct We have many testing methodologies. Yes, it's okay in statistics. We call it hypothesis testing. Okay, one of the things we mentioned. The thing is, we don't know if that's true or not. Proving is a kind of proof. So let's test it. What do we have Hypothesis Test? Yes, okay, like there is a T test. There is an ANOVA test and a chi-square test. Yes, there are so many tests. Before we knew all this, we Two important things to know The terms used are sample and The population is called an OK sample. That is to say, a small number of people If you say that, it means a huge number. What is a small part of the data? It's called a sample. Calling Now we have a very simple Let me give you an example, now let's say rice rice. To take and cook If you're posting, what is a like? Let's take some rice and cook it. We'll take some rice and cook it. Put it down, okay? What is that? We subtracted the population from it. Is it just a matter of taking it out? I'm checking to see if that rice is cooked. How do you look at a spoon? We took a little of it and cooked it. Every grain of rice, except for looking We're going to burn it, picking it up. Just a little bit from it. We are taking samples, so... From a huge population, A small sample is a portion. Sample is the same as sample and population. A difference between Okay Up Sample Terms like "and population" This hypothesis is very, very important. Doing hypothesis testing etc. In that case, for that testing The methods used are our Test Anova Test Chi Square The word test is a joke. Linear Regression Logistic Regression So we have a lot of that. There are techniques now for this logistics. Regression is actually a Coming together in our machine learning A classification model is a time Linear regression is called regression. The model is so similar. We can do things here. All these things are possible. Be aware is our thing here. In the case of statistics, this data It is mandatory in the case of analytics. Now we are going to discuss Our Python libraries are what we are Like, I've said a lot so far. Data Analytics What is Data? What are all those things? We have cleared it. I understood that besides For data analytics Key Skills Required Like Excel Must know Seek Must know Visualization Tools Like PowerBI Business Intelligence Tools Power BI and Tableau There are so many things you should know. We said, now we are Python. We have used this one Tutorial Data Analytics Cover Okay, what are you going to do, Python? You don't have to use it yourself. You can use Excel if you want. If not, you can use PowerB. Otherwise, you can use Tableau. Okay, but we're here to cover it. I'm going to use Python, so... We are there because we are Python. You should know a few libraries. Okay Library Pandas called NumPy Then the mapplot lip c bone this Things or these libraries Be aware of the data Using analytics to improve It is mandatory at the time. Okay then. Start with the first library, okay. What is NumPinPin Staff NumPin? And it is one of the ம யஸி஫ிக்கிய in python python supportmultipledementia Andaman What is the full form of Up Napute? It is numerically pine, so its As the name suggests, numeric numeric Related tasks One that we use to do The library is called Nampai. Okay Lots of mathematical calculations Like Scientific Related Many types of calculations We can do it. So Nampai When we say that, our Okay, that's what comes to mind. Arey Appa Arey is related Calculations are what we can do here. Making in the form of a matrix In mathematics, we all say In time it is called the Matrix. That's how we say it. Such matrix operations It's all very simple, very simple. We are here for calculation. We can do it and we Arithmetic performed on matrices Operations and what is subtraction? Multiplication and so on Things are possible for us here. It's possible. There are many built-in features for that. It is available in the functions number. We can use all of that to our advantage. Can do various calculations Libraries like Pas Maliba And Psyche Are Built On Top Of The Ass Okay, now for other libraries. We mentioned the name a while ago. What are the Pass Maliba Cycle Learn? That's what this says. We have developed the library. So Nampa is based on Nampine. That is to say, everything is basic. If there is no number, please pass. Libila Seabonilla Nothing Okay Dad Nampa That is to say, the basics of everything. What is Numpai to know? Father is mandatory, that's our name. The library that says "Okay, now next" It's okay to say that the library is the pass. What is Open Source Libraries? Builder on top of the Nampai Library Nampai On top of the library that says Pandas is a library that has been Okay, so data manipulation. Data related to tasks We use it for all tasks. It is a very common library. A very useful library It's okay to say pandas too. Pass off various data structures and Operation for Manipulative Numerical Data anda time series time series Related operations are also free. Can be handled using When you say "and pass" In Universal Pandas, we have three types of data: Structures are the reason for the mention. First one series, then comes data. Frame and panel, so three Types of data structures are Available inside Pandas If you say series, a single column is okay. That single will be a single column. The values ​​inside the column are The term series actually refers to the series. What will not happen? The column name will not happen. Just one column will be the values. There are only values ​​there. What can we not have there? There will be no name and also a single column. Only in the case of the series Coming next is this data frame. When it comes to the case, we have a table. Structure is the mind. What should be brought is the table structure. What will the table look like when you say it? It is a collection of Rose and Columns Rose and What is a collection of columns? It's called a data frame. The call is the same as the data. What does frame mean? Collection Of Roses and Columns, of Oak and Table When you say "What's there?", the column Hedda Columns will have headings, that's it. By data frame I mean, I like the series now. If you want a one-dimensional array, Let's say our data frame I have a two-dimensional room if you want. Let's say that the next one is the panel panel. When you say that, in a 3D format There will be data frames. It's too much to say that Pandas is a collection. To put it simply, the series It will be a single column that says Okay, like this, a single column like this. There will be a lot of value in this. There will be, okay, what will happen here? Let's start with the heading in the case of the series. It won't happen anymore, this is the case of the series, okay? Now the case of our data frame What happens there when it's time? There will be many columns, okay? What headings will be there for the columns? There will be something like this, say NMS. There will be many column names. Many, many, maybe a few columns. There will be or there will be a lot There will be columns, so that's the column. There will be names for every rose. What will happen and what will be the values? Correspondence to each column with Rose There will also be raw raw values. S This is called data frame and series. Saying. Now what is called a panel? Pandas Data Frame is more like that Never used. But there is a Data frame cold panel in panes ok So this is the About Series data frame. And panel. Okay Now data cleaning using Pandas is OK. Data cleaning using Pandas I'm ready for us to do it. We said that using Pandas What is data manipulation? What is free data manipulation? Manage data or Handle it, so what? We handle it in the way that We prepare our data. When you talk about the workflow of analytics A process called data preprocessing The step is very important. We say it's steppe. I had said that bread was a date. Preprocessing can be done in Python. The most we always use A commonly used Pandas is what the library says Data analysis using Pandas When preprocessing, follow it There are a few things to do. What are those? Are there any missing values? Okay, let's check that. Using methods in Pandas, we can Something is missing in the data frame. Let's check if there are values. Can be done in case of missing What if there are values? Let's handle it. Many types of methods are available. I already told you. In descriptive statistics Measures of central tendency There is a part that says that the measures of What is central tendency? What is mean? What is median? Yes, there is a model, so our data Any missing values ​​in the frame? If there are any, those missing values What we treat or It is handled either by a fish Maybe we can replace it with There are no outliers in the data set. If so, then the missing values Let's replace it with fish. What is our set of allurements? The data is too far out of range. We are looking at a point that lies What is called an outlier? A model without such outliers If the data set is and that one Missing values ​​in the data set If there is, let's fish it. Fish that can be handled Okay, let's replace it. In case I have that one data set Suppose there is an outlier. If so, then the outlier What do you think of the column? The median is good enough to replace. To be replaced Okay, so we are the mean and median. Using numeric columns Only in my case, I have a Assume there is a categorical column. What is a categorical column like string? We like the things we like. What are called categorical columns? In such categorical columns If there are missing values, What we are replacing is the mode The reason for categorical columns is because Let's apply mathematical operations. That's why it can't be done. The one that is most frequent This will be placed in the particular Or that one particular value What will we leave behind? Replacing what is missing Values ​​in the categorical column Replacing missing values Okay, that's about it for the missing values. That is what Next Dealing is all about. Outliers, okay, so at our points. He is a person who lives far away from What is called an outlier? I have a phone in my hand right now. There are children's marks in the class. Imagine the children in that class. Marx says Win is a 60 and Think of it as a 75. All children's scores The children's scores are also 60 to 75. Imagine a child in that class The only mark I got is It says 95 so that's a set off. Too far out of range The person lying down has a score of 95. That one child I have. What we call an outlier That's why outliers are like that. If there is, why should we deal with it? What needs to be done is handling the Skewness is the skew in our data. There is a factor that we have mentioned. Allready said it was normal. The case of distribution is normal. Distribution is done in this way. It will be OK for normal distribution. What is actually called a curve? It would be a bell curve like this Okay, why does it say that? If you say that, the bell curve is shorter. It's special because we Draw a line like this through the middle The potion on this side and the potion on that side Portion Equally Distributed It will be 50 here and What will happen here too? 50s Okay, that's a symmetry. Maybe there will be some, okay? The data we get is like this Normal doesn't have to be symmetrical. Distribution does not have to be followed. Okay, mostly the data we get. Or something called data. Almost normally distributed It would be like this on a date that has already happened. The data will most likely be a bell curve. Let's follow you. In the data obtained, one of these The distribution is not a bell curve for us. If you get it, please handle it. We have to manage it, okay? We don't get the curve in one way. How can we understand that? Now we use data. This is how it is when plotting We have come to the point. Think about it, okay, so here's a tail. Where did that one go? Okay, to the left side. If so, what is this? Its meaning is that it is squid. Similarly, now we have skewness. Maybe this is how you got it. It may be extended to the side. What is that too, it's the same as the squid? Okay, what is normal distribution? What is the same on both sides? There must be an okay bread, this is a skewer. Is this a distribution or This is a graph we have drawn now. If you ask if this is skewed, this is It's not skewed, it's symmetrical. What is a squid? That's the length of the side only. This is the length of the tail of a tail. It's scary to say that If there is more, then it is. Squid took this figure just like that. Even after looking That's scary in a way. Is it extended to the left side? Sorry, it's a little too long for a figure. The length is longer towards the right side. So what is this one figure? What do you mean by "squid"? Okay, so that's it. Is there skewness in our data? We need to check and in case so If there is skewness, then Handling is mandatory. Okay Okay, so once that's handled too... To do all the things you said. What do we have in Pandas? Functions There are many built-in functions available, okay? We need to check the skewness. The function that says just skew Just give it to me and I'll be fine. After giving the function How much is the skewness? We will understand the normality of skewness. Value is a uniform or a normal The data lying in the distribution The value of the column selector in the data. It is said that always comes from my own home. Or positive one, okay, minus one. Must be between positive and negative Okay, after going beyond this... The skewness is so high. I get the meaning of it. What is the value of skewness? Within Sopofa Okay, it's positive. If so, that's good. Okay, we have good data. It is said that it has been received. I got the meaning. Skewness Win - 0.5 and 0.5 If it is true, then very good for us. The scan we got is my one and a plus. If it's one, it's manageable but If you want to get out of this What should we do with it? Handle it. All you have to do is do these things. The reason I say this is very important. We do all this with Pandas. Data preprocessing is done using The incoming import is small. Things are OK, once Pandas. Data cleaning and things using After we've done everything, then we What to do with exploratory data It is analysis. Exploratory data What is analysis? It It is useful to analyze and investigate. Data Sets and Summarizers Critical Off-Employment Data Visualization Methods. Okay. What about our data? Complete information about Now we understand the data. After all the preprocessing is done, maybe We deal with the missing values ​​in it. The skewness in it must have been done. We must have handled it. The outlines must have been removed, so many We have done things too. After doing so many things, again We need to take a summary of the data. Why do we need it now? How much data is there? How many columns are there? Such complete things Okay, so it's okay to understand. Once we do that, then we can The ED can come, so this is what Samma says. We are exploratory about everything. What can be done in data analysis? Exploratory Data Exploration Explore the data well. Do it completely and understand it. That's what we are exploratory about. What is meant by data analysis? This is exploratory data. What can we do to analyze? There are also visualization methods. You should use a piece of bread from India. What data visualization is also part of? That's okay, then data. Again, let's do the visualization. Pine libraries are available. I am the initial. I told you, now we have data. In visualization We already know that there are many libraries. I told you, didn't I? Then that one We are now visualization libraries. First of all, the data you are going to look at is Let's talk about what visualization is. Visualization helps understand data. Graphical representation Okay, then I Allready showed an example Didn't you give me ice cream? Let's give an example of sales. This is an ice cream salesman. Let's make a bar graph. It was painted. To see that one table Instead, when we saw that visual, To understand a little more. It's easy to say that... We use data visualization Libraries are one of them, MathPlotLib. And Seaborn is a math plot. What is the full form of lib? Matrix Plotting Library Math Plot liba ok matrix plotting It is about plotting libraries. It is said to be one of its aims. We have various types of plots. We can build here. Can you draw a line graph like this? Let's draw a plot. Let's draw a histogram. You can draw pie charts and so on. Charts are what we create here. To do it, you must do it for the best possible purpose. Packages for visualization Performance Library From or to used or asylum This is a trend graph with data. This is what you can draw here. LibreDive Ode for Creating High Quality Visualization Very good visualization Beautiful visualization We can create. Okay, that's about MathLib. Okay, what I have to say is, Seaborn is coming next. What is Seaborn? Visualization Libraries Built on Top of Math plot ok up math lot liba Developed using It is a library or MathLib. Develop by keeping it as a base It is a library that has been taken over. What does Seaborn mean? What you're saying is, okay, Dad, let's do it. Visually appealing and informative Statistically Can create graphics Very beautiful graphs There are still additional things that cannot be found in the map clip. We have a lot of graphs with Seaborn. To be used and created Can be used as a level InFace Creativity Op This heat map is called Macro Label. It wasn't possible, okay, and that's it. What should we put here? Seaborn is good for creating. Okay, you can do it using So that's what they say about Seaborn. Library Now let's look at some libraries. After discussing about it, Nampai said Then Pandas said Malot Liba Said Seaborn and then Exploratory Data Analysis We are all here to tell you what it is. Just saying, it's okay. So this needs to be understood more. If so, why should we? Let's get down to practical things. Let's do it. Okay, let's do this. Everything that has been said is completely true. Okay, let's try it. Move into the practical sessions So, as we said, now it's time to say goodbye. A little bit of a library that says Let's take a look at the practical sessions. Okay, that's mandatory, so Nampai. We need to start with the basics. Okay, okay, first of all, let's go. NumPy Installation How do we install NumPy? Installing P install numpy When we give, our NumPy is installed on the system. I'm going to do this Python thing. We have a lot of Python editors. Like is available, like is available. Then what is an atom? There is a spider and so many things. Okay, so many libraries are available. Or after using so many ideas What can we do? Can you program in Python? Besides that What is called Jupiter Notebook? An ID is also available. What is special about Jupiter? What we are saying is, cell by cell Run the code and see the output immediately. You can see the Nuk soon. Okay, that's like a Jupiter. Another one we can use Notebook is our Google collab. Says a Sagul provides Platform Angoul Collab Very similar to Jupiter. Okay, so all the things we need. Just do it right here, and your sauce will be ready. You don't have Python on your system. If so, you don't need to install Python. It doesn't matter. Directly Legal Collaborate Let's run this Python code using It's okay to do it. Sadat Online Editor, we are here now. Used by Google Okay, I'm installing the collab. The code is written. What is the code? When you say install numpy When it runs, our system What a great thing to say from a man like that. That is our Will be installed into the system Oh my, this is actually a Google collab. Because that one process of this installation Or that one step is mandatory No, that's not actually necessary because All libraries are online. Our Google collaboration provides Okay, and now you're doing it. I use Jupiter etc. If so, then you have to do it. What is a list of install numbers? Let's see, okay? I have said what is the list? That's a basic one-liner. The list is a very important data structure. The specialty of Apo List is simplicity. What is the list? Store Heterogeneous data is called heterogeneous data. What are the different types of data? Floating number that can be stored Point or a string Let's say it's a boolean value. Whatever happens, whatever happens. So those kinds of values Or who will handle all this? Our to-do list We can handle it, okay, Dad? Look at the list in this way. We are now the type of people who sit there. Just print it out and try it. The data type is a list. We can see it, okay now. Comes with importing NumPy and array creation If you want to use NumPy, then What should we do first? How to import Nampine? Doing Importing Nampine is done by Importport Nampai as NP okay Nampai we are short It is called NP. Okay, let's call it NP. I don't want to give it to you, what can I say? If you want a convention, you can give it to me. A standard naming convention What NP says is that programmers So this is what is used for NP It would be best to use Okay, so import nampass NP. Now I am here for my first time. ARR is about to create an array. My name is Zero. Given by SR CNPD AO 42 If you say so, what is NP dot here? A function that says array is called numpy. What is the array in the library? I am using an array using a function. I create inside the room. A single value is given. 42 and ARR zero as stated I stored it in a variable. Now when ARR displays zero What can we see 42? Here we have a value that says What can be seen now is ARR ZeroDIN dim. Is that what we give as Endim? What is the dimension of our waist? What can be seen is okay. We are here for the dimension of the father's waist. I have given you a reason, half a half, that one. Here are the dimensions of the particular room. I got it that it's zero, no? We just need a single value. What we gave there was especially There is no dimension, it is zero dimension now. ARR Zero Dot Shape Appam This is an array In a method that says or That thing called a numeric array. Once we create it, Characteristics of the particular cavity Used to detect Attributes are n shape and size That being said, first we shape Take it and hold it while taking shape. Okay. There is nothing inside that one tuple in the dimension. Not shown M is our array. What is zero dimension? It means it has no dimensions. This bread is especially shaped for a waist. We understand that there is no zero. Now I understand what a dimension is. When ARR zero dot size size is given What we got there is one. We got it because of the items we gave. How much was one item given? 4 So since we have an item, we can It turned out to be a size one. How many numbers of elements are there in our body? Yes, that's our size, why? What do you mean by "Okay, Dad, Zero Dimension"? The era has been created and now it is the One Dimension Era. Okay, how to create it? I gave a variable ar1n What is a circle bracket? How much does it cost to buy a Five Elements? Give one two three four five so five Okay, thanks, given by Elements. I will store it in ARR. Done using our array method I created it and got the result. What do you get for that? That's four five. The Five Elements showed us I took the data type of the cell and printed it. Done and finished. Show that it is an array and say that it is an array. What is the dimension of our waist? How much is our dimension? That is to say, it is one dimension, so that is one. We create here in D-ara. What has been done is next ARR1 Dot and dim already, we said, "Ara." A way to find dimensions The attribute is what is called the N Dim. How much is our income using the San Dim? Here we have dimensions. We can find out. What is here is one dimension. Having said that it is one dimension We got it. Next One ARROne Dot Shape Okay, when you say "the shape of your waist" We are already creating a zero-dimensional array. When we did, we got an MT. It was a tuple, right? So here it is. While we are looking, What is ARR.dot? When given the shape, five is a comma. I got it, what is this? Indicated by Rose and Okay, so what are we doing here? Only given to us How many roses have only been given by Raw? There is one, two, three, four, five, okay, apofive. We are here to say that Rose Showing. Okay, so actually here. When we count, we When you say "rose," Zee says one by one. It will be shown as one by one. Let's say the butt is here. There is no rose. So here we are. Showing the number of elements Here we have the following in the form of Okay, I got five. Again, when taking our size The number of elements is five. Okay, so I gave you half a dollar. Is it dimension one, is it dimension two, is it dimension three, is it dimension four? How can we know if it is true? You know, what we give here? Number of brackets It is according to. Say, there's a problem there. No, we only have one bracket. If it is, then you can say that. Is a one-dimensional array and if we Inside the chamber where the C is given, like here. Two brackets are a the N. If there are two brackets, then U Can a two-dimensional array be equal to an array? Inside the circular brackets we have an array The method is given and the circular is included. What am I in brackets? First, a bracket was opened. Done, opened a bracket. Inside I took the first list Our second list is also available. Okay, give it to me. The brackets are closing here. Where are the brackets for this? It's getting close here. Okay, let's have some extras. There are brackets, we are like this How many fish are there at first when looking? How many brackets are there? In time we will understand what is the Is this the type of like that or is it a different room? Is it a 3D room? Wow, okay, then Namukt. Got it. So let's put it inside the waist. Looking at it now, how many roses are there in total? Let's see if there are two roses. It fits the shape of the S.A.R. What do we get when we take it? Number of Rows and Number of Columns Up How many roses are there here? There are roses. When you say "Okay, number of columns" How many columns are there? Okay, what's next? What do we find there in the room? I am getting the result now what is the D? Type D is what we call our Another attribute of the room is our What is the data type of the cell? A type of attribute to detect So when giving the ARRT type What do we get in 6fa? It's an integer. We know that data type is Now we understand the size of the room. What we get when we give Okay, so what's the result? What we need to know is the waist size. Got it here, what's next? Import number ASNPARTA NPDeva This is Faiza, what is this? This is a two. The example of dimensional ray is okay. Now next is the D array creation. How much when creating We will have brackets outside. There will be three brackets, just like that. We have three brackets here. Okay, let's just like that. Create the required arrays We can do it here. Now we have taken a three-dimensional array. What happens when it takes shape? What happens is that three values ​​are one We have a particular tuple You get one of these, okay, Dad. Values ​​are also indicated. What is the first value in this? It says number of panels, okay? When we say number of panels, what do we mean? First panel and this is the second panel Okay, so it's two panels. How many roses do we have in each panel now? Yes, that's our second value. How many values ​​are there in the first panel? There is a rose in the first panel. How many are there in the second panel? Rose is one and We have two roses in the second panel. There is that one that says three more. What is the value of the number of columns we have? How many columns does one have? We have a total of three columns, so We have three shapes here. We have received data after that. Take the type and take its size. When I say that, here is the point. Counting all the totals you get We get the number of elements. That's the dimension of our size OK room. We took it and we printed it. Okay and again we have another room. Very Simple Three is creating Look at the dimensional array, here we have a total of There are only two or three elements, okay? And here we have given According to the brackets, it is a three. We know that it is a dimensional array. I understand why you are printing the case. After doing that, its dimension Print it and take its shape. We only have one panel. A panel has only one row. There are three elements or We also have three columns here. Clear is the next step, take the size of the room. What is the size and number of elements for this? The number of elements we get is How many three elements are there for us? I understand, now we are together. Normal Using the method called array A simple room to create We have created the arrays that are In addition, we have many built-in To create a type of eraser Can Zero Era One Era Emry Array Identity There are so many types of eras. We can create. A few such races Let's discuss what it is. So starting with zero is its That room is completely as the name suggests. Zeros will be there, that's why there are zeros. The name came from Nowa Epida Zero Circular Bracket 2pcs What happens when we say One kind of shape was given to two. Rose three columns two rose three When you say column, what does create mean? The three rose came and the three columns came. Zero is next, it's one ra one ra. What is it like when you say it? That era will be completely unique. What are we in it? Give shape, give Kafat Rose and Four Column One This race is four columns, one is four. Columns came, that's One Ra, now MTM. What does it mean to say "ara"? What is the difference between what we gave and what we received? Its number of rows and columns It's okay, but MT is a What is special about MT's room? If we say it will happen, our Garbage value collection in memory We have done that in our MT room. That's what's special about the MT room. Next One Identity Ara Identity To create a room, we need to There are two built-in methods in Napil So. It has a built-in method. Identity Next is a built-in method. What is meant by this identity is the waist of the father? What is special about the diagonal? What will Elements Completely One be? That will be the identity of the waist. Special C, let's take a look here. You can see it here: NPDOT If you say identity four okay four What is the number of roses when you say four? And number of columns because Identity The Matrix says Evil Always If you say bask matrix mass What is the number of raw numbers and the number of cos? Okay, then let's have both. No need to give, just one. Just give us a single value. Number off column reason identity The case of the identity card in the case is a nugget. Just a single value inside Columns that are given for What is fish and what do we call it? Printing Printing What are the diagonal elements here? Complete and one-one-one diagonal elements Show that you are completely one. What are the rest of the elements? Zero is okay, that's the identity card. The same thing is called Nuk I. You can create a circular even if you put it there. Put it in brackets, Monsto. The column diagonal elements are completely one. What are the remaining elements, zero? Has this changed? This is identity Ray. Next Random Array Random Array Again As random as its name suggests The values ​​will be in that one chamber. Okay and Cnipodorm The function called rand is For that we use numpy. Random in the library that says Ran from the module that says The function that is used is: We give it a five inside. Indicators Number of Elements Five The number of elements is a What is needed in a particular random room? I'll tell you what it is, okay then. The values ​​I have received It says that five values ​​are floating. This one will be the point numbers. What we get in the random room is okay. And C again, we are in another random room. Create a Fat Rose and Four Column Here we have a two-dimensional array of Okay, then create. When creating a dimensional space Again C is what we got there. Some random values ​​are in decimal. Format OK Next One Range Array So we meet here in many ways. To create arrays using What is range range array? When you say A range, We use the method to find the range. Creating the array inside 10 We are the values ​​that say Okay, what is the array? From zero to zero Values ​​up to nine will be Print and show that it is a goat. Where is the number you mentioned? We won't show you the end because of the range. What is the function that says "mainly"? If you give a range of 10, it will start from zero. It will be printed until 9, just like that. An array that calls itself a range Using the method, we get zero The values ​​from to will be Printed on our waist Showing OK Gain Next One We create the range. What is 5k 15k ok five? What is our starting point? We gave the range and started from there. I need up to 15 and that's a step count. They said, "We are here." Given: Five to 15 sofas Starting from and ending after 15 So 15 won't cover it, just before 15 Up to means up to that is 14. What has been said. But here we are Step count to two. It has been given. Step count to How does it happen when you say Started from five and finished 5th. So that's what you call plus two. What is our step count? What do you get for plus two? Okay, so seven. Nayan left two numbers after that. When it comes to the same thing, it's two. Who comes after numbers 11? The numbers are coming. Like two numbers are changed. We are next by adding Elements are found in this list. Okay, let's go. Not arriving, just arriving. When you fight later, the number is 15. Get it, you don't need 15. Method stop ok apofa totha What do our values ​​go up to? Going to OK Next One Boolean When we say that Era is Boolean Era, it means Click to create. Especially the methods that are billed There is no such thing as a caning condition. Based on condition, we are here. Creating by Wabian Epida is already Five Elements. And I also gave a condition. What is included? Condition Bolan Underscore Ray Greaterth Let's create together as a room. The given value is ipdo area. When we say that, we get a room. It is a room called Forfa. What we get as a result is Father, the elements in that region are greater than What is it when you give it? Happen in that particular room. Which numbers are greater than three? We have everything big there. You see, you're getting a true nugget there. True is found, false is found wherever it is not. Next one is coming, full ray, what is full? RayFAPIDA Inside full circular brackets We should give less value. What does it mean to say 15 full rooms? It is complete inside that one room. What value are we giving to that? That will be completely based on value. If it's a Phil, then we'll give it to you. What happens when you give to someone? The inner 15 15 is what we have given. Our shape is okay, two roses. It is a chamber that comes in three columns. We need 15 elements. We mentioned that there. So here we have a full array. Got it. Now next we will talk about line spacing. It is a method that has been mentioned. Using OK line space A bill in method as stated What is the Billen Method? That means a number from zero to 10. Value will be a thing for us. In the resultant cavity Be available. Okay, here's five. What do we mean by five? Five is just a value given. We need the number of elements. Just saying, 2.5 or 7 So five values ​​are needed, Bay of So. Any number from zero to zero What numbers are inside it? Decimal value is optional. Will be and also C here equal We believe that distribution is not necessary. It has been said. Okay, so that's what lens space is. The method you are talking about and then another method. Reshape is now a part of our waistline. If the shape is what it is, I can change the shape. That's what Reshape is all about. Meant by Saga Lin Space We put a line space and A half has been created 10 times. I have a total of six elements. A two that says 10 and 20 How many values ​​are inside the value? If we want this one particular You can get it in the closet, but only six numbers. Elements dad and so we are in a room. I created it and now I'll use it. Go get a reshaped one, this one. After looking at the shape of the era, we can I understand this is one dimensional. What does this have to say? Six Elements Okay, then Six This will be the shape of an era. Okay, I'll get it now. How to reshape I'm doing that again here. Okay, Era created it first. I am that one era with apostrophe elements. I created it here. It's about to be reshaped. Because we already know the way Here are the six numbers of elements. There are six occasions for us. How to get six fish What numbers multiply? You only get six when you do it. When we multiply, we get six. You will get a sik when you multiply. I will get it. When multiplying by and six We'll get six, six and one. When we multiply, we get six. So, in what way do you get six? We can factorize Okay, that's one way here. We split the value of Reshape. Never give up. You can't give me a penny, Bist. When you give, you get this 9. Because we don't have 9 elements here. There are only six elements in the complete equation. To give us in the form of Even if you ask if it's okay, I can't give it to you. It's 4 here, Nuk 12. There are no elements, only the element is there. Factorization Values ​​of Six We must be inside the reshape. Okay, so what you have to give is 2 letters and 2 letters. When we do, we get sick. Then he gave me 2 cards, then 2 cards. When I gave that one to you, That one with the first six elements How do you get two roses from Arain? That gives three columns. Even though I made it, I still get good bread. That's this one array or reshape Let's reshape the array using Doing or its that one This is one way to change shape. Okay, now that's it. Number of Elements Ivisify The range is a range that we give. There are number of elements inside. How can we understand that? I just created a variable. And then I did a size of Ray One and then I did a Creating a range array I gave 100 there and here. A value that says I am five. Our step count is given. I gave it to you now or that. A value from 100 to 300 Inside is the Five Step Count. When you say it, there are a lot of numbers in it. Values ​​are never set manually. It's not about counting. What is practical bread for us? Let's use it for that. That one that says the size of Numpy Built-in method or that one After using the attribute How many number of elements are there in it? We have what we have. Okay, I'll find it to find out. You can give it like this, you can give it like this, no If so, then there is no variable. Directly create this one without What will be the way of giving? Okay, so that's what we're going to do. How many elements are there in our paths? There are ways to find out. Now next we will do it on the waist. Okay, some calculations going on, Dad. We just call it array arithmetic. Okay, that's it. I put some values ​​inside the chamber. I printed it as "Given". I got a room, now with that one room. I'm giving you a plus five, what's up? It will happen, I created it. All elements in the placed cell The result with five added in addition 25pfa+faspafava Okay, 58+F 63, what is that in a way? The results are actually going to go. Okay Okay and then next one print Are you minus one, dad, here it is actually? What happens is I have given All elements are my original elements. What is 25f 56 a 58 my original is So what is meant by elements is this original? Subtracting five from the elements What happens when this is a result? It is obtained similarly. When multiplying, its You will get the result when you do the division. This is how you will get the result. What are we doing? In our midst We perform arithmetic operations. Doing. Okay, next time. Indexing and slicing are coming. Very The operations that are important are Be aware of indexing and slicing That is mandatory. So When we say indexing, we mean C. Each one inside the chamber is given Every element has its own position, okay? Here, the element called one Position zero is called Andutu. The element's position one is three. The position of the element being mentioned So, this zero one two thing. We commonly refer to those positions as Okay, it's called Index. So I can say that in the zeroth index There is an element called One. The element that says "at first index" It says three in the second index. The element is the fourth index, five. That's the element that says so to me. Let's say that's the actual index. What does Konda mean by indexing? What is in each position? Access Elements is Ackley. What is meant by indexing? Print in score is score area what is here We have created The square is in the middle of the square. I am zero inside the brackets. What does that mean there? Occurs in the zeroth position. We access the element here. Doing. Which is our zeroth? Element in position? One more here. One has been accessed. Next in Arscore array one three third position Which element is in the third position? Print Element Four Apo Four How is that third position? I understand this is the zeroth position. First position Second position and Third position, then fourth in third position We got what is called "is", so this is one. We index in the following way: Next comes slicing. Okay slicing is another word for It is an important thing. Okay, slicing in Python's case. It's very important, Dad. Okay, let's see what that is. In underscore array one one colon four okay Okay, this colon is bread. What is meant is a slicing operation. What do we mean by colon? Okay, so how much is our original waist? There are five elements: There are one to five, one to three, four. Five, so five elements are ours. What is inside this one room now? I call it slicing. What we intend to do How to do one column or one column for up to, that is, from the first element Okay, up to the fourth element here. What does one column four mean? It's their positions, not ours. The values ​​inside the cell are not OK. So who is in first position? Okay, so the second one is. Saying or saying one From the said position to the fourth position This is the first position, this is the second position. This is the third position and this is the fourth position. And again, something to note. The last thing while slicing We skip that one position of the element. Which is the last element off? Finally or here we are That one given for slicing Is there no position? That last position? We skipped the last position. In the positions immediately before it The column to be printed will be the value. How do you say "four"? First position Second position Third position We are in the fourth position, then the fourth position. Skipped first to third. From first position to third position We will be values ​​up to What is being printed? This is the position, the value in that position. We have 2 cats and so on. Okay, so what you said is what you got. That's how we slice it. We are serving it at Appa Slicing. When giving, first of all, our The ending gives the starting value. I'm giving value, if you want more Let's add a value with a colon. Let's give that value that is given. What does the actual step count say? It might be okay, but our Starting value Ending value Give me a step count. What is optional is our requirement. Just obey and if you want, just Just put a single colon. Let's have that one particular of ours. Printing the values ​​in an array You can take it. Just one Only a single colon is inserted. If there is a giving, that one Completely, that one half completely, let's You can display it. Okay, Dad. We do it in a way Slicing saw, you should try this one. Okay, so it's true. Simapple now has elements inside the waist How can I modify it? Okay, that's what we'll do now. Going to modify the saw. I created a separate array. I am doing 10 20 A three-valued word that says Okay, I'm creating here. I printed it out and put it in my room. It says 10 20 now. What am I doing here, lying down? Giving is the way Oh, that means first position is okay. How do we access an element? What we need to do is create. The name of the room that has been done is square. Bracket Square Bracket Inside The element we have given Given that position, what are we doing? What I do is access Given the position, it said 15. So what does this mean? 15 should come first in the first position. Who is the current element in position? This is the Apo Mod Arscore Era of Vasa. So I gave it to you in this one position, okay, so. Instead of 20, here it comes in this way What can we do with our waist? Now we can modify our Two-dimensional arrayTwo-dimensional array Indexing and access using How to access Elements What we are looking at is, "Okay, Sapada." A. We have some values ​​inside. Give it to me, Faiza. What is this two-dimensional ray here we have There are three roses, two or three roses. There are three columns. Bread An element from a two-dimensional space How to access. So here What we say we create In that one room that has been made In the zeroth row and first column The upcoming Element Zeroth Raw This is what is said, this is Zeroth Raw. Zeroth Row This is the first row, this is the second. Okay, now let's talk about the column's case. This is what Liqufasa comes from. Column FA comes from the first column. That's what that is, that's our third. It says column but position zero one. Say "and two second column" Okay, Dad, according to our needs. In the zeroth row and first column The upcoming Element Zeroth Raw is also first. Which column is the first column in the column? The first column up is zero. Coming in the row and first column What is an element? So, I printed it here for the goat. Now Print iscore to square bracket We have given the shop inside, so Second row, okay, second row, second row. When we say Raw, what does Zero One and One mean? Then this is our second row. What is the second position in the second row? Second position zero means second column This is the second column in the second row. Which is the second row and which is the second column? The zeroth column is the first column. Okay. Our first column says 39 Okay, then the second column says The second of them The element that comes second in the column Coming in the row and the second column This is an element, okay, dad, so... Which element is here? Then we Printed Okay and Similar We have similar slicing operations. There's a lot you can do. Okay, then let's get to the next one. Somewhat basic array aggregation There are operations, and those operations are us. What I'm going to say now Okay, so I'll do it again. Array created with four elements I have an array and I calculate the sum in it. How to calculate the sum Doing AGG underscore ray dot Okay, our name is and dot. I'll give you the sum there, then dot. What is there when you pay? What happens is that a particular All the elements inside the chamber We are adding here. We are here during the update. The result you get is 55, okay, then sum. I got the same amount, not just a lot. When you say operations like Simen Min What will happen to that one-room minimum? When you say you'll get the element, Max. The maximum element will be obtained in the same way. Let's calculate the fish. Calculate standard deviation We can do so many different types of operations. We can do it here. Now let's do two eras. Must concatenate or join If we want to do it, we can do it too. Let me join Ray One here. What has been said is an array. Create and join the room and so on. Ray created both one-dimensional It's Ara. I'm going to call now. I'm going to join both. How do I do it? Let's see. A concatenation is called Bill method is available then that one This one using the built method Let's perform concatenation. That's a good thing to do. Concatenation or that one A function called concatenate Inside join one join two Okay, so we gave them both. We have joined, join result. Those two at the time of printing Elements or join those two arrays Here are the results we have done. It's okay to print and display. Next One is another method. That's what I mean by "ok search". One that we use to do The function is the one that says "numbered ver". Method Again I Create an Array After saying that the original room is being renovated, One, three, four, five, four, four, and so on. The elements are now free. I need to search for an item. The item you are looking for is being searched. Imagine searching for Appa. The function we use is What are you? Original within circular brackets Arscor Arafa We need to check if there is any in our We don't want the original Arekkakathu. We check if the element exists. It is a condition that is given to do. Is there a four in equal or equal to? If so, what is its position? What positions are for printing? The third one is shown as having There is a four in position, let's check. Let's see if there is a four in the third position or is it a zero? Position is first Position is second Position and This Thread Position Thread There is a four in position, as well as a fifth. Who is in the 1st and 6th positions? There is an element called four. Let's see what it is here. Yes, it is possible. Next we have what is called CA. Let's check if the element exists. Originally called Six in Our Room There is no element that says "But we are here" Searching for "six" Is there an element, then look here. What can you see here during the time? There is no element called six. What is meant by the result of an era? What's up there, zero, nothing for us? We haven't got it because we're there. There is no element called six, okay? What is Appa Array Split? You can create variables in a snap. We have a variable called Create it. We have a few inside. Added elements too It has been given. One two three four five We add six such elements. Done. Now split the arrow. This epidode is a split and Inside it, our variable We gave the name Array to Split. How many eras should I split it into? The next one is "Oka Apo Three". I want to split it after erasing it. I have already said that. Let's do it here in three eras. I got it split. There are six elements in total for you. There was one, two, three, four. Okay, Dad, I'll give you six of those elements. Here are the three eras of the Elements We split it up, okay, dad? That's how we are here. All I got is the Next One. Split underscore array array to Split coffee okay again what are we What we are doing is multiplying our original array by five. Split into elements That is, one array is divided into five arrays. So we split here. This is how it was done. What are we doing in the way Splitting is no longer possible. There are many methods available for sorting. Okay, reverse the array like this. Many things are just our bread. Okay, let's go to Namba's official website. Dad, there's a lot of this in it. There is documentation on how to use it. Many built-in methods are also available. Just take it all. Okay, now take a look and cover it. Let's go to our next library. Let's go, that's pandas, okay? So yeah, okay, Dad Pandas, okay, I'm fine. Saying that here in the case of Collab we have No need to install, okay now. I just imported Pandas. Immediately after importing the PANS SPD To check the version The given function is We got three data sets in Pandas. Structure is what we need. One series that can be created First comes the data frame. Which panel was it? There are three of them. Let's create here. The first one is the So First Namal series. Creating the Saw series Creation So Pandas We Are Nothing More Importing Series One We create the variable mentioned above. Done and Pidot Series What is the series in Pandas called? What do we add using the method? Done, we added the elements. What's inside the bread you gave me? There are a lot of elements coming here. So many elements came up. We add the elements to the series. It's printed in this way. I said the series is coming. Remember that the series is printed At the time we have the column name. There will be no values, only values. And also an additional thing that Says each of our series What about the values ​​in the raw? Similarly, index numbers are in the zero position. 35 6 in first position and so on We will get values ​​now. What we are going to do next Okay, so there's a list of things to do. A list of what I did again. I created it and now I'm making it a series. You should convert it to . What can PD do about it? Using a method called series Elven said that series inside it Put it inside the method you are talking about. What will it become after that? It will become a new series. Okay, so let's start our series here. I got it printed and it's okay. Create a dictionary and use it What can we convert to? Let's convert it to a series. This is a creation in the style of What can we do in the many ways we have said? Let's create our series. Let's create, okay, just like that. As we said in Eras, this is what we say. This indexing in the series We can also do slicing. It can be done very simply. Okay, okay, just like that, integer-based. Indexing and location-based indexing There are two ways to say it. Or label-based induction like that Indexing can be done in two ways: Indexing can be done here. Bill Medus can be used and left alone. Otherwise, built-in methods What can we do without it? Is this indexing possible? Okay, I'll do it now. What are our aggregate functions? Yes, just like it was said in the title. What can we do here too? To create aggregate functions Okay, okay, here's the series. This is what we actually say. The sum of the values ​​within a series Which gives the series sum? What happens to us during this time? Sum of all the values ​​in It will be taken. Similarly, mean median max min Standard deviation variance We have many things like this here. Okay, let's calculate it. This is about the About series. Okay, so what I have to say is, every single thing. You should try it. If you try it, This is the only way to clear it up, okay? nextWest moving Idu data free data What is meant by a frame? We call it a series. You told me, didn't you, Dad? Collection of Rose and Column like a table There will be a structure for that. What will be the heading also be the column? How can bread be made with names? Creating a data frame is like this: First of all, I am a Data One. Create a variable and put it inside it. Like I'm actually a dictionary Creating is okay, Dad. Dictionary's What name does the key say? What is the next age? Our key is its value. Similarly, the city is the key to its values. This is what I see, okay, my name is Age. And city so three three There are key value pairs. Name What are the values ​​of the key you are talking about, John? Jane says Mike and Sarah. So we got this much value. So I took that one piece of data I got. Converted into a data frame It has been changed. We print it. Done. Oh my god, this is how we do it. Let's print what we get. Okay, now that's a date. What did I show the frame itself again? Another way to say data Create a variable and assign it to a Make a list and put the key inside that list. Value pairs as a dictionary When you print it, this This is how we get it. What can we create in this way? Let's create a data frame. It can be done in many ways. What can we do here? To create data frames It's okay. Fine Iniya Gain indexing and slicing are many things. We have given you all this here. We are all ready in our Nampa. The things that were said were Just try this. It's like, "Okay, Dad, this is about it." Using Pandas Ocasio in Pandas There are many built-in functions in Pandas. It said that it was coming, and that it was info. Describe the function mentioned. Yes, there are many different types of functions. Using all this, we can Let's analyze the data so that finally the End of sales data analysis Let's do an analysis. What are the functions of time? It is very clear to us that Okay, now let's understand. Move to our next library Let's call our Math Plot Lab What is a library for? It is used for visualization. What is the Math Plot Lab used for? Let's use the library that says Okay, first of all, let's have some bread. A line chart is used for that. We previously imported Malo Lib. How to import done From Mali Import Pipeline Aloe Libile We are using the pipeline. If that's not what plotting is about PLT can be used in any of these ways. Okay, so you can give it. In Libin's case and Seaborn's case If I may say so, we have many here. Create is a type of visualizations It can be done, but every visualization Creating visualizations Why each visual in time? What is it used for? Understand clearly what That is very necessary. Okay Bread is first and foremost for us. Okay, first of all, you should know. Oh, I said X here. Create a list and say "Y" Create a list as mentioned. Done. So here is the line plot creation. One that we use to do The method is the plot. Okay, so plt dot plot. Inside the circular brackets xy Gave. X while taking Ana The values ​​on the axis will come here. The values ​​in the axis will also come here, so The show is just showing something. What do we do in a way? It's okay to print it out. This is what our line plot is. What is the next step? I exchanged values. Values. Our line when changing The plot is laid out in this way. Okay, we'll create the same way. For that particular chart that does Or whatever the plot is. I have different styles for it now. The line given here is It was a single line and Its C has changed its look. I changed the beauty and added dashed lines to it. I have given it for that. What to do, just say the plot. Function inside line style equals double If you give it a dash, it will come out as a dash. I gave it its color and line width. Line width final PLT show Ours is at the time of giving. The plot is visible. The function called plot We can use the line plot verb Create or plot a line graph Can be done for each plot or each To create visuals It's the same old bill now. We create a bar plot. If you are doing it, PLTDA Bar What can we do if we give You can create a bar. To create a plot Can you give it to me now? Attributes now line style dash We have given the dash as it is. Whatever the plot, we can do it. Can you give me any style? The styles given in this We can do the same for other plots. Okay, I'm ready to use it. I have one line inside this one. We are here now, with the points and markers. Lines have been set up. That one coordinate called One Kadu I can mark it if I want. It says marked. I call the point that one coordinate. Marked and said 2 Kapha Mark the coordinate. Mark the coordinate that says So that every time we mention I need the coordinates and the mark. It's okay to do it. The marker I have provided for that. What is zero in different forms? Let's give you markers. You can give it up to the size of a marker. I also like the edge color of the marker here. It's called Red. So We can create here in many ways. What can be done? And then I see. Above our chart, our Can you name the plot? This one is even better. Many fonts can be provided. So this is a math plot lib. Let's create using It fits. Not just one line Multiple lines can be given. And then say Let's change this labeling. Okay. X ticks and Y ticks After using the function that says It is possible that we can do it. Is. So this is how we are It's okay to use Matlot lib. Now create a bar plot. What are you doing to get it done? Actually, why a bar plot? Using bar plot Using categorical data This is to visualize it. This time, using a line chart What happened during each train ride? We want to show a trend that Line plot is mostly used What is the purpose of a bar plot? What is categorical data here? There are many types of categories in this category. What are the names of the fruits? Maybe something like that There will be categories. So I Just call it category one to three four. They have named it after saying things like that. I mentioned it on the X axis. The bar inside the OK Bar Categories were given. Values ​​Youshavali That is a value we have given. What is printed on the Y axis? All its C's have been given. Let's draw a histogram. If we say histogram, each How much is the frequency of the values? It shows that is. Histogram. So our data Gave. And PLT dot Our data inside the heist After giving it to us, we will have the same You can draw a histogram. I As mentioned, all the rest What we call CX label That one that is displayed here What is the ValueY label here? That is a given frequency. We can say that our Y-label Our graph is based on the need. Get your customized Nuk for pickup. Okay. Okay, that's the histogram now. What is a scatter plot? Relationships between variables If you want to show us, then you Can go for scatter plot okay? So here we have a scatter plot. Got it, okay, what's the scatter now? We drew the plot and then the pie. Charts Pie charts We can do this like this method Create and take, and so on. Here are the types of charts created That's what you can do. About Map Clip Gain You That one official of MapLib Go to the documentation. Just one thing, what is it? Practiced something that was checked. Let's see, okay, okay, okay. What we have to say about the next one The visualization that says our Seaborn Okay, so it's about the librarian. Seabonsi Seaborn means data visualization. Bill inside the library, Okay and Seaborn There are many data sets that have been After saying "ice tips not glue" Many data sets are available. Seaborn has a cat in it. Inbuilt data set is We use it. Let's do some visualizations. I'm going to use the Siboneyuse. We are the ones who are ready to do it. Importing SNS Download Askor The function called data set We use IS data Loading the set is done by its head. When we take the head, this one We see the results in this way. Okay, when we take the sample, Any five in that one data set Rose will be printed for us. Okay, and then here we go. How many columns are there? There are five columns. Sepal length Sepal width Petal length What is called a petal-less species? Okay, that's our last column. The column that says species I took the value constant and When we take that one In the column that says Species What are the main three values? The value is in Setosa virginica. The three values ​​that are called vesic colors are The value concept of the three values Just saying Serosa 50 Flowers are called vesic colors. 50 flowers virginica in the species mentioned 50 flowers in the species called Actually, it says "because of the weather" The flower is and these three species What is the flower that says Iris? Okay, now use this. What can we do with the bar plot? How to create a bar Creating the plot SNS bar plot on the x-axis We are on the species axis. The next column is given by Peta Length. The species was given as If we say Hue, we can say our The graph should be colorful. If so, what can we do there? I can give it to you, I can give it to you. And palette, many types of palette There is a palette here, we are Rainbow. Many people say that it was given by Simap Wedus. What kind of pallets do we need? Let's give you the pallets, then let's go here. What can you see in Setosa? The species mentioned is very long in petal length. The petal length of the OC color is short. A little bigger is Virginica's. The biggest one is okay, Dad, like that. Conclusions tell us this. Suddenly from visualization You can take the created one. I have drawn Barlot here. But I have given it inside. What are some attributes? The saturation has changed here I am 0. Just give it one color. A color-related Attribute is okay and then we Just like created in Malo Lab Here too we have a scatter plot. It is possible to create That's what we use here. What is a scatter plot of a function? Okay, then count the plot. Histogram hest plot so We have many different types of plots. What you can create here Okay, so let's create some visuals. It can be done, it is possible, but each Visuals also understood why Okay, the point is to plot. So, in addition to this, we can also consider outliers. What can be used to find out? You can use a scatter plot. There's a swarm plot for that. There are many types of strip plots. Plots are available okay and Go to Seaborn's documentation. Okay, go to its website. There are many methods available in it. It will be nice to see all that. Try creating some visuals. Okay, Soya, that's about Seaborn. What to say Okay, next time. What is Exploratory Data Analysis? We just said that. Okay, I was gone. Exploratory Data Analysis Ackley it for you while doing it. If you want, it could be a project. You can upload it to your Gihub. What is in hand is student performance. I have some related data. Okay, that one is available in my hand. What is Data going to do now? We are going to use a free one. We are a little bit behind the data. Okay, going to perform the analysis. So we have given the introduction. Even when we do this project, we It was documented a little. What should be included in the first introduction? Our data set says: This is how many columns it has. Which columns are in it? What are the types of values? I mentioned that. Load the required libraries. Load our data set and Just print it out, okay? Take its head. What is Info? About our data set What is basic information? Basic information number off Rose What does the number of columns say? Missing values ​​so each value We can find it here. That's the info, now the next step is to describe. When you say describe, a little more. You will get information that is accurate. We are descriptive. Didn't the statistics say that? In descriptive statistics Come on, we'll get some fish. Minimum to get standard division Value Maximum Value Median Same 25% And 75% of these values We are going to calculate. Using describe is a A function called describe After use, our data Basic information about the set Here is some overall information for us. What you get is what you describe. The function that says OK is missing. We check if there are values. Doing Next is Important There are no part missing values. We see there that our data We just use a visual Drawing a pair plot. Variables using pair plot How much is the relationship between Let's see if The pair plot is used in the same way. The count plot has been drawn. So many different types of visuals We use OK Race Or. The column that says ethericity We are taking value counts and The fish we printed it on is Visually, we draw, okay, so... We are many types of visuals. Doing Okay, then I drew a box plot. Okay, so how can we do that? You can do whatever you want. It is possible to perform analysis Okay, what is our pass rate? Okay, let's get out of that one table. Let's calculate. It is possible that, okay, so this is one. If I need the code, we have one. You can share it in the description. Just take a look, it's very Simple, okay, everything. Descriptions have been given, Sayun. Just Go Okay, so we saw Nampai. I saw what Seaborn was and I saw Mathlod. I saw the pass and here are some things. How to do each one We are a small portion of ourselves. Okay, now let's discuss. We are coming to the final party, career. How to roadmap and portfolio Let's build a career together. Data Analyst Our Portfolio How to build and take it What we are going to look at is Sasho Career Pass. What is data analytics? When you start, you Data Analyst Gets You Started Let's do it. Junior Data Analyst Ackley Ath A data analyst after all Let's go to the position, then a senior data. You can go and become an analyst. Maybe I'll become a data scientist. A senior who can work. Data Scientist And maybe an AI research engineer. All the best to you in the future. Let's go, there's one thing you have to do. That means Continuous Learning. Keep doing it, okay? Updated, that's what you need to do. The next thing is specialization. When we say specialization What is the need for specialization? Marketing Analysis Financial Analyst Healthcare Analyst Appa Which domain do you want to go to? Knowledge in a domain of interest There must be a lot more, okay? Transition to Data Scientist Business Intelligence development is a bit slow. As I said, you can go to this one role. Where can you go in the future? It's time to go, next time. When making the case for the portfolio To Build a Strong Portfolio When you say portfolio What is meant there? Your Gihab profile is very That's important, LinkedIn. I need a profile and your resume. All three are good and we are in a good way. Must be maintained up to date. It should be put in a showcase. To showcase your project You can use GitHub's help. If you can't use it, your If you have a personal website, you can Uses that also include various Project various types of data sets Take it, take many domains and you're done. Look, that's what we divers are here for. By projects that have been It means many analytical We can do it using techniques. Already in Inferential Statistics Many tests in hypothesis testing That's all you have to say. Can be used for analysis You have used it in many ways. You can do it by looking at it. Next One Document Youth Process Code Insights Clear GitHub This This is when uploading Mention what is clear. Give an overview of the project. Give the project's objective. Everything is mentioned clearly. You should put an end to all that. Next One is very important. Participant Oh, a contribution that says "Kagal" There is a website for you, beginner. On a website called Kaggle Go ahead and download the data set. You can do it there and then. And also called Kagal You can use Python right on the platform. Jupiter can also be used for coding. A similar one The environment is available, so this is in it. Let's try doing the coding you mentioned. Participate in upcoming competitions Let's win, let's win, okay, dad, and so on. There are options, you can try them all. Do these things okay next one Network with other professionals. We need to manage our LinkedIn profile. We have already said that. So other professionals on LinkedIn What to do with all this connections? Establish. For everyone Similar to our position Or what we want What about the people in the position? Bring it, bring the connection. Try to connect with them all. Okay and then you do. Upload all projects to GitHub. Do and Gihab's link is ours. Add to LinkedIn profile Okay, what projects are you doing? Publish your LinkedIn Who will see the connections you have made? Okay, I'll see the projects in full. What is mandatory to do this? Okay, now manage your portfolio. What are the tips to do? How is GitHub repositories? To-do list: Be well organized and clear. The readme file should be added. If there are visuals, that's also an add. Must have Jupyter Notebooks What does Jupiter Notebooks do? There should be visuals in it at the time. Insights are a must for NEET There must be an explanation. Kaggle Profile Kaggle Profile How to Manage in competitions Participate a little while ago As mentioned, notebooks are similar in Kaggle. We can create. You can manage that well too. Linkedin post okay you Things learned or Your success stories, etc. You can publish on LinkedIn. What are Weekly Learnings? You can find many types of posts through Please provide a resume to inform me. Project That Well Explained Projects Well Expanded To n projects your I'll add it to my resume, okay? We are the bread of data analytics. A tutorial is available here. I've done this a lot more. We can say it in broad strokes. When you say a tutorial We include many things. Done but still more Very, very, very broad. Okay, we can do this. You may find this related. If you have any doubts Just post one in the comments. Still detailed Tutorials anything If you want, you can comment that. Aswell, let's get some big ones. A project included Maybe you can do a long tutorial. A series like this or something like that. As a tutorial, we Okay, let's do this, everyone. Go through the practical sessions. Focus on just theory. If you study, nothing will happen. Try it completely practically. One of the websites I mentioned Visit its practicals. Let's try it, okay, and also. Any help from us? If you want, you can comment. To help Yasada Thank you for your analytical work.