In Python, show

Create an excel file consisting of ten students names in the following form: lastName, firstName, middleName in a single column. (Note that a student may not have a middle name.)

Syafiqah, Siti, Nur

Tan, Shin,

Mimi, Lana, M

Write a program that converts each name to the following form, called as altered name: firstName middleName lastName.

Siti, Nur, Syafiqah

Shin, , Tan

Mimi, M, Lana

Your program must read each students entire name in a variable and must consist of a function that takes as input a string, consists of a students name, and returns the string consisting of the altered name.

You should be able to sort the list from the source excel file and store the result in another excel file. The resultant excel file should contain two sheets:

1. First sheet should contain sorted student names according to the original data format.

2. Second sheet should contain sorted student names according to the altered name format.