Import pandas and NumPy packages. $(2$pts$)$

Create a list that contains $"$id$"$ and a dictionary containing other sets of data, such as "name," "score," "attempt," and "pass$/$fail$."(5$pts$)$

Create a data frame by taking the dictionary and the list $($as the index$)$ you created in b$).(3$pts$)$

Select and display the 'name' and 'score' columns of the records $($rows$)$ of $1,3,5,$ and $6$ from the data frame. $(7$pts$)$

Select and display the rows where the number of attempts is greater than $2.$ Then, select and display the rows where the score is missing $($N$/$A$).$ Also, display the records that hold both conditions. $(13$pts$)$

Append the new record $"$k$"$ to the data frame with the given values of each column as name: 'Song,$\text{'}$ score: $\text{'}15\mathrm{.}5\text{'},$ attempt: $\text{'}1\text{'},$ and pass$/$fail: 'yes.$\text{'}$ After appending the new record, delete the record of $\text{'}$h$\text{'}$ from the data frame. $(10$pts$)$

Replace values of 'yes' and $\text{'}$no$\text{'}$ in 'pass$/$fail$\text{'}$ column with 'pass' and 'fail' and display new the data frame. $(10$pts$)$