No video

21 more pandas tricks

  Рет қаралды 47,659

Data School

Data School

Күн бұрын

Пікірлер: 72
@dataschool
@dataschool 2 жыл бұрын
THANKS for watching! 🙌 Which trick are you most excited to start using? CLICK REPLY and let me know!
@TimePasser
@TimePasser 2 жыл бұрын
No. 7 and no 15
@rezaghari828
@rezaghari828 2 жыл бұрын
That was really Helpful, man! Glad that I saw your tweet in my timeline!
@dataschool
@dataschool 2 жыл бұрын
That’s great to hear, thanks Reza! 🙌
@pivotai525
@pivotai525 2 жыл бұрын
I was becoming sad that you were no longer making pandas videos. What a come back like that of Real Madrid :)). Thanks Kevin!!
@dataschool
@dataschool 2 жыл бұрын
You are very welcome!
@Kristina_Tsoy
@Kristina_Tsoy 2 жыл бұрын
Thank you so much! Your tutorials are the best
@dataschool
@dataschool 2 жыл бұрын
Thank you, Kris! 🙏
@fj0n452
@fj0n452 2 жыл бұрын
What a great video! Thanks!
@dataschool
@dataschool 2 жыл бұрын
You’re very welcome!
@frankgiardina205
@frankgiardina205 2 жыл бұрын
Lots of time savers here thanks well done
@dataschool
@dataschool 2 жыл бұрын
You're very welcome, Frank!
@horoshuhin
@horoshuhin 2 жыл бұрын
love it. I really enjoyed this video. thanks for the quality content
@dataschool
@dataschool 2 жыл бұрын
That’s awesome to hear, thank you! 🙏
@immanuelsuleiman7550
@immanuelsuleiman7550 2 жыл бұрын
excellent as always
@dataschool
@dataschool 2 жыл бұрын
Thank you!
@carloseduardocorreacoimbra4040
@carloseduardocorreacoimbra4040 2 жыл бұрын
Thanks a lot for the excellent tricks (25 + 21) ! Really amazing and useful.
@dataschool
@dataschool Жыл бұрын
You're very welcome! 🙌
@pabloxD75
@pabloxD75 2 жыл бұрын
Great tips, holy! there is always something new to learn.
@dataschool
@dataschool 2 жыл бұрын
Agreed!
@gabrielreilly7010
@gabrielreilly7010 2 жыл бұрын
I love these videos. I always learn so much.
@dataschool
@dataschool 2 жыл бұрын
What a nice thing to say, thank you so much! 🙏
@kissnicky7001
@kissnicky7001 2 жыл бұрын
Thanks so much,really helpful
@dataschool
@dataschool 2 жыл бұрын
Glad it was helpful to you! 🙌
@hyakushiki23
@hyakushiki23 8 ай бұрын
Even after re-watching them, your videos are outstanding.
@dataschool
@dataschool 8 ай бұрын
Thank you so much! 🙏
@nothingDone-ei2fj
@nothingDone-ei2fj 10 ай бұрын
I completed 36 videos in this series. Thanks a lot Kevin for such amazing tutorial.
@dataschool
@dataschool 8 ай бұрын
That is awesome to hear! Congratulations!
@sheikirfan2652
@sheikirfan2652 6 ай бұрын
Great tutorial ❤
@dataschool
@dataschool 5 ай бұрын
Thank you!
@Yuri-to8uj
@Yuri-to8uj 2 жыл бұрын
amazing content!!
@dataschool
@dataschool 2 жыл бұрын
Thank you!
@yd_
@yd_ 2 жыл бұрын
Cool. pandas and numpy seem to have a ton of functions and it’s hard to remember them all. Would appreciate a video focused on multilevel data frames, as I always forget how to index, etc those.
@dataschool
@dataschool 2 жыл бұрын
I actually have a video about the MultiIndex! Here it is: kzfaq.info/get/bejne/qsmCesRj2NXHXZc.html
@amitnikhate630
@amitnikhate630 2 жыл бұрын
Hi Kevin, Thank you for creating such amazing contents. These videos are really helpful for doing real time projects. I wanted to request you to make video on particular topic. if you can make video on how to use pandas to write, read and edit google sheets, that would be very helpful. It can include putting values in range of cells as well as one cell in google sheet, reading data, etc. If there is already any video you have made on this topic, let me know.
@dataschool
@dataschool Жыл бұрын
Thanks for your suggestion!
@TimePasser
@TimePasser 2 жыл бұрын
I miss your videos , man. Best like to best tutor. 👌
@dataschool
@dataschool 2 жыл бұрын
Thank you!
@shubhi2194
@shubhi2194 2 жыл бұрын
Thank you for you amazing videos! Super informative and helpful, as always.
@dataschool
@dataschool 2 жыл бұрын
That's so nice of you to say! You're very welcome! 🙌
@dariuszspiewak5624
@dariuszspiewak5624 2 жыл бұрын
Hi Kevin. The most important question of all: How to remember all of those things? Do you have any means? Any way that lets you retain the tricks/knowledge in your mind for longer? Would you please share any thoughts on that? Thanks.
@dataschool
@dataschool Жыл бұрын
Great question! I don't have a system for memorization, rather it just comes naturally the more I use something. However, I also don't worry about forgetting, because I usually remember where to look in order to refresh my memory. Thus, my advice is (1) practice, and (2) keep track of good resources so that you can look up things easily whenever you forget. Hope that helps!
@souraneelmandal7912
@souraneelmandal7912 2 жыл бұрын
How to use text classification approach where target column is bigram word...? Can you please show us ..?
@DartEremite
@DartEremite 2 жыл бұрын
Thank you 😊😊
@dataschool
@dataschool 2 жыл бұрын
You’re welcome!
@pietraderdetective8953
@pietraderdetective8953 2 жыл бұрын
Great tips and tricks as always! do you have a tutorial video about writing efficient pandas code? for example implementing vectorization? I've watched plenty of your videos but I think I haven't seen one about the topic
@dataschool
@dataschool 2 жыл бұрын
Thanks very much! I think this video might be of interest to you: kzfaq.info/get/bejne/mranf8970LmsfKM.html
@pietraderdetective8953
@pietraderdetective8953 2 жыл бұрын
Awesome, will check that out!
@yerriswamym323
@yerriswamym323 Жыл бұрын
Hi Kevin, Thanks for the insightful video. I love your videos and courses they are so subtle and impactful. Would it be possible for you to make a video on Python Class/objects? Its a daunting concept for someone like me (not from coding background) who has limited understanding of OOPs. Additionally I have observed that many coders use python classes for ML scripts/pipeline, scripting files on Github. So it would be helpful if you could make an video on the same. Thanks in advance !!
@dataschool
@dataschool Жыл бұрын
Thanks for your suggestion! I'll consider it for the future. For now, maybe start here: kzfaq.info/sun/PL-osiE80TeTsqhIuOqKhwlXsIBIdSeYtc Hope that helps!
@faizanwar_
@faizanwar_ 2 жыл бұрын
Sir , please make a video on user defined functions in pandas dataframe
@petroliumengineer
@petroliumengineer 2 жыл бұрын
This resample methood is incredibly useful Thanks a ton
@dataschool
@dataschool 2 жыл бұрын
I agree! It really helped me once I started thinking of resample as a groupby for datetime data.
@bobiq
@bobiq Жыл бұрын
Just doing your datacamp RI Police course. It's a really well laid out course and I think you're adorable. :-)
@dataschool
@dataschool Жыл бұрын
Thank you!
@hyakushiki23
@hyakushiki23 2 жыл бұрын
Hi Kevin, I hear a lot about API's. Maybe one day you can demo how to create a basic custom API.
@dataschool
@dataschool 2 жыл бұрын
Thanks for your suggestion!
@dvinkster
@dvinkster 2 жыл бұрын
Thanks for the tips. Q: How crosstab provided the results compared to pivot where no target value 'Survived' is provided Unable to view the Notebook from link provided. Please re upload
@dataschool
@dataschool 2 жыл бұрын
Great question! With the pivot table, I just selected a column with no missing values (Survived in this case) and counted them. With crosstab, it automatically does a count, so you don't need to select a specific column. Regarding the notebook, you can view it here: github.com/justmarkham/pandas-videos/blob/master/21_more_pandas_tricks.ipynb Hope that helps!
@georgiyveter6391
@georgiyveter6391 Жыл бұрын
Hi, for example I have a table, which I've got by left outer join: person - vehicle dad - car dad - motorcycle dad - bicycle mom - car mom - bicycle son - None/NA/NaN/NaT How to group by person and count with condition (car and motorcycle)? When I use for example: df = df.groupby(['person'])['vehicle'].apply(lambda x: x[x == 'car'].count()) But I can't use a list in condition lambda x: x[x in ['car']], pandas says: ValueError: The truth value of a Series is ambiguous. Use a.empty, a.bool(), a.item(), a.any() or a.all()
@sachinrathi4197
@sachinrathi4197 2 жыл бұрын
why below code is not giving any output pd.testing.assert_series_equal(df.c, df.d, check_names=False, check_dtype=False)
@dataschool
@dataschool 2 жыл бұрын
Great question! The assertion passed, thus no error was raised, thus no output was generated. If you're new to assertions, just try running assert(1==1) and assert(1==2) in Python, and you'll see that when an assertion passes, there is no output. Hope that helps!
@tramphone6414
@tramphone6414 Жыл бұрын
good
@dataschool
@dataschool Жыл бұрын
Thanks!
@nguyenhuuuc2311
@nguyenhuuuc2311 2 жыл бұрын
The meaning of 🐼 is 46!
@dataschool
@dataschool 2 жыл бұрын
😂
@Mortz76
@Mortz76 2 жыл бұрын
jupyter notebook link broken
@dataschool
@dataschool 2 жыл бұрын
You can use this link instead: github.com/justmarkham/pandas-videos/blob/master/21_more_pandas_tricks.ipynb
@firefouuu
@firefouuu 2 жыл бұрын
On tips 14, I think a better solution is to use df.style to display all columns and rows of your DataFrame. If you have a lot of rows and are only interested in the columns just use df.head().style
@dataschool
@dataschool 2 жыл бұрын
Love it! Thank you for sharing! 🙌
@user-vd2ui5uk2s
@user-vd2ui5uk2s Жыл бұрын
Hi Kevin, a question question, why the code (titanix.SibSp > 0).astype(' int ') can set different integers into 0 and 1?
@dataschool
@dataschool Жыл бұрын
Great question! The boolean value True gets converted to 1, and False gets converted to 0. Hope that helps!
My top 25 pandas tricks
27:38
Data School
Рет қаралды 267 М.
Internet is going wild over this problem
9:12
MindYourDecisions
Рет қаралды 130 М.
Little brothers couldn't stay calm when they noticed a bin lorry #shorts
00:32
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН
wow so cute 🥰
00:20
dednahype
Рет қаралды 24 МЛН
КТО ЛЮБИТ ГРИБЫ?? #shorts
00:24
Паша Осадчий
Рет қаралды 1,4 МЛН
How do I select multiple rows and columns from a pandas DataFrame?
21:47
Adapt this pattern to solve many Machine Learning problems
7:49
Data School
Рет қаралды 12 М.
25 Nooby Pandas Coding Mistakes You Should NEVER make.
11:30
Rob Mulla
Рет қаралды 267 М.
How do I merge DataFrames in pandas?
21:49
Data School
Рет қаралды 158 М.
How do I use the MultiIndex in pandas?
25:01
Data School
Рет қаралды 173 М.
Data Science Best Practices with pandas (PyCon 2019)
1:44:17
Data School
Рет қаралды 169 М.
This Is Why Python Data Classes Are Awesome
22:19
ArjanCodes
Рет қаралды 801 М.
Little brothers couldn't stay calm when they noticed a bin lorry #shorts
00:32
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН