\[ \begin{align}\begin{aligned}\newcommand\blank{~\underline{\hspace{1.2cm}}~}\\% Bold symbols (vectors) \newcommand\bs[1]{\mathbf{#1}}\\% Differential \newcommand\dd[2][]{\mathrm{d}^{#1}{#2}} % use as \dd, \dd{x}, or \dd[2]{x}\\% Poor man's siunitx \newcommand\unit[1]{\mathrm{#1}} \newcommand\num[1]{#1} \newcommand\qty[2]{#1~\unit{#2}}\\\newcommand\per{/} \newcommand\squared{{}^2} \newcommand\cubed{{}^3} % % Scale \newcommand\milli{\unit{m}} \newcommand\centi{\unit{c}} \newcommand\kilo{\unit{k}} \newcommand\mega{\unit{M}} % % Percent \newcommand\percent{\unit{{\kern-4mu}\%}} % % Angle \newcommand\radian{\unit{rad}} \newcommand\degree{\unit{{\kern-4mu}^\circ}} % % Time \newcommand\second{\unit{s}} \newcommand\s{\second} \newcommand\minute{\unit{min}} \newcommand\hour{\unit{h}} % % Distance \newcommand\meter{\unit{m}} \newcommand\m{\meter} \newcommand\inch{\unit{in}} \newcommand\foot{\unit{ft}} % % Force \newcommand\newton{\unit{N}} \newcommand\kip{\unit{kip}} % kilopound in "freedom" units - edit made by Sri % % Mass \newcommand\gram{\unit{g}} \newcommand\g{\gram} \newcommand\kilogram{\unit{kg}} \newcommand\kg{\kilogram} \newcommand\grain{\unit{grain}} \newcommand\ounce{\unit{oz}} % % Temperature \newcommand\kelvin{\unit{K}} \newcommand\K{\kelvin} \newcommand\celsius{\unit{{}^\circ C}} \newcommand\C{\celsius} \newcommand\fahrenheit{\unit{{}^\circ F}} \newcommand\F{\fahrenheit} % % Area \newcommand\sqft{\unit{sq\,\foot}} % square foot % % Volume \newcommand\liter{\unit{L}} \newcommand\gallon{\unit{gal}} % % Frequency \newcommand\hertz{\unit{Hz}} \newcommand\rpm{\unit{rpm}} % % Voltage \newcommand\volt{\unit{V}} \newcommand\V{\volt} \newcommand\millivolt{\milli\volt} \newcommand\mV{\milli\volt} \newcommand\kilovolt{\kilo\volt} \newcommand\kV{\kilo\volt} % % Current \newcommand\ampere{\unit{A}} \newcommand\A{\ampere} \newcommand\milliampereA{\milli\ampere} \newcommand\mA{\milli\ampere} \newcommand\kiloampereA{\kilo\ampere} \newcommand\kA{\kilo\ampere} % % Resistance \newcommand\ohm{\Omega} \newcommand\milliohm{\milli\ohm} \newcommand\kiloohm{\kilo\ohm} % correct SI spelling \newcommand\kilohm{\kilo\ohm} % "American" spelling used in siunitx \newcommand\megaohm{\mega\ohm} % correct SI spelling \newcommand\megohm{\mega\ohm} % "American" spelling used in siunitx % % Capacitance \newcommand\farad{\unit{F}} \newcommand\F{\farad} \newcommand\microfarad{\micro\farad} \newcommand\muF{\micro\farad} % % Inductance \newcommand\henry{\unit{H}} \newcommand\H{\henry} \newcommand\millihenry{\milli\henry} \newcommand\mH{\milli\henry} % % Power \newcommand\watt{\unit{W}} \newcommand\W{\watt} \newcommand\milliwatt{\milli\watt} \newcommand\mW{\milli\watt} \newcommand\kilowatt{\kilo\watt} \newcommand\kW{\kilo\watt} % % Energy \newcommand\joule{\unit{J}} \newcommand\J{\joule} % % Composite units % % Torque \newcommand\ozin{\unit{\ounce}\,\unit{in}} \newcommand\newtonmeter{\unit{\newton\,\meter}} % % Pressure \newcommand\psf{\unit{psf}} % pounds per square foot \newcommand\pcf{\unit{pcf}} % pounds per cubic foot \newcommand\pascal{\unit{Pa}} \newcommand\Pa{\pascal} \newcommand\ksi{\unit{ksi}} % kilopound per square inch % NOTE: do NOT define \bar -- it is the built-in LaTeX accent used by \bar{x}, % \bar{y} (sample means). Redefining it made those render as the word "bar". \newcommand\barunit{\unit{bar}} \end{aligned}\end{align} \]

Nov 16, 2026 | 835 words | 8 min read

12.3.1. PY: Regression#

Task #1: Wabash River Health - Dissolved Oxygen Analysis#

Background#

Dissolved Oxygen (DO) is one of the most critical indicators of river health. Fish and aquatic organisms need adequate DO to survive. DO levels are strongly influenced by water temperature: warmer water holds less dissolved oxygen (an inverse relationship).

As a junior environmental engineer at the fictional Wabash River Authority, you have been given 20 water quality measurements collected over a summer monitoring campaign. For this task you will:

  • Visualize the relationship between temperature and DO

  • Build a linear regression model to predict DO from temperature

  • Evaluate your model’s performance

  • Use your model to make engineering decisions

Required Files#

  1. Download the template ENGR131_Python_Template.py and save as 12_3_1_username.py.

  2. Download the CSV file river_data.csv for analyzing the Wabash river dissolved oxygen data. Do not submit this file to Gradescope

  3. Create and save your figures as PNG files:

    • Figure 1: 12_3_1_do_temp_plot_username.png

    • Figure 2: 12_3_1_do_temp_regression_plot_username.png

  4. Download the report template, complete it, and save it as 12_3_1_report_username.pdf.

Reminder

Review and reference the Python Style Guide to create a professionally formatted code file. For example, remember to provide detailed comments throughout your code so anyone can read them and understand what your program does!

Program Requirements#

Dataset Description

You are provided with a CSV file named: river_data.csv. The dataset contains water quality measurements collected at three Wabash River monitoring sites.

Dataset Columns

Column

Description

sample_id

Unique sample identifier

site

Monitoring site (A = upstream, B = midstream, C = downstream)

temp_c

Water temperature (\(^\circ\text{C}\))

do_mg_l

Dissolved oxygen concentration (mg/L)

ph

Water pH

Required Libraries

  • numpy

  • pandas

  • matplotlib

Part 1: Load and Explore the Dataset#

  1. Import the required libraries

  2. Load the CSV file into a pandas DataFrame

  3. Display all rows in the DataFrame.

  4. Print:

    • A formatted assignment header

    • Summary statistics for:

      • temperature

      • dissolved oxygen

      • pH

See the sample output below to review formatting of program output.

Hint

Use the describe() function to generate summary statistics.

Part 2: Exploratory Scatter Plot#

Create a scatter plot showing the relationship between water temperature (x-axis) and dissolved oxygen concentration. Use a separate color and marker shape for each monitoring site. Be sure to follow the professional plotting guidelines to ensure readability.

Save Figure 1 as a PNG using the file name specified in the Required Files section.

Part 3: Linear Regression Analysis#

Fit a linear regression model to the temperature and dissolved oxygen data:

  1. Define the independent variable (x, temperature) and dependent variable (y, dissolved oxygen concentration).

  2. Use the polyfit() function to fit a linear model to the data.

  3. Compute predicted y-values for the regression model.

  4. Calculate Sum of Squared Errors (SSE), Sum of Square Total (SST), and \(r^2\) value. Equations for SSE, SST, and \(r^2\) can be found in the Linear Regression Excel materials.

  5. Display your results in the following order (see sample output) and format values to 3 decimal places.

    • Slope

    • Intercept

    • SSE

    • SST

    • \(r^2\)

Part 4: Regression Line Plot#

Plot the linear regression model on the same figure as the scatter plot. The data markers should overlay the regression line so they are visible. Ensure the plot has an informative title and a legend with labels for the data markers and regression line. The regression label should display both the model equation and \(r^2\) value.

Save Figure 2 as a PNG using the file name specified in the Required Files section.

Sample Output#

Sample Output

$ python3 12_3_1_username.py--- WABASH RIVER AUTHORITY: Water Quality Dataset --- sample_id site temp_c do_mg_l ph0 1 A 14.2 10.1 7.81 2 A 15.8 9.6 7.92 3 A 17.1 9.1 7.73 4 A 18.5 8.7 7.84 5 A 19.3 8.4 7.65 6 A 21.0 7.9 7.56 7 A 22.4 7.5 7.47 8 B 16.5 9.3 7.68 9 B 18.0 8.8 7.79 10 B 20.2 8.2 7.510 11 B 21.8 7.8 7.411 12 B 23.5 7.2 7.312 13 B 25.1 6.7 7.213 14 C 19.8 8.1 7.414 15 C 21.3 7.7 7.315 16 C 22.9 7.3 7.216 17 C 24.4 6.8 7.117 18 C 25.8 6.4 7.018 19 C 27.2 5.9 6.919 20 C 28.6 5.4 6.8--- SUMMARY STATISTICS --- temp_c do_mg_l phcount 20.000000 20.000000 20.000000mean 21.170000 7.845000 7.405000std 3.896976 1.237772 0.308605min 14.200000 5.400000 6.80000025% 18.375000 7.100000 7.20000050% 21.150000 7.850000 7.40000075% 23.725000 8.725000 7.625000max 28.600000 10.100000 7.900000--- LINEAR REGRESSION RESULTS ---Slope: -0.317 mg/L per deg CIntercept: 14.556 mg/LSSE: 0.111 (mg/L)^2SST: 29.109 (mg/L)^2r^2: 0.996

Task #2: Analysis Questions#

Complete the analysis questions in the report template downloaded from the Required Files section. Use specific examples from your program to support your responses and use clear, professional language.

Save the completed report using the file name specified in the Required Files section.

Gradescope Submission#

Attention

Before submitting your python file, comment all lines with plt.show() for autograding purposes.

  1. Save Deliverables: Ensure all required assignment files are saved and named exactly as specified in the assignment instructions. If a template file name contains the word template, replace only that word with your Purdue username. When a task lists more than one deliverable, such as a workbook and a report, submit each deliverable to its own matching Gradescope assignment instead of combining them into one upload.

  2. Navigate to Gradescope: Log in to Gradescope. From your Dashboard, open the assignment.

  3. Upload your work: Select the Upload submission method. Drag and drop all required files (or a compressed .zip folder) into Gradescope, and select Upload.

  4. Confirm Submission: When your upload is successful, you will see a confirmation message on your screen and receive an automated email receipt.

  5. Add Team Members (if applicable): If this is a team assignment, add all team members to the submission. Each teammate should confirm they can see the submission in their own Gradescope account. For help, visit Gradescope’s documentation on adding team members.

  6. Review Autograder Results: Wait a few minutes for the autograder to evaluate the relevant files. Scroll down to view any failed test cases. If you need assistance interpreting the output or errors, ask your teaching team.

  7. Resubmit if Necessary: You can edit your files and select Resubmit as many times as you need before the assignment deadline. Only your final, active submission is graded. (Note: If you need to resubmit, you must upload all required files for the assignment again).

For a detailed walkthrough, review the official Gradescope Submission Guide.