Remove-duplicates-excel

To remove duplicated rows from excel file and replace it by one row with mean values in columns.

Put the excel file name for processing as an argument.

I need this code for my workflow and, at the same time, this is a test exercise for Pandas module.

Sample result in graphical form:

Included test file (test.xlsx) is the result of measurement of noise RC-filter. File consists of 3 columns:

1. frequency (Hz)
2. transmitted signal amplitude (V)
3. transmission in dB (plotted on the result graph)