Tutorial 5- Pandas, Data Frame and Data Series Part-1

Рет қаралды 217,216

4 жыл бұрын

Hello All,
Welcome to the Python Crash Course. In this video we will understand about Pandas library, Dataframes and Data Series
github url : github.com/krishnaik06/Machin...
Support me in Patreon: / 2340909
Connect with me here:
Twitter: / krishnaik06
Facebook: / krishnaik06
instagram: / krishnaik06
If you like music support my brother's channel
/ @ultralifeproject
Buy the Best book of Machine Learning, Deep Learning with python sklearn and tensorflow from below
amazon url:
www.amazon.in/Hands-Machine-L...
You can buy my book on Finance with Machine Learning and Deep Learning from the below url
amazon url: www.amazon.in/Hands-Python-Fi...
Subscribe my unboxing Channel
/ @krishnaikhindi
Below are the various playlist created on ML,Data Science and Deep Learning. Please subscribe and support the channel. Happy Learning!
Deep Learning Playlist: • Tutorial 1- Introducti...
Data Science Projects playlist: • Generative Adversarial...
NLP playlist: • Natural Language Proce...
Statistics Playlist: • Population vs Sample i...
Feature Engineering playlist: • Feature Engineering in...
Computer Vision playlist: • OpenCV Installation | ...
Data Science Interview Question playlist: • Complete Life Cycle of...
You can buy my book on Finance with Machine Learning and Deep Learning from the below url
amazon url: www.amazon.in/Hands-Python-Fi...
🙏🙏🙏🙏🙏🙏🙏🙏
YOU JUST NEED TO DO
3 THINGS to support my channel
LIKE
SHARE
&
SUBSCRIBE
TO MY KZfaq CHANNEL

Пікірлер: 132

@bhaveshsalvi4437 4 жыл бұрын

You were not right at (6:40) loc and iloc difference . For ones who want to know - loc is label-based, which means that we have to specify the name of the rows and columns that we need to filter out On the other hand, iloc is integer index-based. So here, we have to specify rows and columns by their integer index. Hope this clears out. Happy learning

@nishant9847 2 жыл бұрын

yeah u are right

@Raaajzzz Жыл бұрын

Thankyou for bringing this brother

@harshpal3795 7 күн бұрын

Yeah brother ! I appreciate

@manjushabhoyar5742 4 жыл бұрын

When I was about to give up on data science, just then came across ur channel.. And I must say, you really explain concepts in the easiest way possible. Kudos! 😀

@uncommon_common_man 4 жыл бұрын

@mudhitkumar 4 жыл бұрын

I agree with you!

@sonalirevalkar1037 4 жыл бұрын

Same here

@harinandankumar5332 3 жыл бұрын

R u working as a data scientist role currently?

@deepakkeshari7655 2 жыл бұрын

What's your position now??...

@sarveswarasastrysuri7284 4 жыл бұрын

Thank you so much Krish for the daily online classes. We are watching your videos daily and learning the new course. I appreciate all your hard work in doing so. You're presenting it really good. Keep doing the good work. Many thanks!

@estherjohn3191 2 жыл бұрын

I love your lectures so much💯 Thank you for these lectures, Mr. Nail. I am so much grateful

@lateefamidu3749 3 жыл бұрын

Thanks for this great tutorial Krish. It is SUPER-AMAZING!!!

@sumijasukumaran1394 3 жыл бұрын

Hi Brother your video was so helpful to start with python for data science.Thank you for creating videos

@SaiBaba-pu7kd 3 жыл бұрын

Thanks Krish such a useful stuff you provided for a freshers to learn Numpy .

@naveensaini9992 3 жыл бұрын

so help full for absolute beginners thanks so much sir

@Dejia_Space 4 жыл бұрын

how to enable the dropdown list for all the function in df(pandas object)? I have to type to_csv but jupyter does not give me a dropdown list as a hint.

@gulabmeetyou 4 жыл бұрын

Hi Krish, Thanks for making wonderful and useful videos. Just one thing I want to say that, your playlist is not clear, mixed with other content. When I opened Statistics playlist which mixed with EDA and other videos... Can you please make ur playlist clear. This would be more helpful. I am waiting... Thanks in advance!!!

@jn9281 Жыл бұрын

Thank u so much for all the tutorials. In case of df.to_html(),df.to_json() it works but df.to_excel() it shows error. What could be the possible reason? How can I convert it to excel format?

@QaAutomationAlchemist 4 жыл бұрын

Great and crisp tutorial....thanks

@krishnakamalgogoi9893 3 жыл бұрын

Hi Krish, I have written this code df.iloc[0:2] and I am getting both Rows and Columns although I have not specified any columns. I checked the dtype it says dataframe. Could you please explain why am I getting this. Thank you

@aslamuddinmuhammad4694 2 жыл бұрын

What do you mean by null value? Because in column 1 there's a zero value still it is showing column 1 has no null value

@anubhavkeshav5908 4 жыл бұрын

Hi Krish! When are you uploading next video in the machine learning series. Eagerly waiting for the next video. Kindly keep uploading videos daily in this playlist.

@1soundarya 3 жыл бұрын

Sir, your book on Finance with Machine Learning and Deep Learning is not available on amazon.. i am looking for that book. can you please help me!!

@hemant3007 2 жыл бұрын

really helpful for beginners:)

@mobinalhassan 4 жыл бұрын

Bhot khoob. Kya as a professional data scientist huma apna algo bnana prta han ya. Pre-build algo sa km chal jata ha?

@anshulmangal2755 4 жыл бұрын

What a teacher you are as a god for data science

@suhailnizami7760 3 жыл бұрын

why i getting error when type df.loc['Column1'] but no error in df.loc['Row1']

@rohitkamra1628 4 жыл бұрын

Thanks for amazing video. Could you please tell me which screen recorder application are u using?

@shivangiexclusive123 4 жыл бұрын

hi krish..this shift tab is not working on my jupyter.. what to do to get the tool kit

@jatinmaggu1668 4 жыл бұрын

I have just started my transition to data science as a career, following your guidelines initially. Started the python course of yours waiting for more videos. Would request you if you can share your email, have few doubts. Thanks in advance

@SaraView 4 жыл бұрын

Great video

@parvsoni719 Жыл бұрын

sir df.loc['Column1'] is not working but working for Rows

@prabuddh_mathur 3 жыл бұрын

Hey! Could you please create a video on how to use the arrow keys fast on a keyboard. I really suck in that and my coding typing speed is very slow just because of that.

@Ramesh-rp6jq 4 жыл бұрын

Hi krish Please let me know if ML course registration started

@tejaspatil189 4 жыл бұрын

Hi sir is there any Ofline Course in Pune for Data-Science

@Gaurav_Dhamija Жыл бұрын

how can i get this files which u r worked on ?

@akki6071 2 жыл бұрын

Nice I got one issue in sheet 1 I have multiple data in column one cell like (1,2,3,4) many cells I have to compare them with another column in sheet 2 but sheet 2 I have only single digit number in column cell like (1) if sheet 1 matches with sheet 2 then should replace with new values which is also present in sheet 2

@aasthadaga6706 3 жыл бұрын

I am using google colab and not getting any test.csv file.. Please help

@snehalhon 2 жыл бұрын

You are theeeee bestttt ....

@saumyagupta2606 3 жыл бұрын

Please anyone: What's the need to convert pandas dataframe to array using .values? Also are arrays and numpy arrays different , how?

@varshadityasamala302 4 жыл бұрын

What is the difference between loc and iloc .

@witty_soul 3 жыл бұрын

What I understood at 6:54 these acronyms are; .loc = locator .iloc = index locator

@kalpkinjalbhaipandya5093 2 жыл бұрын

Why df.loc['Column1'] is not working ?

@gunjan6070 2 жыл бұрын

My code is saying your numpy doesn't have any attribute arrange. :( why ?

@shalininaidu661 4 жыл бұрын

Krish, Please do videos on RNN,CNN

@shubhangisoni1732 4 жыл бұрын

Sir, Can you make videos for competitive coding?

@adsaikiranreddy7242 3 жыл бұрын

df['row1'] ---> it is showing error sir.. But why sir..

@louerleseigneur4532 3 жыл бұрын

Thanks Krish

@Kennerdoll 4 жыл бұрын

Hello... the following code is giving me KeyError: Column1 >>>>>>>>>>>> df['Column1'].value_counts() but this one is not >>>>>>>> df. loc['Row1'].value_counts()

@suvarnadeore8810 3 жыл бұрын

Thank you krish sir

@koustavpaul3525 Ай бұрын

Thank you sir

@tejaswarambhe7464 3 жыл бұрын

Me watching this playlist be like "Ye yaha gold pada hai but koi use hi nahi karna chahta" Guys there are hell lot of internship opportunities around, you will be exposed to good complex and real life data, which will help you for your Job roles later

@pavangoyal6840 4 жыл бұрын

How to join your data science course

@Palakmahalgamaiya 7 ай бұрын

anybody pls share the link of sir's jupyter notebbok

@mahendrannatarajan1422 4 жыл бұрын

Krish update video on data science mock interview

@cutyoopsmoments2800 4 жыл бұрын

Your ML video consists of how much hours of video ???

@theHindudailynews... 3 ай бұрын

thanks sir

@amarkotwal 3 жыл бұрын

sir plese tell me pandas and numpy like library in java/scala

@DeepakGupta-uv1oh 9 ай бұрын

can we write df['Row1'] ?

@lokeshvenkatesan2693 3 жыл бұрын

I don't understand about numpy.linspace in the previous video. It means some random numbers will be taken or what? @Krishnaik

@singwithAyush143 3 жыл бұрын

Linspace and arange both are used to make evenly spaced elements like: np.linspace(1,10,5) gives [1,3,5,7,9] where 5 is the no of elements .You can also use np.arange for that.

@bhartipragya3432 Жыл бұрын

sir is the direct calling of columns as done at 16:15 applicable only for columns? it isn't for rows

@Raaajzzz Жыл бұрын

Yeah i tried using rows to call for columns but it gives error

@arjyabasu1311 4 жыл бұрын

Sir, how to get value_counts of all features at once without manually typing out all the column names??

@makihungary 4 жыл бұрын

for col in df.columns: print(df[col].value_counts())

@arandomwho 2 жыл бұрын

thank you alottt

@atuldahiya9217 2 жыл бұрын

good

@ehtishamkhan541 3 жыл бұрын

How to become members ? reply please

@animeshbagchi7881 4 жыл бұрын

Can you please create a video of a Data Science Project Life Cycle? Like Data Loading, EDA, Removing not required columns, Feature Engineering and Scaling etc.

@nabiltech1366 4 жыл бұрын

Yes.I also try to watch every youtube video of ML.I try to figure out DS cycle or workflow.If u already findout,please do share to me

@parulsingh4989 Жыл бұрын

Hello sir!! You are literally teaching everything from the core and it's really helpful for me. Sir I am not getting an extended video of this class. Can anybody help me with the part of 5th class

@rajeshsrirangam339 Жыл бұрын

hai

@1988soumya 4 жыл бұрын

Hi Krish, I have been following your channels for quite bit of time and I would like to enroll in your class. The google form which you have uploaded seems broken. Could you please help me out. Thanks, Priyadarshi

@someonesomebody716 4 жыл бұрын

Will be reupload later on

@ashishsamrat4248 2 жыл бұрын

__init__() got an unexpected keyword argument 'Columns' Sir i face this error when i run this code so please help me out

@mohit9626 Жыл бұрын

bro write columns instead Columns, your c is capital

@shaikhanuman8012 4 жыл бұрын

hi brother i getting error when i am executing this line pd.DataFrame(np.arange(0,20).reshape(4,5), index=['row1', 'row2', 'row3', 'row4', 'row5'], columns=['columns1', 'columns2', 'columns3', 'columns4', 'columns5']) we insall pandas like numpy in anaconda ?

@charkaagnesh 4 жыл бұрын

In reshape (4,5) given and in index entered 5 rows...I think that soo.

@prasanna2179 3 жыл бұрын

you have given the row shape as 4 and labeling 5 rows, instead of 4. Make that little change :)

@sumitsaha3714 4 жыл бұрын

Sir how to activate intelligence in jupyter notebook like you.. please comment sir

@sravan08543 4 жыл бұрын

Shift + tab should do it

@vishalsonawane.8905 2 жыл бұрын

Done❣️

@rupendra.khangarot 2 жыл бұрын

df['Row2'].unique() is throwing error?

@mohit9626 Жыл бұрын

what error it's showing?

@prathmeshasole5465 4 жыл бұрын

Sir...we can use google colab for these...

@kapildevpandey9537 4 жыл бұрын

yes ,colab is cool

@hometvfirestick 2 жыл бұрын

thanks

@syedwaliuddinsaaquib1114 Жыл бұрын

I am not able to use pandas library on jupyter. this error pops up :AttributeError: module 'pandas' has no attribute 'Dataframe' . Does anyone has solution to this error ?

@mohammadmujeeb6592 Жыл бұрын

use DataFrame in this F needs to be capital then it will work and we already know python is a case sensitive

@123greenland 4 жыл бұрын

Hello Krishna, I saw the playlist and what is the sequential flow do I follow to learn data science from your playlist? I am a complete beginner. Please assist me

@krishnaik06 4 жыл бұрын

Yes go ahead

@123greenland 4 жыл бұрын

@@krishnaik06 no I wanted to know from which playlists do I start & followed by other playlist. Need to know the complete learning path. Please assist

@amanmansoori7609 Жыл бұрын

Hello brother

@amanmansoori7609 Жыл бұрын

Can i have some discussion with you

@farazahmed1668 4 жыл бұрын

@11:48 sound quality becomes much better.

@swatantrakumar8288 3 жыл бұрын

df=pd.DataFrame(np.arange(0,30).reshape(5,6), index=['Row1','Row2','Row3','Row4','Row5'], Columns=['C1','C2','C3','C4','C5','C6']) this is showing an error, while working on jupyter notebook

@srivastav3684 3 жыл бұрын

@Swat 'columns' is in case sensitive

@shaikhanuman8012 4 жыл бұрын

what about rows null values at time 13:50

@nikhilrana668 3 жыл бұрын

He is checking for the entire dataframe and not just for the columns.

@tejaspatil189 4 жыл бұрын

i didn't get info when i press shift tab

@nikhilrana668 3 жыл бұрын

That will give you the options in that method. Note, he is using jupyter notebook .

@sharvandas4349 4 жыл бұрын

df-DataFrame "Great Use" why i am getting error for this command- df.loc['Column1'].values and able to execute- df.loc['Row1'].values Thanks! keep going!

@hkia7893 4 жыл бұрын

I think he mentioned that loc only for rows, iloc for both

@yogoai136 4 жыл бұрын

when i try to execute the code am getting error as: AttributeError: module 'pandas' has no attribute 'Dataframe'

@makihungary 4 жыл бұрын

DataFrame has a capital letter 'f'.

@suneetham1394 4 жыл бұрын

@@makihungary i am also getting same error

@krithiqp8278 3 жыл бұрын

@@makihungary i tried with the same spelling im getting the same error

@krithiqp8278 3 жыл бұрын

did u find the solution bro

@indirajithkv7793 2 жыл бұрын

❤

@unknownguy4932 4 жыл бұрын

Hi krish. I am working on this tutorial . I am getting error df=pd.DataFrame(np.arange(0,20).reshape(5,4),index=['Row1',....,['Row5'], columns=['column1'],....,['column5])

@unknownguy4932 4 жыл бұрын

I am getting the error on the above line that , Shape of passed values is (4,5), indices (5,5)

@unknownguy4932 4 жыл бұрын

Sorry , i got the output . I had given 5 columns that's the reason I got the error

@Kennerdoll 4 жыл бұрын

df = pd.DataFrame(np.arange(0, 20).reshape(5,4), index=['Row1', 'Row2', 'Row3', 'Row4', 'Row5'], columns=[' Column1', ' Column2', ' Column3', ' Column4']

@suneetham1394 4 жыл бұрын

@@Kennerdoll thank you,i got

@killersawant 3 жыл бұрын

Ye wala lect pura bouncer gaya

@user-yz6uy8mo9y Жыл бұрын

Come back to 7:30.

@shahzaibali7520 2 жыл бұрын

Only arange wasted my two hours because I wrote arrange instead of arange🙂😟

@surbhiagrawal3951 2 жыл бұрын

import pandas as pd h=pd.DataFrame(data=np.linspace(6,9,20).reshape(4,5),index=[f'Row{i}' for i in range(4)],columns=[f'Column{i}' for i in range(5)]) print(h)

@surbhiagrawal3951 2 жыл бұрын

to save dataframe without headers or indexes h.to_csv('csvfile.csv',index=False,header=None)

@siddharthmishra8233 2 жыл бұрын

what is that f you have used just before row?? and secondly that's a great way to write rows and columns.

@JacklinSibiyal 5 ай бұрын

Day 2 - 17/02/2024

@rehithkrishna543 4 жыл бұрын

Left corner....singam song 🔥😂

@manojsonawane3545 Жыл бұрын

Aap confuse ho toh students bhi confuse hoonge

@AkhilsaiNo1 3 жыл бұрын

Hit like if u have typed *np.arrange* instead of *np.arange* 😅

@ajaxaj8470 3 жыл бұрын

Watch this playlist for greater clarity on Pandas guys kzfaq.info/get/bejne/fJyboKyhvL2plIk.html

@vineetkrpandey7641 3 ай бұрын

video5//done 12/04/2024

@shekarpg5774 3 жыл бұрын

13.33 to check null condition if null exits or not df.isnull() output: Column1 Column2 Column3 Row1 False False False False Row2 False False False False Row3 False False False False Row4 False False False False Row5 False False False False