Question

Consider the DataFrame df shown below.

	Name	Department	Salary
0	Rohan Sharma	IT	75000
1	Meera Kapoor	HR	68000
2	Aarav Singh	Finance	85000
3	Nisha Singh	Marketing	72000
4	Aditya Verma	IT	80000

Write Python statements for the following tasks:

1. Print the last three rows of the DataFrame df.
2. Add a new column named "Experience" with values [5, 8, 10, 6, 7].
3. Delete the column "Salary" from the DataFrame.
4. Rename the column "Department" to "Dept".
5. Display only the "Name" and "Salary" columns from the DataFrame

Answer 1

1. print(df.tail(3))

2. df['Experience'] = [5, 8, 10, 6, 7]

3. df.drop(columns=['Salary'], inplace=True)

4. df.rename(columns={'Department': 'Dept'}, inplace=True)

5. print(df[["Name", "Salary"]])