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!!
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.
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
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.
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, 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 - 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!
Great tutorial. Thank you. But I didn't understand (neither did ChatGPT) the line of code "pd.set_option('display.max.columns', 235)". If there are only 15 columns, why would I set the max to 235?
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
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?
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.
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!!
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
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
8:18 Do notice that Alex changes it quickly to ROWS and not COLUMNS, he shows the max rows of the table.
Thank you for helping me understand iloc!
Please, teach us how to clean data with pandas Great channel!!🤓
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 - 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!
sir, the way you highlight your 'OOPs'. 😂
very useful thank you
Thank you Alex...!
Great tutorial. Thank you. But I didn't understand (neither did ChatGPT) the line of code "pd.set_option('display.max.columns', 235)". If there are only 15 columns, why would I set the max to 235?
It's 'display.max.rows'. He cut the video so it didn't come out as so evident
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.
Hi, Alex!
How do you open that info panel on 7:17?
Press Shift+Tab after the opening bracket
Thank you!
Hi Alex, can you make a video about Alteryx? I heard that they can do analytics automated
Hi Alex! what do you think about pandas 2.0?
Pretty cool.
Please make a video on Microsoft copilot(AI powered)
It will replace data analysts?
why you used '#' with pd.set_option? isn't hashtag for comments?
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
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
anyone else keep getting errors with inplace = True?