Тёмный

Missing Value Treatment in Excel | Data Cleaning Using Excel Ep 6 | IvyProSchool 

IvyProSchool
Подписаться 22 тыс.
Просмотров 29 тыс.
50% 1

Data Cleaning is required to identify and treat Missing Values.
In this video, we will see how data cleaning is done by deletion of row and column and also using Mean, Median and Mode.
Watch the whole video to understand the methods.
#datacleaning #missingvaluetreatment #exceltricks #exceltips #exceltricksandtips #datacleaningusingexcel #meanmedianmode
❓Interested in a Data Science or Data Engineering career? Check out the Ivy Pro School’s top ranked Nascomm, Govt. of India and IBM accredited Data Science and Data Engineering courses: ivyproschool.com/
❓Why should you learn Data Science today? • Future Of Analytics & ...
❓Are you a Fresher? Watch this video to know the Data Science Journey for Freshers: • Data Science Journey f...
✅Don’t forget to Subscribe to Ivy Pro School’s RU-vid Channel: / @ivyproschool
✅Learn from Ivy Pro School’s Data Science and Data Engineering Students’ Success Stories : • Student Success Story
Liked the video? Check out below more playlists on Data Science and Data Engineering learning tutorial, alumni interview experiences, live data science case studies,etc:
⏩Students Share Interview Experiences- • Data Science Interview...
⏩Data Cleaning using excel- • Data Cleaning using Excel
⏩SQL Interview questions solved in Hindi - • Sql Interview Question...
⏩PowerBI Tutorials - • Power BI Tutorial
⏩Industry case studies and projects by students - • Industry Case Studies ...
⏩Data Science for Beginners - • Data Science for Begin...
⏩Excel VBA tutorial - • Excel VBA Tutorial
⏩Excel Tutorials by Eeshani Agrawal - • Excel for Beginners
⏩Tableau Tutorials by Eeshani Agrawal - • Tableau Tutorial by Ee...
For more updates on courses and tips don’t forget to follow us on:
- Instagram: / ivyproschool
- LinkedIn: / ivy-professional-school
- Facebook: / ivyproschool
- Twitter: / ivyproschool
- Telegram: t.me/learndswi...
Want to take a Data Science Course with Ivy Professional School - visit us at ivyproschool.com You can call us at +91-7676882222 or mail to info@ivyproschool.com.
#ivyproschool #datawithivy #dataanalytics #analytics

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

 

29 сен 2024

Поделиться:

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 16   
@deeppatel4002
@deeppatel4002 2 месяца назад
CAN WE USE JUST FIND AND REPLACE FOR EACH PARTICULAR COLUMN TO FILL M VALUES IN IT ?
@IvyProSchool
@IvyProSchool 24 дня назад
If you are using find and replace. the number is not dynamic, if someone changes the above cells the number would not change using find and replace.
@trigunmaster28
@trigunmaster28 8 месяцев назад
This is a very useful and simple explanation of cleaning a missing data using different imputation strategy...Thank you for uploading this video...
@IvyProSchool
@IvyProSchool 8 месяцев назад
You are most welcome
@ShreyasSinha
@ShreyasSinha 11 месяцев назад
SuperB Technique, Thank you so much
@IvyProSchool
@IvyProSchool 11 месяцев назад
Glad you liked it!
@NAVEENSHARMA-k3n
@NAVEENSHARMA-k3n 3 месяца назад
I don't understand why your value are showing less or null by using counta
@IvyProSchool
@IvyProSchool 2 месяца назад
The COUNTA function counts cells containing any type of information, including error values and empty text (""). For example, if the range contains a formula that returns an empty string, the COUNTA function counts that value. The COUNTA function does not count empty cells.
@peaceokoroji4869
@peaceokoroji4869 Год назад
Very inisghtful, thank you
@IvyProSchool
@IvyProSchool Год назад
Glad it was helpful!
@amayrasiddiqui334
@amayrasiddiqui334 6 месяцев назад
Really helpful 🙌
@IvyProSchool
@IvyProSchool 6 месяцев назад
Glad it was helpful!
@afzalkhanpathan105
@afzalkhanpathan105 7 месяцев назад
Will this not change, the aggregate of.the column
@IvyProSchool
@IvyProSchool 24 дня назад
Yes, it will change the aggregation based on the aggregation function you are going to use.
@fahad68755
@fahad68755 11 месяцев назад
Good job ❤
@IvyProSchool
@IvyProSchool 11 месяцев назад
Thank you very much!
Далее
Data Cleaning In Excel - Beginners Tutorial
17:07
Просмотров 39 тыс.
Трудности СГОРЕВШЕЙ BMW M4!
49:41
Просмотров 1,5 млн
Advanced Excel Data Cleaning Tricks ONLY Experts Know
13:37
Don't Replace Missing Values In Your Dataset.
6:10
Просмотров 9 тыс.
This is how I ACTUALLY analyze data using Excel
24:05
Просмотров 222 тыс.
How To Handle Missing Values in Categorical Features
6:22