a python code is needed by using the information in the first picture and to format a file like the second image shows

Problem 1: (30 Points) Eureka Lumber Company would like to calculate the gross pay for its employees. The employees information is stored in a file as name ie number RaY..tYee pay .cate hours worked The fields are separated by a tab "It" delimiter, and they are described as follows: a, name is a string value b. . number is a numeric integer value c. pay type is a character, either H for hourly, or S for salary d. pay rate will hold the hourly rate for an hourly paytype, or it would hold the total salary for a salary pay..tyee hours worked holds the total number of work hours for the employee e. The employee gross pay is compute as follows: If employee paytvpe is hourly gross pay pay.rate " hours .worked Else if employee pay..tpe is salary based gross pay pay rate Problem 1: (30 Points) Eureka Lumber Company would like to calculate the gross pay for its employees. The employees information is stored in a file as name ie number RaY..tYee pay .cate hours worked The fields are separated by a tab "It" delimiter, and they are described as follows: a, name is a string value b. . number is a numeric integer value c. pay type is a character, either H for hourly, or S for salary d. pay rate will hold the hourly rate for an hourly paytype, or it would hold the total salary for a salary pay..tyee hours worked holds the total number of work hours for the employee e. The employee gross pay is compute as follows: If employee paytvpe is hourly gross pay pay.rate " hours .worked Else if employee pay..tpe is salary based gross pay pay rate