please use numpy, pandas or matplot,hw6.ipynb are the second and the third pictures, thanks.

Problem 1 (40 pts): Fill in the blank under Problem 1 in HW6. ipynb. The detailed instructions are given in HW6. ipynb. Problem 2(50pts) Fill in the blank under Problem 2 in HW6 . ipynb. In this problem, you need to draw a bar plot visualizing the number of people whose last names starts with "A", "B", "C", "D", "E" and "F". In the end, you should get a figure like follows. You can adjust the bar width, figure size, etc., but your figure should look essentially the same. Display the rows where the last name starts with " A " Display the rows where the last name starts with "A