Question: Python 1. Setup a list of lists named emplist to create a data frame using the following column names and associated data values. For example,
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 Iist or Ists 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 4 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 the end of columns in empDF with the following valu ['north', 'south', 'east', 'west', 'south', 'west'] 10. Print the top 5 rows of the data frame showing the newly added region column 11. Append the following 2 rows of data: 12. Print the bottom 5 rows data frame showing the newly added rows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
