Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: daixieit

Tools for Engineering Design 2

Data Processing Individual Project

The project

A new shipping channel is required due to the construcGon of a bridge connecGng Lachtenstein and Crowrovia. The problem is shown graphically inFigure 1andFigure 2. A depth survey has been conducted of the region, and the survey data for the exisGng seabed profile is provide in a raw format in the spreadsheet file available on Learn.

You need to calculate the volume of material to be dredged to form the new shipping channel based upon the survey data. An accurate esGmate of volume dredged in m3  is required to esGmate the costs of dredging the shipping channel. Note you do not need to esGmate the cost, just the volume.

Note that:

1.    The calculaGon is not trivial and there are many ways of going about it. It is o?en a good idea to start by solving a simplified version of the problem with pencil and paper before moving on to the real, more complex, data. It is also a good idea to solve the problem in two or more ways to see if results sGll make sense and are robust to any methodological assumpGons you  may have introduced in your approach.

2.    The survey data comes in a standard format that holds data that is messy and difficult to

read by a person. This is very common with large datasets handled by computers. You may assume that:

a.    the survey is always carried out in the same way, meaning that the ship surveys a rectangular domain of the seabed following arecGlinear gridwhere the spacing between lines are always the same;

b.   the file format of the survey data does not change, meaning that its structure will

always be the same for the ‘metadata’ sheet, and that the table in ‘data’ will always have the same number of columns and units, although the number of rows may vary.

3.    Take care to understand what units and datums are being used in this survey. This is again a

common occurrence in pracGce and can cause problems (see for example theMars Orbiter Mishap InvesGgaGon Board Phase I Report).

4.    The data contains errors due to mis-readings and logging issues during the survey. Your approach and/or calculaGons should be resilient to the worst of these errors.

The intenGon is that in a few years’ Gme a similar survey will take place (a?er the iniGal dredging) to assess if the channel needs to be re-dredged to ensure the required depth is maintained. Your company want to set out your calculaGons so that this can be done with the minimal of effort in the future for this and other projects.

Presenting the project

It is very important to take care when construcGng any set of design calculaGons so that somebody  else can easily understand it. It must be possible for another engineer to understand, check, and if necessary, extend or modify your calculaGons. Remember that this engineer may not be able to ask you about the content of your files so the methods and where the data is coming from needs to be  extremely clear to a future engineer.

Making the calculaGons is only part of the current exercise; you need to produce reports in a neatly formajed Jupyter Notebook and Excel spreadsheet – the raGonale for the lajer is that colleagues who are not familiar with Python can sGll review the project for themselves. (Note: that the output data is more than just the final volume to be dredged, but short report on the key input data and process as well).

Figure 1: Plan of proposed shipping channel under the new Crowlach crossing. Coordinates in metres from the indicated datum. Not to scale. SecGon A-A drawn in Figure 2.

Figure 2: Typical secGon A-A through the planned Crowlach Straits shipping channel. Lowest astronomical Gde (LAT) data taken from hydrographic office publicaGons.

As requested, here there are hints to help you in your project:

1.    Read this brief carefully. Note that the submission includes two reports: one in a Jupyter notebook and one in the spreadsheet. They are both reports about the project, but they should be different as they are meant for different types of audience.

2.    Engage with the project early on and seek support if you need it. In our experience, even if you started from scratch in programming, there is plenty of Gme and support to achieve marks over 70% in this project if you engage with it right from the start.

3.    Please submit the correct files (not RAR or anything else). Check that the ZIP file is created correctly and that its contents are as you expect them to be. Note that when doing things  correctly the ‘.ipynb’ file and the ‘.html’ file should have idenGcal content.

4.    In a good Jupyter notebook, it is possible to clear all contents and rerun the whole notebook to produce the exact same results. It is a good idea to double check that one can do that using just the ZIP file being submijed (i.e., extract the contents in a random folder in your computer and verify it works as intended).

5.    Think carefully about the best way to set out and present the data so that you can verify things are working as intended and that somebody else can easily understand it.

6.    Always think about the accuracy of your data and results, and only present to an appropriate number of decimal places and include units (just as with hand calculaGons).

7.    Bear in mind that somebody looking at your notebook or spreadsheet in the future is

unlikely to have a copy of this brief. A good set of design calculaGons will always include general informaGon, concise and well explained calculaGons and processes (without needing to look in the cell formulae) and will be carefully formajed.

8.    If you choose to informaGon available in this brief, please cite it appropriately as you would in any other selng. The library has resources available on this topic if you need help, like access to the service called ‘Cite Them Right’.

9.    The example files on Learn based on the video (both Python and Excel spreadsheet)

showcase a work in progress to give you an idea of where to begin. Further work would be needed to bring that to the standards expected for high marks on this assignment.

10. The example notebook contains a basic showcase of the libraries and funcGons that you

might find useful. For example,pd.read_csvis useful to read CSV data and has lots of opGons in the documentaGon (click on the link). For this project I would usepd.read_excelsince the   data comes in an Excel spreadsheet. Similarly, think about the kinds of figures that would be  most informaGve, which are going to be different to the ones used in the example.

11. Asking for help about code is a tricky business.

1)   There is the temptaGon of thinking that a piece of code that executes without coding errors is working as intended. That is not necessarily the case.

2)   SomeGmes coding errors reveal mistakes one might be making (like `“a” + 1` fails to   add `1` to the string `a`). Some other Gmes they can be used as safeguards for things that should not work (like `1/0`, division by zero) or that your algorithm does not

support (like raising an error if the data does not saGsfy key assumpGons).

3)    Programming languages have mechanisms to report coding errors. Seeone of the many tutorialsavailable on how to read them for the Python language. Once you

know what the coding error is about, it is easier to find help online. For example,

`1/0` raises in Python a `ZeroDivisionError` and searching for that error leads to, for example,this page.

4)   When asking someone else help with a problem, it is good pracGce to create a Minimal, Reproducible Examplewhenever possible.