3.2. Complete Pandas Tutorial in Python | Pandas Dataframe Tutorial

[@faisalIqbal_AI]

00:02 Pandas is essential for data processing and analysis in machine learning. 01:56 Introduction to using Pandas library in Python for data manipulation 06:15 Pandas helps import unstructured data into a structured table 08:38 Loading data and displaying sample in Pandas Dataframe 13:18 Understanding diabetes labeling in the dataset 15:43 Converting a Pandas dataframe to a CSV file. 20:08 Creating and inspecting a Pandas DataFrame 22:19 Understanding Pandas Dataframe functions 26:05 Counting and grouping values based on labels 28:15 Grouping values based on mean for diabetic and non-diabetic people 32:44 Describe function for statistical measures and exploratory data analysis 34:31 Adding a column to a DataFrame with matching values 38:25 Locating specific rows and columns in a Pandas dataframe 40:36 Printing specific columns from a Pandas DataFrame 44:36 Understanding correlation in data frames 46:12 Explained creating, inspecting, manipulating, and finding correlation in Pandas DataFrame.

[@asutosh2429]

thank you very much

[@sairajat4824]

I pray to god in temples and witness him live on this KZbin channel. Thanks A lot Siddhardhan Anna. Your videos are precious treasures and i am 100% sure this channel will reach great heights

[@Siddhardhan]

that's too much praise for me 😅 thanks a lot for your positive words.

[@ganesh-ch6xf]

​@@Siddhardhanyou deserve this❤

[@psainathbangera2918]

Your Videos are Awesome and Very well Explained.. Keep up the Good Work!!!!

[@Siddhardhan]

Thanks a lot!😇

[@PreetiYadav-np5pg]

Literally, you are providing amazing content, this helps me a lot in understanding the concept easily Thank you from the bottom of my heart❤

[@Siddhardhan]

Happy to hear that!😇

[@indra3054]

how to get this botson dataset ?

[@naveenkrish4037]

In 35:52, if we enter a single element into the column, will the other 505 rows be auto-filled with NaN (Not A Number)? Or we get Error

[@arpitpathak7276]

You get error bro

[@kritikapal6167]

amazing explanation sir😇😇😇😇

[@josejavierminanoramos2185]

I am loving the series. Greetings from Spain!

[@Siddhardhan]

Thank you 😇

[@ForMyOwn_1]

brother thank you so much for your effort in supporting and sharing the concept behind the ML. If possible, I wanted to ask if you can also do a video using scikit learn library. thank you

[@Ovalwater]

it si showing that boston dataset has been removed from sklearn library so what to do?

[@bhavnadeshmukh3849]

Yes please tell me if you got....!

[@SAdithyaraj]

from sklearn.datasets import fetch_california_housing california_dataset = fetch_california_housing() Use this instead

[@VishalKumar-h5g5y]

load_boston has been removed in sklearn

[@pranshujoshi009]

yes bro i was also confused why it wasn't working

[@schrodinger4618]

@@pranshujoshi009 Alternative datasets include the California housing dataset and the Ames housing dataset. You can load the datasets as follows:: from sklearn.datasets import fetch_california_housing housing = fetch_california_housing() i am trying to this right now. and this is from the error explanation of import load_boston on google collab

[@sytam12]

That also confused me

[@sytam12]

Then I replace with housing

[@itsaayush7357]

Yes it has been removed now you can use housing dataset instead of that. When u get error then this suggestion will come.

[@abhinavkulkarni4274]

Superb 👍

[@Siddhardhan]

Thanks 🤗

[@gyanp_28]

The tutorial was very helpful .. Thank You

[@mohammedumar2306]

How to get botson dataset?

[@abdelrahmanshaheen8719]

load_boston has been deleted what shoud i do to complete the course

[@setabkhan3081]

Use the California Data Set it is a bit different but is still good

[@atulverma5011]

@@setabkhan3081what is its syntax

[@Praveenmanikanta32]

Great job brother... Thank you so much 👍👍

[@Siddhardhan]

Always welcome😇

[@VinayakAgrawal-vu1uw]

Hi @siddhardhan, thanks for the great content. I just wanted to ask that what is the right way to learn this tutorials. I mean to say that are we just suppose to watch the videos or write the codes by ourselve. Can you kindly clarify. Thanks again

[@neo5144]

thankyou bhai your videos are really usefull. Thankyou bhai.

[@Siddhardhan]

you are most welcome 😇

[@ladoogopal309]

Boston dataet is already in the pandas or we have to upload it??

[@sriyanshsharma-de5iw]

same doubt bro how to do it

[@rafiezikry1083]

Can someone give me an explanation about adding columns in the data frame, where do the price get the data? and why write target in the code?

[@HritikJain]

Same doubt

[@HritikJain]

This line of code is adding a new column called 'Price' to your DataFrame (housing_df). It's then filling this 'Price' column with the actual housing price values from your original dataset (housing.target). In essence it is adding price information to the existing data.

[@sanjhay6714]

Do you know how to import the boston dataset?

[@rafiezikry1083]

@@sanjhay6714 got it a while ago, thank you for trying to help!!

[@nurbintehamid328]

boston data set has been related. what to do?😢

[@learnwithhasmita1003]

thank you so much sir. i have one doubt, when we add column price , how it got values for price.

[@Siddhardhan]

hi! it is present in the "boston_dataset"

[@learnwithhasmita1003]

@@Siddhardhan ok sir thank you

[@bhoomiagarwal1306]

nice vedio

[@aditiapar9355]

will i be able to answer interview questions with this?

[@miranmahmud193]

Hello! How can I upload .MAT file in Pandas DataFrame?

[@snehasneha3822]

sir after coding it in here ,can i push it to github ?

[@ardon-c3i]

the best

[@jaden007]

can you do a video on tensor flow please!

[@saketml8676]

firstly sir i want to thank you sir for starting this channel i came across to this through linkdin and sir i want to ask you that i have made some projects from your videos, can i put them in my resume and sir can i upload complete code of those projects on github

[@Siddhardhan]

hi! yes, if you practiced the code by yourself and you understand it completely, then you can definitely put it in your resume. but don't put it in GitHub. if you made the code from scratch by yourself, then you can put it. And I don't expect you to give credits to me in your GitHub or anywhere else. I am happy that people are learning from my content and I don't expect anything else. thanks 😇

[@uppariamericavlogsjustforf3395]

Hi can you please make data science prediction on US Stock market on Tesla?

[@Siddhardhan]

Hi! I'll make video in this topic in 2 or 3 weeks

[@businessecommerce-fp1oi]

amazing

[@sachinvithubone4278]

How we can find in which row having null value if we have thousands of records?

[@Siddhardhan]

Kindly refer this: www.kite.com/python/answers/how-to-find-rows-with-nan-values-in-a-pandas-dataframe-in-python

[@sachinvithubone4278]

@@Siddhardhan thanks

[@__Maybe__]

USE "pandas.DataFrame.isnull()" TO FIND ROWS WITH NAN VALUES

[@dasaricharan3866]

Create a video for how to create pandas data frame by excel file

[@godisgreat3892]

thank you.

[@HariPrasad-ox5ri]

bro, so if there is a matrix of size 3 x 2 and if I do the slicing operation x[2 , : ]. I will get all the columns of the second row, right?

[@Siddhardhan]

hi! no, you will get all the columns of 3rd row as the index of third row is 2. try the following code: import numpy as np arr = np.array([[1, 2],[3, 4],[5,6]]) print(arr[2,:])

[@HariPrasad-ox5ri]

@@Siddhardhan Bro, congratulations on reaching 12k subscribers! This is just the start, you just see in the future, your YT Channel will be super famous!

[@dasaricharan3866]

How to create a pandas data frame by a excel file

[@ahmedabid6799]

thnx

[@pythonicman6074]

تستاهل الف لايك

[@anisharaj9854]

28:05

[@shwetapd]

can you please make these video in Hindi

[@mycreationmanishyadav444]

Gayi buffalo pani me

[@mycreationmanishyadav444]

Ek toh shuru se error aa rahi thi now near at 8 min it again show error of no attribute data and feature name

[@mycreationmanishyadav444]

These error was recorded by watching video again but data got mixed 😂😂

[@indra3054]

how to get this botson dataset ?

[@Siddhardhan]

it's available in Kaggle

[@godisgreat3892]

Thank you.