No video :(

Learn how to use PANDAS in Python in 15 minutes - with 10 real examples

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

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

50% 1

Pandas is the most useful data analysis package in Python. You can use it to clean-up, transform and analyze data. Recently, I had a chance to use Pandas for some work. So, in this video let me share a quick but fairly in-depth introduction to Pandas with a real-world case study.
📃❓✅SAMPLE FILES & INSTRUCTIONS:
==================================
~ i n s t a l l a t i o n ⚒ ~
Download and install Pandas & other data analysis packages:
- from Anaconda www.anaconda.com/
- from Pandas website pandas.pydata.org/
- from VS Code code.visualstudio.com/docs/da...
~ s a m p l e f i l e 📃 ~
- Direct Download chandoo.org/wp/wp-content/upl...
- On Kaggle www.kaggle.com/datasets/ronec...
~ c o d e 👨‍💻 ~
- Jupyter Notebook files.chandoo.org/py/pandas-i...
- Kaggle Notebook www.kaggle.com/ronecone/data-...
⏱ VIDEO CHAPTERS 👇
===================
0:00 - What is Pandas for Python?
0:55 - About the sample data & getting started
2:17 - Importing the libraries and loading data to data frame
4:08 - Fixing the data frame delimiter issue
5:21 - Using basic pandas functions (describe etc.)
7:15 - Fixing the text data issue by removing them
8:35 - Solving the problem correctly
11:20 - Adding a column with IF this then that type rule
13:38 - Filling the text value up (using fillna method)
16:13 - Removing the unnecessary rows
16:37 - Doing quick analysis of data (tables & graphs)
📚 LEARN MORE ABOUT PYTHON
============================
Watch my 1-hour Python Tutorial to understand and write your first programs - • Python for Absolute Be...
🤷‍♀️ Other ways to clean this data
===========================
We can also use Power Query in Excel to cleanse and process this data. See this tutorial for that - • Data Cleaning PRO Tip:...
📚 LEARN MORE ABOUT PANDAS
============================
Data Science with Pandas - Tutorial on VSCODE page - code.visualstudio.com/docs/da...
Pandas documentation & examples - pandas.pydata.org/docs/gettin...
📕📗📘 Pandas books:
Python for Data Analysis: Data Wrangling with Pandas, NumPy, and IPython by Wes McKinney - amzn.to/3QPTgCt
Pandas Cookbook by Daniel Chen - amzn.to/3ROiQbW
~
🐼 What do pandas use to record their thoughts?
Notebooks of course 📓 🤣
#pandas #python #datascience

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

13 авг 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@likhithlicky2947 Год назад

Please upload complete playlist of python ( Numpy ,pandas , matplatlib),,,as we are eagerly waiting for it...your teaching is so heart touching that we feel like our brother is teaching to us.....please we need this complete playlist...

@harshmehta6321 Год назад

True.

@chandoo_ Год назад

Thanks for such kind words. Unfortunately, I don't use a lot of Python in my day-to-day life. So, creating a playlist or series is not possible at this time. But I will certainly keep this request in mind and as I learn and expand my knowledge, I will add such videos.

@RK-wf7re Год назад

Yes exactly ..It's need of the hour for BI analysts.

@raghuram8645 Год назад

Please make a complete data analysis python video as it is the most extensively used tool.

@saibalmukherjee3301 Год назад

Yes sir we need it desperately..

@soumadip.m Год назад

Seriously, Leila and Chandoo, these 2 legends changed the way I think and use data in excel. You helped me crack a new job even. Thank you so much!

@chandoo_ Год назад

Thanks Soumadip for such lovely words. Leila is an inspirational teacher.

@StefanoVerugi Год назад

watching Chandoo's you realize that it's not a matter of easy or difficult programming languages but good or bad video tutorials, thank you sir for making things easier for the lot of us

@dattavalloju5160 Год назад

Python is executed line by line and you're explaining line by line very clearly... Love from Texas.

@chandoo_ Год назад

Awesome, thank you!

@danielurbaniak3602 Год назад

Hi Chandoo, I'd just want to say that you're doing a great job sir! Keep going!

@AlbouryNdiaye-ro8qz 7 месяцев назад

This tutorial is a masterpiece. Thank you Chandoo!

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

You're very welcome!

@hareshpatil6939 Год назад

Chandoo plz make a complete video list for data analysis using python especially libraries

@chandoo_ Год назад

Thanks for the suggestion Haresh. I spend less than 5% of time doing coding work. As of now, I plan to add 1-2 videos on coding / automation every 2 months. If I end up doing more coding work, I will certainly share more topics.

@harishpoalampalli9637 Год назад

This is cool and awesome !! Please share more videos on pandas like joins and automations !!

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

It took me 15 weeks to finally complete this 15 minute video. I'm crying

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

Congratulations. The first few steps are always hard. It took me almost 40 years to write my first lines of Python code.

@abigail9457 Год назад

Who are you?!?!....Probably mind reader. Was about get started with pandas and you upload this. Real saviour...cannot thank you enough

@chandoo_ Год назад

df.readmind()

@AznBMan75 Год назад

Good video working with weird data and dates! Real-life issues.

@user-oi3yb7mm7h Год назад

There is no place for even the minutest amount of dirt in our hearts. Alexandre Dumas once said that it is difficult to understand others, but the most difficult thing is to understand yourself. Never allow yourself to fall into any trap. Never allow the least karmic obstacle to take form, nor harbour any unwholesome thoughts in your mind.

@nafishalam203 Год назад

Hello sir, thanks for this powerful video. I have been following you since past 2 years and your videos helped me alot in this.. I'm want to trasition my career into data analyst. Can yoh please give me some information about the career opportunity for data analyst or business analyst in new zealand or any other foreign countries

@chandoo_ Год назад

You are welcome, Nafish. I am not an expert in job hunting or anything. So can't really talk about this.

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

Very helpful

@andybecker5001 Год назад

Actually looking to solve this same scenario. Good stuff

@chandoo_ Год назад

Glad to hear that.

@nomahlubithunyiswa2761 Год назад

Looking forward to taking notes from this video. Thank you Chandoo.

@chandoo_ Год назад

Awesome to hear that Nomahlubi.

@nomahlubithunyiswa2761 Год назад

I'm still starting with Python, so this was a bit confusing for me. But I decided to replicate what you did using Power Query and I am so proud of myself 😁because it was my first time using a conditional column. After transforming the data on Power Query, I created a dashboard. Thank you Chandoo you have been so much help in my journey to data and analytics🤗.

@sagarsamalla7313 Год назад

Thank you so much for starting videos on Pandas😀

@chandoo_ Год назад

My pleasure Sagar.

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

Please upload video for all the mathematical concepts which is necessary for data analytics and science

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

Thank you for this video. Looking at data I first thought that data below headers that had NAs next to it in other columns, is below so you'd have do use fill down. I think it makes sense to understand the structure first and then make structural changes. Also want to commend your fast learning in this area. Did you also try using M code to come up to desired solution? Thank you for posting

@alannavarrovaldez3117 Год назад

I started to read the book of data analysis for python from Wes McKinney, is really good and covers a lot of basic python stuff.

@chandoo_ Год назад

I read a few chapters of it on eBook version a while ago. But doing a real-world problem solving (as shown in this video) is what helped me really appreciate and understand Pandas better.

@patlecat Год назад

Great intro, thanks

@muhammadsadiq2330 11 дней назад

Chandoo, I think Power Query is powerful and easy in many aspects of our common tasks in Python data analysis. What do you think? Without Python, data analysis would be no problem.

@chandoo_ 11 дней назад

Totally agree. Power Query is my goto for tasks like this (followed by formulas in Excel). But if I am building a learning model or application where everything happens in code, then Pandas becomes essential.

@huntershikhari2729 Год назад

Please post a complete or detailed tutorial on data analysis with python...

@kadourkadouri3505 Год назад

Nice Job ! Keep it up

@Gaurav-ky8qw Год назад

sir plz bring more videos on tips & trick in numpy and pandas ......

@chandoo_ Год назад

Thanks Gaurav.

@kadichidu4171 Год назад

Please make a full course on data analysis

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

Thank you, Chandoo

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

Why we don't use power bi or excel in this situation kindly tell me please 😢😢😢

@basicinfoforall7306 Год назад

Let me see all about it.

@hgamedia3544 Год назад

why you so funny sir? i cant stop laughing at your first scene in every videos

@suhailhussain3629 Год назад

Nice video sir🙌🏻 By the way, will Machine learning also be used in future from Data analysts or not sir??

@chandoo_ Год назад

You are welcome, Suhail. ML and AI are already widely used in data analysis.

@Factindust Год назад

The only favourite if I have to learn something new my youtube land me here always ........

@chandoo_ Год назад

😊😊😊

@muhammadobaidkhan4099 Год назад

Awesome

@chandoo_ Год назад

😎😎😎

@edu1113 Год назад

Hi.. excellent video as always.. anyway, i remember at one point u mentioned that u were involved in HRM data analytics for the NZ Govt.. coincidentally, im applying for data analytics position which will look into HRDM data for our state.. any videos on that particular case? What would be your advice for someone applying for this job?

@chandoo_ Год назад

I do have a playlist of HR data analysis. Check it out - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-nqYUmGZMnU0.html

@rohitkrishna2648 Год назад

@@chandoo_ please take data analyst test of relevel and put a feedback if it's tough or not.i couldn't crack that.its employment test by unacademy

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

Share dataset also for practice purpose

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

Refer to the video description for the link to dataset

@osamahameed1236 Год назад

Is panda better than Excel? Or can panda replace excel?

@Mania-zknowledge Год назад

Sir, Can you do videos for data science students?

@chandoo_ Год назад

As I solve such problems, I will share my knowledge with all. So far, I do very little DS work.

@sureshboddana33 Год назад

Nice chadooo. Great effort please do video on seaborne @ matplotlib

@scotttheniceguy Год назад

I've ben trying ro go through this tutorial using PyCharm and somehow Pandas won't install at all like it used to in the past.

@chandoo_ Год назад

I had a similar problem at work the other day. Are you seeing any specific errors? I suggest either using pip or anaconda to get all packages in one go.

@scotttheniceguy Год назад

@@chandoo_ Just failure to install errors; I ended up using pip instead

@thamilanban Год назад

Is there any reason for a Power BI user to learn Pandas?

@chandoo_ Год назад

Depends. You can use Python from Power BI to do both ETL and visuals. Plus learning new things is fun and exciting for our minds.

@azaddeenazom1464 Год назад

wanna learn complete series like trumpexcel

@chandoo_ Год назад

I do have courses for that. It is tricky to maintain series thru YT. If you want to learn Excel step-by-step in one place, do check out chandoo.org/wp/excel-school-program/