python coding

Specific goals: O 1. Edit Force AspirateTest.combine_results() Function creates avg_test pandas column by taking the average of displacement and force columns together . use pandas.loc( to isolate the force columns, then take the average of this subset of data local must be used on a dataframe: all_test.loc[rows_to_keep, columns_to_keepl o too keep all rows or columns, use a colon . To select columns by name use, Ex(force columns_to_keep): self.all_test.columns.str.conatins("Force") 2. Edit TestAnalysis.py to combine the avg_test of each Force AspirateTest object created into a single dataframe o retrieve the property from each object, and combine into a dataframe you will need to create an empty dataframe . DataFrame['New_Column_Name'] = pandas_series_object 3. Create a plot from the average test data collected from (2) . Use a line plot Displacement vs Force o include titles, legend o use pandas.DataFrame.plot() or: plt.plot(x_values, y values, legend='test_name') O Please upload your completed TestAnalysis.py directly to canvas. Specific goals: O 1. Edit Force AspirateTest.combine_results() Function creates avg_test pandas column by taking the average of displacement and force columns together . use pandas.loc( to isolate the force columns, then take the average of this subset of data local must be used on a dataframe: all_test.loc[rows_to_keep, columns_to_keepl o too keep all rows or columns, use a colon . To select columns by name use, Ex(force columns_to_keep): self.all_test.columns.str.conatins("Force") 2. Edit TestAnalysis.py to combine the avg_test of each Force AspirateTest object created into a single dataframe o retrieve the property from each object, and combine into a dataframe you will need to create an empty dataframe . DataFrame['New_Column_Name'] = pandas_series_object 3. Create a plot from the average test data collected from (2) . Use a line plot Displacement vs Force o include titles, legend o use pandas.DataFrame.plot() or: plt.plot(x_values, y values, legend='test_name') O Please upload your completed TestAnalysis.py directly to canvas