Magic methods to change data طرق سحرية لتغيير الداتا

In this video we learn how to update columns and rows , how to change columns names , we will use apply , map , replace and applymap to change data in one line of code
------------------------------------------------------------------------------
▶ Download Dataset: https://www.kaggle.com/datasets/spscientist/students-performance-in-exams?resource=download

▶ Download Anaconda: https://www.anaconda.com/products/distribution
▶ How to download: https://www.youtube.com/watch?v=aN6OVm0mTHo
-------------------------------------------------------------------------------
⏱️⏱️VIDEO CHAPTERS⏱️⏱️
0:00 - Magic methods to change data
0:07 - Introduction
0:45 - Change columns names
7:45 - Change column values
12:46 - Change column values (apply,replace,map)
20:23 - Change all values in dataframe (applymap)
24:00 - Exercises
-------------------------------------------------------------------------------
Exercises :
Q1) Change the column name "test preparation course" to "course test"
Q2) Replace all spaces in columns names with underscore (example: math score to math_score)
Q3) Change the record with index 996 from male to female
Q4) In column "course test" change all the values named "none" to "no" (hint: use filter or replace)
Q5) Add 5 to each value in math score
Q6) Select columns with object data type and make all the values in upper case ( hint : use select_dtypes(include="str"))

-------------------------------------------------------------------------------
في هذا الفيديو سوف نتعلم كيف نغير اسماء الكولم و كيف نغير قيمة معينة في الداتا والتلاعب في داتا