Indexes in Pandas | Python Pandas Tutorials

[@henriqueleijoto3100]

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!!!

[@Aistory156]

you only learn sql

[@chanell3166]

Can you elaborate on what else you did?

[@smktube5205]

are you serious ? like how on earth could a SQL knowledge no matter how advanced land you a job ??????

[@tigerch333]

In countries like US, UK u can get it. In India it's not possible ​@@smktube5205

[@leucam375]

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.

[@kevindeschepper8140]

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

[@MrMikeymontemayor]

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.

[@dhirajkafle47]

thanks, it is helpful

[@vyvern1615]

that helps alot

[@aayushisharma6582]

thankss

[@sj1795]

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!!

[@saladdinsaadeh4870]

how did you find the analyst builder course? is it similar to this one or does it provide alot of new material?

[@tedanthonytarona8355]

I just told my entire family that i learned how to do power bi because of you! Told them also to subscribe!!

[@gphanisrinivasful]

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.

[@onosemuodeikuesiri7620]

true

[@nimrod4463]

8:18 Do notice that Alex changes it quickly to ROWS and not COLUMNS, he shows the max rows of the table.

[@DreaSimply21]

Thank you for helping me understand iloc!

[@jellymaneducation6168]

Hi Alex, I just came across your channel. Amazing. I just started doing KZbin 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?

[@carolwrezende]

Please, teach us how to clean data with pandas Great channel!!🤓

[@muhammadsaadmalik9059]

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.

[@simhz2221]

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!

[@adwaamohamed2674]

very useful thank you

[@ivanko-nebo]

Hi, Alex! How do you open that info panel on 7:17?

[@moxie1189]

Press Shift+Tab after the opening bracket

[@Niranga.555]

Thank you Alex...!

[@NorovsambuuPurevsuren]

Hi Alex! what do you think about pandas 2.0?

[@watergate-Shorts]

why you used '#' with pd.set_option? isn't hashtag for comments?

[@LBR0808]

Hi Alex, can you make a video about Alteryx? I heard that they can do analytics automated

[@theravikk1755]

Please make a video on Microsoft copilot(AI powered) It will replace data analysts?

[@fabscocoa3452]

Thank you!

[@naagarhive6581]

sir, the way you highlight your 'OOPs'. 😂

[@chefernandez563]

anyone else keep getting errors with inplace = True?

[@chenliu4506]

Can anyone help? Why after i sort_index, the dataframe wasn't group by Continent?

[@rajatsrivastava2792]

same problem did you find solution

[@MyAwfulUsername]

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

[@ridwanadeoye8400]

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"])

[@adjieaja23]

df = df.set_index(['Continent','Country']) df = df.sort_index(ascending=[False, True]) print(df) i hope that can help u

[@yurobert3007]

Pretty cool.

[@sarahwacha8894]

Hi Alex, at 8:14 am getting this error AttributeError: module 'pandas' has no attribute 'set_options', what do i do?

[@zainabshaikh9139]

It's option not option"s" Try this: pd.set_option('display.max_rows', None)

[@AashishKidsChannel]

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