Question: i cant figure out this python code and my professor is no help. ill include picture of the excel files that need to be extracted

i cant figure out this python code and my professor is no help. ill include picture of the excel files that need to be extracted into python

extracted into python - Import the force vs deflection data from TensileTestData.xlsx,

- Import the force vs deflection data from TensileTestData.xlsx, sheetname = TensileTest into a pandas dataframe. - Then extract the force and deflection data into numpy arrays. - Also import the constants data from TensileTestData.xlsx, sheetname = TensileTestConstants into another pandas dataframe. - Extract the gage length and cross-sectional area into some python variables. - Calculate the stress (Force / cross-sectional area) and strain (gage length / deflection) values. - Plot the stress and strain values. - Approximate the linear portion of the curve and save the corresponding stress-strain data using a for loop and if statement into separate arrays. - Overlay this subset on the stress-strain curve using a different color and linestyle Your output should look like so! B. Autosove (k) Autosavi (cin B. File Home Insert Draw Page Lai 677 78910111213141516 Ready IS Accessibility, Good to go 22F Mostly cloudy

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Text Mining Python Code Question is in attached screenshot. Please help to see. Link attached again - Python Relevant Files accessible via this link, please check :...

Requirement 1 : The following articles will introduce you to the intersection of big data and the accounting profession. Even if you are working in groups, I expect EVERY STUDENT to read ALL of these...

I do not have access to Python or excel/office Covid sick cant access school computer last time getting error please help No matter how much I access and cleanData1 I always get an error on every...

Exploratory Data Analysis Introduction This chapter will show you how to use visualisation and transformation to explore your data in a systematic way, a task that statisticians call exploratory data...

Course: Information retrival Programming Assignment (Indexer Part 1) The following example presents an example of what our text calls single pass in memory indexing. This indexer that has been...

this is a python program please can anyone help me thank you Introduction In problem set 5, you will build a program to monitor news feeds over the Internet. Your program will filter the news,...

Using the Scikit-Learn Dataset To load the sample scikit data set, import the datasets module and load the desired dataset. Code Run: from sklearn import datasets import pandas as pd diabetes =...

Process an excel file (chegg does not allow me to attatch excel files so I am pasting the first 100 rows of the tweets in my excel file, you can paste them into a blank excel file) of tweets using...

From the case study of Week # 5 please answer the question Who is responsible for this costly oversight? Who should take responsibility? Who is most likely to be blamed for the error? 11:33 1 5G+ 0 a...

Lesson 12 Quiz (Show/Explain all Work) IST 230 Relations on Sets, Databases 1. Let A = {0, 1, 2, 3, 4, 5, 6, 7, 8} and B = {1, 2, 3, 4, 5, 6, 7, 8}. Now let R be a binary relation R from A to B such...

From 1990 to 2004, labors share of income averaged 60% in Ireland, while real GDP grew at an average annual rate of 6.7%. a. Write an equation similar to Equation (4.5) on page 121 to show growth...

Replace the force system acting on the beam by an equivalent force and couple moment at pointB. 3 kN 2.5 kN 1.5 kN 20e - 4 m- -2 m- 2 m-

Which of the following are characteristics of Treasury bills ( T - bills ) ? Check all that apply. T - bills have maturities of from 6 months to 1 year. T - bills have maturities of 2 8 , 9 1 , and 1...

Problem 13-5A (Algo) Comparative ratio analysis LO P3 [The following information applies to the questions displayed below.] Summary information'from the financial statements of two companies...

Know how service employees and other customers are part of the servicescape.

Be familiar with strategic approaches to utilize residual surplus capacity even after all other options of matching demand and capacity have been exhausted.

Explain why designing an effective servicescape has to be done holistically and from the customers perspective.