Task 1: The given two data files are:
- data.xlsx
- data_1.xlsx Converting two given data files to .csv files
- data.csv
- data_1.csv Combining two csv files to detail.csv file, Combining two csv files to detailVol.csv, Combining two csv files to detailTemp.csv file using python
The source code is given in the .py file named Nunam_task1
Task 2: Apply down-sampling method to reduce the sampling rate to 1 sample/minute
- Importing pandas as pd
- Importing datetime as datetime
- By setting the low_memory argument to False
- Reading detail.csv
- Using down sampling fetching value of 04:23:15 in Record ID
The source code is given in the .py file named Nunam_task2
Task 3: Low pass filter technique for noise removal on the data set for 'detailVolDownsampled.csv'.
- Install packages scipy, csv, pandas, numpy, matplotlib
- And define a function plot
- Read csv file for detailVolDownsampled.csv
- And data frequency data for ‘Voltage’
- And define a function bandpassFilter(signal)
The source code is given in the .py file named Nunam_task3
Task 4: Run profile for all the functions; use cProfile for Python for profiling of individual functions.
- Importing the packages cProfile, re
- And running re.compile
The source code and the output is gien in the .txt file named Nunam_task4
Task 5: Run unit test on each function
- Import package unittest
- Creating class teststringmethods
- Defining function test_upper, test_isupper, test_split with self parameter
- special name variable to have a value “main”.
The source code and the output is gien in the .txt file named Nunam_task5