Question

Consider the given DataFrame 'password':

	CodeName	Category	Frequency
0	aaaaaa	alpha	6.91
1	dragon	animal	18.52
2	baseball	sport	1.29
3	football	sport	11.11
4	monkey	animal	3.72
5	qwerty	alpha	1.85
6	abcde	alpha	3.19

Write suitable Python statements for the following:

1. To add a new row with following values:
   CodeName – 'abc123'
   Category – alphanumeric
   Frequency – 12.8
2. To delete the row with the row label 2.
3. To delete the column having column label as Frequency.

Answer 1

1. new_row = {'CodeName': 'abc123', 'Category': 'alphanumeric', 'Frequency': 12.8} password.loc[len(password)] = ['abc123', 'alphanumeric', 12.8] 
2. password = password.drop(2)
3. password = password.drop(Frequency', axis = 1)