(Solved): In Python: 1. Setup a list of lists named emplist to create a data frame using the following column ...

1. Setup a list of lists named emplist to create a data frame using the following column names and associated data values. For example, emplist = [ [1, 'Rick', 623.30, 'MIS'], 2. Create a data frame named empDF from the emplist list of lists 3. Display the structure info of the empDF data frame 4. Display the top 3 rows 5. Use iloc for numeric indexing to display the rows 2 to 5 6. Display emp name and salary using column name indexing with loc 7. Group the data into a data frame named empDeptGroup 8. Using group command, display everyone in the MIS dept 9. Add a column named region to empDE with the following values: ['north', 'south', 'east', 'west', 'south', 'west'] 10.Print the data frame showing the newly added column 11. Append the following data as rows: 12.Print the data frame showing the newly added rows 13. Using the data from Step 1, create a csv file named empData.csv (use Notepad or any text editor; a word processing editor will not work properly) 14. Read and load empData.csv into a data frame named empDE 15. Print empDE to display the data that was loaded into empDF