python panda library

Introduction to Pandas library Series and DataFrame. Lab Exercise You have two files: "loandata.csv","loandata.xlsx". Write Python code blocks that do the following: 1. Read data from the two files. 2. Display the contents of the two files. 3. Display the 2nd and 4th columns from "loandata.csv"file. 4. Find out and display information of who has (Loan Status = Y) from "loandata.csv"file. 5. Insert a column in the third position of the "loandata.xlsx" and fill it with 'nan' values. 6. Display the shape of "loandata.xlsx"file. 7. Find and drop the missing values from "loandata.xlsx"file. 8. Find out and display information of who has (Applicantincome>8000 or CoapplicantIncome>3000) from "loandata.xlsx"file. 9. Concat the two files "loandata.csv" & "loandata.xlsx". 10. Save the newfile as "Newloandata.csv