I have always struggled with filtering in pandas because the way it works is so different from that in other languages which I am familiar with. Thank you for making this video which is an excellent summary of the possibilities that I can refer to when I need to filter my data.
Just as a quick tip: to see the drop down options inside the parenthesis you have to use: "Shift" +"Tab" and slightly place the cursor in the bottob half of the parenthesis.
df.xs('Australia', level='Country') met cross section kan je op land zoeken zonder continent te specifieren, geweldige serie, alles gevolgd tot nu toe. Je tempo is top, niet te snel niet te langszaam
Another great video! I'm SO EXCITED that I've made it this far through your bootcamp series. Also, super happy that I finally get to learn about Pandas! I can't wait to finish this series and start on your Analyst Builder courses! :) As always, THANK YOU ALEX!!
10:35 Actually sort_index() also has an 'inplace' parameter (similar to set_index()). You have to set inplace=True for the underlying integer index to change to the new order. Executing df.iloc[1] after setting inplace=True for sort_index() will give Angola as the output.
Hi Alex - it would be amazing if you did a deep dive on the new Seaborn Objects API. I personally tried it and think it is the future of Python visualization. Amazing video as always!
Hi Alex, I just came across your channel. Amazing. I just started doing RUclips myself in the last year or so. Was wondering if you have some tips on how you were able to build such a massive channel in just a few short years?
Hi Alex, you mentioned that iloc didn't work in multi-index but as I practice it was not working since we didn't save the changes after sorting multi-indexes.
We have to do df.sort_index(inplace = True) to sort our existing dataframe. Without the inplace=True it creates a new sorted dataframe that would need to be assigned to a new variable
Its all about the order of setting the index...Oga Alex didn't show us that he'd switched the indexes from df.set_index(["Country","Continent"]) to df.set_index(["Continent","Country"])
Watching your all videos are finished sir then I download certificate In that my certification why r u not signing sir that is valid certificate for me pls reply
Your SQL tutorial project helped me in getting my first job! I have no words to thank you, I was struggling financially. Keep up the great work!!!
you only learn sql
Can you elaborate on what else you did?
are you serious ? like how on earth could a SQL knowledge no matter how advanced land you a job ??????
In countries like US, UK u can get it. In India it's not possible @@smktube5205
I have always struggled with filtering in pandas because the way it works is so different from that in other languages which I am familiar with. Thank you for making this video which is an excellent summary of the possibilities that I can refer to when I need to filter my data.
Just as a quick tip:
to see the drop down options inside the parenthesis you have to use: "Shift" +"Tab" and slightly place the cursor in the bottob half of the parenthesis.
thanks, it is helpful
that helps alot
thankss
df.xs('Australia', level='Country') met cross section kan je op land zoeken zonder continent te specifieren, geweldige serie, alles gevolgd tot nu toe. Je tempo is top, niet te snel niet te langszaam
I just told my entire family that i learned how to do power bi because of you! Told them also to subscribe!!
Another great video! I'm SO EXCITED that I've made it this far through your bootcamp series. Also, super happy that I finally get to learn about Pandas! I can't wait to finish this series and start on your Analyst Builder courses! :) As always, THANK YOU ALEX!!
how did you find the analyst builder course? is it similar to this one or does it provide alot of new material?
8:18 Do notice that Alex changes it quickly to ROWS and not COLUMNS, he shows the max rows of the table.
10:35 Actually sort_index() also has an 'inplace' parameter (similar to set_index()). You have to set inplace=True for the underlying integer index to change to the new order. Executing df.iloc[1] after setting inplace=True for sort_index() will give Angola as the output.
true
Please, teach us how to clean data with pandas Great channel!!🤓
Thank you for helping me understand iloc!
Hi Alex - it would be amazing if you did a deep dive on the new Seaborn Objects API. I personally tried it and think it is the future of Python visualization. Amazing video as always!
Thank you Alex...!
very useful thank you
Thank you!
Hi Alex, I just came across your channel. Amazing. I just started doing RUclips myself in the last year or so. Was wondering if you have some tips on how you were able to build such a massive channel in just a few short years?
Hi Alex, you mentioned that iloc didn't work in multi-index but as I practice it was not working since we didn't save the changes after sorting multi-indexes.
Pretty cool.
sir, the way you highlight your 'OOPs'. 😂
Hi, Alex!
How do you open that info panel on 7:17?
Press Shift+Tab after the opening bracket
Hi Alex! what do you think about pandas 2.0?
Hi Alex, can you make a video about Alteryx? I heard that they can do analytics automated
Please make a video on Microsoft copilot(AI powered)
It will replace data analysts?
Can anyone help? Why after i sort_index, the dataframe wasn't group by Continent?
same problem did you find solution
We have to do df.sort_index(inplace = True) to sort our existing dataframe. Without the inplace=True it creates a new sorted dataframe that would need to be assigned to a new variable
Its all about the order of setting the index...Oga Alex didn't show us that he'd switched the indexes from df.set_index(["Country","Continent"]) to df.set_index(["Continent","Country"])
df = df.set_index(['Continent','Country'])
df = df.sort_index(ascending=[False, True])
print(df)
i hope that can help u
why you used '#' with pd.set_option? isn't hashtag for comments?
anyone else keep getting errors with inplace = True?
Hi Alex, at 8:14 am getting this error AttributeError: module 'pandas' has no attribute 'set_options', what do i do?
It's option not option"s"
Try this:
pd.set_option('display.max_rows', None)
Watching your all videos are finished sir then I download certificate
In that my certification why r u not signing sir that is valid certificate for me pls reply