Learning Pandas for Data Analysis? Start Here.

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

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

50% 1

A high paced overview of many of the pandas core functionality. As one of the most popular libraries in all of programming, Pandas is an essential tool for learning data wrangling. Watch this video to get a good foundational understanding of what is possible.
Intro to Jupyter: • Jupyter Notebook Compl...
Kaggle notebook made by a viewer! www.kaggle.com/code/lizhechen...
Download the dataset here: www.kaggle.com/datasets/robik...
Timeline:
00:00 Intro
00:57 Importing Pandas
01:26 Data I/O
01:51 Reading From Files
03:03 Writing to Files
03:36 DataFrame Basics
04:57 DataFrame Summary
06:12 Subsetting Columns
07:19 Select dtypes
07:34 Select as Series vs DataFrame
07:58 .loc and .iloc
09:37 .loc Filter Expressions
10:50 .query
11:31 Summary Statistics
12:10 .agg
12:53 Sumarizing Categoricals
13:43 rank, shift, cumsum
14:44 Rolling methods
15:21 Clip
15:41 Groupby
16:44 New Columns
17:33 Sorting
18:30 Missing Data
19:33 Combining Data
19:55 concat
21:01 Merge DataFrames
21:52 Merge Suffixes
22:34 Bonus
Check out my other videos:
Data Pipelines: Polars vs PySpark vs Pandas: • The BEST library for b...
Polars for Data Science: • Polars: The Next Big P...
Speed up Pandas Dataframes: • This INCREDIBLE trick ...
Avoid These Pandas Mistakes: • 25 Nooby Pandas Coding...
Links to my stuff:
* RU-vid: youtube.com/@robmulla?sub_con...
* Discord: / discord
* Twitch: / medallionstallion_
* Twitter: / rob_mulla
* Kaggle: www.kaggle.com/robikscube

Наука

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

31 май 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

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

Want to follow along with the same dataset and python environment? Big thanks to someone who made a kaggle notebook with this entire tutorial: www.kaggle.com/code/lizhecheng/pandas-2-0-1-tutorial/notebook Just fork the notebook and explore the data with pandas!

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

This is a masterpiece Rob. A condensed pandas course. Wow. Even regular Data Scientist can refresh their mind or discover tips and tricks they are not used to use such as the query methods. And what I like the most, it all fits within 23 minutes. I would love to have such videos for some of the other commons libs.

@pranjalpandey147 8 месяцев назад

@ramboram2685 Месяц назад

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

This is truly incredible! It's the finest pandas tutorial available on the internet, offering a remarkable balance of breadth and depth.

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

Thank You so much for putting this together Rob, you make it look so easy and it's well explained and very clear. I really appreciate you for sharing this with everyone !

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

Glad it helped you!

@SmadeX2 8 месяцев назад

This is the best video on pandas I’ve seen so far (and I’ve seen dozens). Thank you so much for keeping your explanations short and up to the point!!! Gonna use the video as my top 1 reference resource when I feel stuck!

@chauhanknight07 3 месяца назад

This 20 min video is equivalent to 2hrs of other youtube videos...masterpiece

@robmulla 3 месяца назад

Thanks! Tell your friends.

@paveluhliar 27 дней назад

Thanks for this video. Packed with info, but still easy to follow, no small talk… Really appreciate your effort!

@thomaskwesimwaba9151 8 месяцев назад

Thank you for the videos Rob, your hard work is highly appreciated.

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

Thanks, Rob. That's a great summary of the features. Really useful!

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

Wonderful channel for beginner data analysts & learned a lot of concepts from you…. Great work man

@IsraRM 8 месяцев назад

Great video Rob, I would love to see you explaining Machine Learning and Deep Learning models, from theory to practice using scikit-learn, Keras or Pytorch. You really made things look easy. Can't wait to see another of your awesome videos.

@irfanshaikh262 8 месяцев назад

Thank u very much. I can now officially announce and recommend this video to my friends as one stop pandas tutorial and solution. Thanks Rob

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

This is great work!! Thank you very much for putting it out here!!

@phamtienthinh1795 3 месяца назад

It took me 2 hours and 30 minutes to revise pandas, but it's worth it

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

I can tell even before watching this video that's its great!!! You're such a great tutor.

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

This video is fantastic. informative, concise and a strong foundation for pandas. Most importantly, it is easy to understand and follow along. Thanks for the video, I'm subscribing!

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

Really appreciate the feedback. Glad you found it easy to follow. I was a little worried it might be too fast.

@mikep4981 8 месяцев назад

@@robmulla I typically take notes when watching videos like this so I am accustomed to pausing. In my opinion it's better when there isn't much filler in between so that it's easy to get to the next point or move back to where you want.

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

Thank you for this lesson and all your work. As always, I learn so much from you! Any chance you'd do a video lesson on data cleaning? 🙏

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

I've been learning Pandas for a couple of years on and off now, and have even used it a little at work, and yet there were still a few things in here I didn't know about. The rolling method in particular is a game changer, I've been manually creating functions to do that and now I can just do it in one line of code (and likely faster than my hacked together functions).

@mark-dy9zo 6 месяцев назад

Can you give an example of a rolling method application? I'm curious

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

@@mark-dy9zomoving averages

@kamranzamanni6826 8 месяцев назад

Very easy to follow along, thank you!

@whatisagoodusernamehere 8 месяцев назад

we are waiting for the next part! I personally wanna see sth on visualization!

@robmulla 8 месяцев назад

Thanks for the feedback. I’ll keep that in mind for the next video.

@okok-sc2cx 9 месяцев назад

Thank you so much ❣️ I have watched your previous pandas video, but this had everything ❤ it was awesome ❤ I understood everything except for to write csv, Thank you so much for this amazing video ❤

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

Not enough half way through and I can tell this video is gold.

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

Thanks Rob for sharing the knowledge and experience to data community 😊

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

🙌

@DavidPonzio-up8ln 2 месяца назад

Good Intro! Thanks!

@chriskeo392 6 месяцев назад

One of my favorite teachers

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

It is solid tutorial for Data Geeks. Thank you)

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

Great tip on renaming the multi index columns!!

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

Glad it was helpful!

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

Nice Video Rob. This helped me a lot :)

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

Very cool ninja panda style!!! So useful and like a real pro awesome!!!

@ruanstg 8 месяцев назад

Thanks for the great Video! How did you manipulate that folder with bunch of.csv files to put fit all together in the df? And how to deal with irregular datas in a typical case like this? Have you already done some tutorial explaining and detailing these kind of tasks?

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

Thanks for this. Straight to the point. Great! Do you think Polars is going to be especially disruptive? I’ve been using it a bit and I can’t believe how much faster it is at a lot of things. But pandas is very entrenched (and probably has slightly more friendly syntax).

@dailinchibasgoico6508 6 месяцев назад

Thanks for sharing your knowledge

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

Thanks Rob!

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

Hi. I wish I watched this before my last project. Hope you will do an advanced series.

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

Thank you Rob!!!

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

Thank you Rob 😊

@therealrucleshe7662 6 месяцев назад

this vid is a gem

@robmulla 6 месяцев назад

Thanks! Glad you liked it.

@lucasoliveirapaes 8 месяцев назад

Thanks for the content, Rob! it's really excellent! Can you do another video like this but with numpy?

@mathiaz943 8 месяцев назад

Great stuff!

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

Magic Rob! hopefully be like you one day

@Blahcub 8 месяцев назад

I'm wanting to ask a bit more of a meta question. How much time do you spend outside of work on your skills? How much passion or drive do you have and what are your routines? I work in medical ML and came across your EDA video and wanted to get a successful person's view on how to improve and grow.

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

Hi, does anybody know a website or where I can find data cleaning exercises or challenges? I want to practice cleaning different kinds of data, any suggestions will be helpful

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

Perfect!

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

Hi, i have one silly question. How do you get intellisense i.e. functions menu for each object and for each function, the whole list of available parameters. Which IDE you are using ? It really helps to focus on use case rather than mugging up the function names and their syntax.

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

Hello Rob great video! I have a question, how do you enable the description of the methods that you use. They are showing on the right when you type in the ‘dot’.

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

Thanks. With Jupyter you just do shift-tab

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

@robmulla do you know a website or where I can find data cleaning exercises or challenges? I want to practice cleaning different kinds of data, any suggestions will be helpful

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

Hey Rob! Any resouce to download and handson with parquest file

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

It was really helpful, but I think you missed a section for converting data types in dataframes, specially for date types. thank you very much for this summary.

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

Hi Rob,how to read the details of function in jupyter lab just like 2:22

@vmartme 8 месяцев назад

Thanks!

@vinsensilitonga9148 8 месяцев назад

Great lesson

@robmulla 8 месяцев назад

Glad you liked it!

@swannschilling474 Месяц назад

Awesome ❤

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

Great video as always ! Would be Nice to have the same one with polars

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

thanks for the video, one request though, can we have the same dataset so we can follow along.

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

Do you have a panda functions cheat sheet (df functions) available? Thanks. Follower 👍

@Christianboy2231 6 дней назад

Can u tell me where u execute ur code/ How do I get to the same terminal

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

Thanks bro

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

Thanks Rob 😁.

@jahunmoayedzadeh9194 6 месяцев назад

I’m sorry I know this will sound dumb to you guys but how is it listing all option after writing a part of if. Like read_ ( then a whole bunch of different commands like read_csv and so on)? I’m using jupyter lab everyday and haven’t seen that ! Cool

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

This is great

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

Are you streaming this evening?

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

Great as always! Now get to work and make tutorials for seaborn and matplotlib :)

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

WERY NİCE .. THANKS FOR YOUR EFFORTSS :))

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

Masterpiece thanks thief!

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

Hi @robmulla In Handling Missing Data chapter, would be nice, if you could provide your insight as the best approach and what is normally recommended to do, if it is fillna or dropna, I know that it could be subjective to the task at hand, but having insight as expert would be nice.

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

hi! What plugin do you use to see the details of each function?

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

Great question! Shift-tab in jupyterlab.

@s.joseph4838 9 месяцев назад

I'm new to Data Science. Type every information on my jupyter lab. And im getting error and not dine. I don't understand this, smh what I'm im doing wrong

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

Thanks Rob 15 min done still 7 to go.

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

Nice! 🙌

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

Hi Rob, Please start some series on Tableau. Regards.

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

nice, if would be useful if you could put a link for downloading your dataset so we could play around with your data while you explain, it would be appreciated, for example I would need to see by myself what the difference reindexing does when combining datasets, it is not immediately obvious to me and would require some test and comparisons

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

The datset is on kaggle. Check out this notebook where someone linked the dataset and included the tutorial code: www.kaggle.com/code/lizhecheng/pandas-2-0-1-tutorial/notebook