Tutorial 5- Pandas, Data Frame and Data Series Part-1
ฝัง
- เผยแพร่เมื่อ 2 ต.ค. 2024
- 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/kri...
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/...
You can buy my book on Finance with Machine Learning and Deep Learning from the below url
amazon url: www.amazon.in/...
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/...
🙏🙏🙏🙏🙏🙏🙏🙏
YOU JUST NEED TO DO
3 THINGS to support my channel
LIKE
SHARE
&
SUBSCRIBE
TO MY TH-cam CHANNEL
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
yeah u are right
Thankyou for bringing this brother
Yeah brother ! I appreciate
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! 😀
hi
I agree with you!
Same here
R u working as a data scientist role currently?
What's your position now??...
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!
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!!!
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
Thanks for this great tutorial Krish. It is SUPER-AMAZING!!!
What I understood at 6:54 these acronyms are;
.loc = locator
.iloc = index locator
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
hai
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
Hi krish
Please let me know if ML course registration started
Bhot khoob.
Kya as a professional data scientist huma apna algo bnana prta han ya. Pre-build algo sa km chal jata ha?
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.
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
What is the difference between loc and iloc .
Your ML video consists of how much hours of video ???
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
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.
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.
Hi Brother your video was so helpful to start with python for data science.Thank you for creating videos
done!
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!
I think he mentioned that loc only for rows, iloc for both
Sir, Can you make videos for competitive coding?
@11:48 sound quality becomes much better.
I love your lectures so much💯 Thank you for these lectures, Mr. Nail. I am so much grateful
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
Will be reupload later on
How to join your data science course
df['row1'] ---> it is showing error sir..
But why sir..
Krish,
Please do videos on RNN,CNN
sir is the direct calling of columns as done at 16:15 applicable only for columns? it isn't for rows
Yeah i tried using rows to call for columns but it gives error
Sir...we can use google colab for these...
yes ,colab is cool
Krish update video on data science mock interview
Great video
Hit like if u have typed *np.arrange* instead of *np.arange* 😅
I don't understand about numpy.linspace in the previous video. It means some random numbers will be taken or what? @Krishnaik
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.
Do i have to create an excel sheet manually for it do 3:59
Hello...
the following code is giving me KeyError: Column1 >>>>>>>>>>>> df['Column1'].value_counts()
but this one is not >>>>>>>> df. loc['Row1'].value_counts()
anybody pls share the link of sir's jupyter notebbok
Only arange wasted my two hours because I wrote arrange instead of arange🙂😟
how can i get this files which u r worked on ?
Sir how to activate intelligence in jupyter notebook like you.. please comment sir
Shift + tab should do it
why i getting error when type df.loc['Column1'] but no error in df.loc['Row1']
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!!
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?
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
Aap confuse ho toh students bhi confuse hoonge
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
hi krish..this shift tab is not working on my jupyter.. what to do to get the tool kit
sir df.loc['Column1'] is not working but working for Rows
can we write df['Row1'] ?
My code is saying your numpy doesn't have any attribute arrange. :( why ?
Why df.loc['Column1'] is not working ?
I am using google colab and not getting any test.csv file.. Please help
Thank you sir
thanks sir
Day 2 - 17/02/2024
__init__() got an unexpected keyword argument 'Columns' Sir i face this error when i run this code so please help me out
bro write columns instead Columns, your c is capital
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.
Please anyone: What's the need to convert pandas dataframe to array using .values? Also are arrays and numpy arrays different , how?
Thanks for amazing video. Could you please tell me which screen recorder application are u using?
sir plese tell me pandas and numpy like library in java/scala
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
@Swat 'columns' is in case sensitive
Hi sir is there any Ofline Course in Pune for Data-Science
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)
to save dataframe without headers or indexes
h.to_csv('csvfile.csv',index=False,header=None)
what is that f you have used just before row?? and secondly that's a great way to write rows and columns.
How to become members ? reply please
Great and crisp tutorial....thanks
Thanks Krish such a useful stuff you provided for a freshers to learn Numpy .
Come back to 7:30.
so help full for absolute beginners thanks so much sir
df['Row2'].unique() is throwing error?
what error it's showing?
thank you alottt
thanks
Done❣️
You are theeeee bestttt ....
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 ?
use DataFrame in this F needs to be capital then it will work and we already know python is a case sensitive
good
Thank you krish sir
Ye wala lect pura bouncer gaya
really helpful for beginners:)
❤
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 ?
In reshape (4,5) given and in index entered 5 rows...I think that soo.
you have given the row shape as 4 and labeling 5 rows, instead of 4. Make that little change :)
when i try to execute the code am getting error as: AttributeError: module 'pandas' has no attribute 'Dataframe'
DataFrame has a capital letter 'f'.
@@makihungary i am also getting same error
@@makihungary i tried with the same spelling im getting the same error
did u find the solution bro
What a teacher you are as a god for data science
Thanks Krish
Sir, how to get value_counts of all features at once without manually typing out all the column names??
for col in df.columns:
print(df[col].value_counts())
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])
I am getting the error on the above line that ,
Shape of passed values is (4,5), indices (5,5)
Sorry , i got the output . I had given 5 columns that's the reason I got the error
df = pd.DataFrame(np.arange(0, 20).reshape(5,4), index=['Row1', 'Row2', 'Row3', 'Row4', 'Row5'], columns=[' Column1', ' Column2', ' Column3', ' Column4']
@@Kennerdoll thank you,i got
i didn't get info when i press shift tab
That will give you the options in that method. Note, he is using jupyter notebook .
what about rows null values at time 13:50
He is checking for the entire dataframe and not just for the columns.
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
Yes go ahead
@@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
Hello brother
Can i have some discussion with you
Watch this playlist for greater clarity on Pandas guys
th-cam.com/video/F6kmIpWWEdU/w-d-xo.html
Left corner....singam song 🔥😂
video5//done
12/04/2024
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