loc & iloc difference

Class XII informatics practices 065 session 2021-22 Term1 Exam video for loc and iloc

loc

loc is used to access a group of rows and columns from a dataframe using row labels or column labels i.e. row names or column names
It is used to
1) Access or select certain rows and column
2) Access or select certain range of rows and columns using : Slice. While using slice with loc, it includes both start and stop labels
3) It is used to filter out certain information based on a given condition
4) To update a particular value
5) It is based on index label not index number
6) It is used to add a new column, modify an existing column
7) It is used to add a new row, modify an existing row

iloc

iloc is used to access a group of rows and columns from a dataframe using row index or column index . It does not use row label or row name and column label or column name
It is used to
1) Access or select certain rows and columns
2) Access or select certain range of rows and columns using : Slice. While using slice with iloc, it does not include both start and stop index. It takes the start index but goes till
stop-1.
3) Not used to filter out certain information
4) To update a particular value
5) It is based on index number not index label
6) It is not used to add a new column but modify an existing column
7) It is not used to add a new row but modify an existing row