How to filter a pandas DataFrame | 6 HELPFUL METHODS

Подписаться 11 тыс.

Просмотров 29 тыс.

50% 1

In this video we discuss six different methods to filter a pandas dataframe. We go over how to filter a data frame based on a single condition, multiple conditions, multiple conditions and specific columns, based on rows, and missing data.
Data can be found at github.com/fivethirtyeight/da...
Timeline
0:00 Intro
0:07 Data
1:19 Boolean mask
2:30 Multiple conditions
4:50 ~
6:45 loc
8:37 Query
10:14 Speed test
10:43 iloc
11:58 loc w/ rows
14:00 Missing data

Наука

Опубликовано:

3 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 31

@aniketmishra9265 3 года назад

Years in, I'm still learning good coding practices. Thank you. And amazing tutorial! I was looking for efficient ways to loop through a month worth of timestamps and I found you. Absolutely amazing stuff man.

@ChartExplorers 3 года назад

Thanks Aniket! That means a lot :)

@FabioRBelotto Год назад

You are a great teacher. Thanks. I will look for more content here!

@andrenevares7543 Год назад

Why youtube algoritm did not show your vídeos to me before? You have made a great job. Even if I know how it's done, your vídeos are so Nice. Congrats.

@lakewobegonesbest8725 7 месяцев назад

Great video, very helpful!

@Xavso31 Год назад

You are saving my life !

@Kristina_Tsoy Год назад

Thank you for the great tutorial!

@xaoqi1157 Год назад

really really helpful bro😉

@lukerspace 3 года назад

nice sharing much love

@vicky5548 9 месяцев назад

The code is much helpful for filtering data in pandas. Thank you very much

@gemini22581 4 месяца назад

Thank u bro..super informative

@KarlosEPM 3 года назад

Great video! Many thanks :)

@ChartExplorers 3 года назад

You're Welcome!!

@fashaikh5339 3 года назад

Thanks a lot, really the best one .

@ChartExplorers 3 года назад

Glad you liked it!

@vinaysuchedeutube Год назад

very rarely I leave comments..usually its just a like.. but this was "awesome"

@ChartExplorers Год назад

Thanks you Vinay Suchede! I'm glad you liked it.

@mosama22 5 месяцев назад

Thank you 🙂

@iswearican__ 2 года назад

ya de best, thanks!!!

@ChartExplorers 2 года назад

Thanks!

@LeonardTRUSCELLO Год назад

At 5:40, it should be | instead of & for the equivalent code PS: thanks for the videos, it is really helpful!

@StalkedHuman 2 месяца назад

I have a problem where certain columns that were too long got split into the rext row and conjured None and Nan entiies and misplaced name-stub that should be in first column but was paced in 3rd column. I want to append the stub to the column 1 name of the previous row and then remove the row with the None Nan entiies.

@ap5672 3 года назад

May I clarify 15:13: is this meant to be df6 instead of df? I don't quite understand why this worked: List rows in df (instead of df6), where the column 'Total' in df6 is not null. You are basically trying to do a lookup from df_A based on a column in df_B? In this case since df6 is a copy of df it worked. But what if these are not copies of each other. Am I getting confused over nothing?

@ChartExplorers 3 года назад

Good Catch. Yes, that should be df6 not df! Thank you.😀

@hubert155 Год назад

@FabioRBelotto Год назад

Do you have any video about merging dataframes?

@user-qg4ky1dq7n 2 года назад

Please explain how to convert from datetime to unix time

@facundolopez1792 Год назад

Thanks for the video! How can i get two criterias for the same column? Let's say social science or engineering. I want both values. Thanks.

@vishvadeepmohanpandey129 3 года назад

Why major category make equal to social science??

@odraudenoel 3 года назад

"Passing list-likes to .loc or [] with any missing labels is no longer supported..." ???

@ChartExplorers 3 года назад

Can you paste in the code that you used when you got the error. I get this error every once and a while and usually it means I'm missing a set of [ ] (depending on what you are doing you may need a double set of brackets [[ ]] ), but I would need to see the code to know for sure.