Given the payroll data set below:

Identify employee names based on the pattern where an employee name is followed by multiple rows of date-wise payment data. Recognize that all the rows following an employee name, up until the next employee name, belong to the same employee.

For each employee:

Aggregate the NAME_1 Pay across all the date-wise rows.
Compute the Total Federal Taxes as the sum of 'Federal Withholding', 'Soc Sec', and 'Medicare' across all date-wise rows for the specific employee.
Aggregate the State Withholding across all the date-wise rows.
Represent the extracted and calculated data in a table format, with columns titled:

'Employee Name'
'NAME_1 Pay'
'Total Federal Taxes'
'State Withholding'
Ensure the final table provides a summarized view for each employee, capturing their total NAME_1 Pay, Federal Taxes, and State Withholding based on the data provided.


	                                                      Widget Manufacturing Corp.
Employee Payroll Report
From 9/1/2012 to 9/30/2012
Employee Info                                          Federal                                                                                            Other

												Pre-Tax    Taxable    Federal  Soc Sec  Medicare                  State        Other                     Deductions

	Check #        Pay Date          NAME_1 Pay  Deduction  Wages      Withholding Withholding Withholding         Withholding  Withholding      SUI/SDI  (Additions)  Net Pay
Department : Accounting
1004 NAME_2
09/05/2012        2,880.00   413.00     2,467.00   331.92   115.71             39.95    NY  :  95.21        0.00             0.00          0.00    1,828.36
																										   CA  :  55.85
	DD             09/28/2012        720.00     197.00     523.00     59.38    24.99              8.62     NY  :  0.00         0.00             0.00          0.00    408.01
																										   CA  :  22.00
				   09/30/2012        2,880.00   413.00     2,467.00   331.92   115.71             39.95    NY  :  95.21        0.00             0.00          0.00    1,828.36
																										   CA  :  55.85
				   Employee Totals:  6,480.00   1,023.00   5,457.00   723.22   256.41             88.52           324.12       0.00             0.00          0.00    4,064.73
	1008  NAME_3 NAME_4
				   09/05/2012        5,000.00   419.00     4,581.00   418.00   205.01             70.78    NY :   229.00       0.00             2.60          0.00    3,655.61
				   09/28/2012        1,153.87   188.23     965.64     0.00     4