#20 Mastering Python Pandas for Data Analysis | Data Science for Beginners in Tamil

Key Takeaways

Welcome to episode 20 of this data science with machine learning course. clarification. So in the series Because you have taken commitment with me and it's okay fine. com so that we together can grow. I will definitely try because Monday to Friday teaching series data science machine learning course beginners every Saturday different Last week they wanted to come and share their story through this. So in the particularap 11 years data science Saturday 6:30 p.m. So that you will get to know but consistency. So in the particular video because quick agenda once recap concept Fore to six episodes. Python data. Sorry, Python libraries. Pandas numpy plot C1 Python data structure list sets and dictionaries different which is really dedicated I'll definitely try to interact with you talk with you so that fine in the pandas library the pandas library it's very important tool for data analysts so in particular concepts data analyst library data frame series indexing selection pas data frame of pandas library data cleaning techniques handling missing data visualization plot cot library. Data analyst. Data analyst. the right time for this. So already notebook notebook already New folder numbers. for Jupyter notebooks pandas crash course library has some set of functions already the function List sets and dictionaries function is something which will be always ending up with open and close parenthesis. And if you're calling a function, it is going to do some particular task already is useful for data analysis. Data.ts.txtic txtic. Okay. So in the particular chapter chapter one getting and knowing your data first steps [Music] just for practicing purpose. Understanding purpose so that people community can learn concept. So first step data.tsv.tx txtap CSV age sex Children smoker charges. separated. forident insurance. CSV data.tsv.txt. Okay. Maybe separated. I thinkated library installed import execute and go to the current cell. Okay. PD for classes and function models. Read Eps FWF CSV opensis because it's a function. file. Copy insurance. CSPar data.txt txt. Pass separator by default. Default separate dimensal string. Escape. Escape sequences in Python. Okay. Fine. Backlash. Okay. Fine. CSV at least insurance. PD dot read table space shift and opentrl C control V equal to double path double string separate. Okay. Read general delimited file into data frame. Okay. Insuranceator equal to double quotes. For example, function. read table by default separated CSV notebook meaningful relevant file. First step, keep relevant variable name according to the data set whatever you've imported. ID quantity. Okay. Item name ID. Okay. Okay. Order number ID [Music] particular entry particular choice description. Fresh tomato salicular choice description. Okay. particular information. For exampib, I have to pull some meaningful insights and I have to hand over to my client. Okay. Write down meaningful insights. Meaningful meaningful meaningful insights already. Order ID 1834. in the data particular business. Okay. Order details details right First, first step. So 1.1 perform initial analysis on the data. Perform initial analysis on the data. Perform in analysis once it's okay. Fine. Order detr sometimes details. Okay. shape there is two different terms. function function function always it will end with open and close parenthesis shift Enter function attribute something it will return but it doesn't end with any kind of parenthesis. Okay. return representing the dimension of dimensionality of the data frame open and close parenthesis. So, function always as I said it has to end with open and close parenthesis but in the attributes doesn't end with open parenthesis shape is an attribute open the shape how many rows and columns are there 4622 rows and five columns. Terminology alert. Terminology alert. Observation. Observation. Record. Observations. columns features or parameters because okay our client has given 4,622 observations across five parameters. Five parameters parameters. Okay. Order details. Functions open. Okay. Total sum total number of entries. True. Item choice description. item price. So this very important function chain of chain of functions or chain of commands. Chain of commands. Chain of functions but choice description. Okay. True or false? because number of entries. Okay. Full boil. Full boil. Pepper salt. Full boil. No pepper. French fries. French fries. Chicken description. So It screens usual data. Think business owner already experience. Okay. Okay. Describe tap generate descriptive statistics. Very very important function. Descriptive statistics. Minimum number maximum number one max number 1834 maximum 15antity item maybe for example let's say chicken burger maximum number of quantity of one particular for 15. Okay. [Music] descriptive statistics include those that summarize central tendency, dispersion, shape of data distribution excluding values. Okay. Include equal include is equal to all. A white list of data types to include in the result ignored for series. All columns of the input will be included in the output by default. The default argument all cues first two columns three columns The data types details dot data types. Datoice description data types library. Okay. 64 process 32. Okay. 16 maybe 32 particular data type object datab Sorry. Steps of steps data cleaning in the particular three columns. Item name, choice, description, item price. by default numbers functioname. So [Music] unique items. Okay. Totally 50 unique items. Chicken is the most ordered item. Chicken most chicken frequency 726 times in the particular item name. Chicken bowl 726 chicken. So always this has to be associated with the quantity number of frequencies in the column in the particular chicken. It's a kind of statistics complete statist report. Max means related statistical metrics. Numbers related. Object descriptive statistics in the particular item name choice description item price but order ID quantity Because unique top frequency associated with object data type and mean standard deviation minimum value 25 percentage to 50 75 max is associated with numbers. So performing initial analysis descript statistics. Okay. But still a tom So information meaningful information not just in information is already known meaningful information top five items Top 10 items least ordered it data set performing in analysis data. So in the particular teaching I would deserve a like definitely a motivation for me invest So that let them also get benefited and daily you will get the video where Monday to Friday real stories Sunday mock interview Monday to Sunday we will be completely packed the channel so be ready this is your a John let's make a simplified see you all in the next episode bye cheers Yes. [Music] [Music]