Compute the average daily and annual efficiencies

Assignment Help Python Programming

Reference no: EM132852264

Expected materials to be submitted by the candidate.

1 Jupyter notebook with clear notes within the code detailing all the important steps. We recommend use of Anaconda (Python 3.7 version).
2 The candidate will be expected to do a 15min presentation on the submitted code.

Question 1

The Weather Station Efficiency 2020 file is an excel workbook with 12 sheets (from Jan 2020 - Dec 2020). Each sheet has got monthlydata onEfficiency of the weather station. Every day,Meteorologists record the efficiency of the Weather stations and send this data to the Analyst. The Analyst is expected to analyse the dataand to draw some insights on the total running time, reliability and the Mean Time between Failures (MTBF) of the weather stations.

1a. Your task as the analyst is write a code usingJupyter Notebook that reads the Weather Stations Efficiency 2020 file and compile the annual data into one sheet. Refer to example as shown in Figure 1 below.

(NB:The number of Weather Stations per month is not fixed, new weather stations can be deployed and some existing stations can be decommissioned.)

Figure 1 - Example of daily Weather station efficiencies in one sheet.

1b. Compute the average daily and annual efficiencies for all Weather Stations for Drought and Rainfall status. Plot the daily and Annual Efficiencies on a graph or graphs of your choice to bring out important insights.

Attachment:- Analyst Practical Questions.rar

Reference no: EM132852264

Questions Cloud

What is the probability of selecting someone at random : a. What is the probability of selecting someone at random from this population who has a cholesterol value:

Hacker attack-e-commerce nightmare : A Hacker Attack: An Ecommerce Nightmare. When referencing any outside sources, ensure you properly cite in the body of the text.

What the gains or loss on the conversion of the bonds : The prevailing rate of interest of the bonds is 11%. What the gains (or loss) on the conversion of the bonds on December 31, 2018

Does revising the warranty estimate pose an ethical dilemma : Does revising the warranty estimate pose an ethical dilemma? Should Chase follow his boss's suggestion? Why or why not

Compute the average daily and annual efficiencies : Compute the average daily and annual efficiencies for all Weather Stations for Drought and Rainfall status. Plot the daily and Annual Efficiencies on a graph

Explain the importance to investors and stockholders : Explain the importance to investors and stockholders (owners) of the notes to the financial statements

Confidence interval for the mean compensation : Assuming that the conditions for constructing a confidence interval for the mean compensation are satisfied, construct and interpret a 95% confidence interval f

Explain whether the audit team should continue to tender : Explain whether the audit team should continue to tender for the audit work of Harris Ltd. References are required

Leveraged cloud computing technologies : Select an organization that has leveraged Cloud Computing technologies in an attempt to improve profitability or to give them a competitive advantage.

User Account

All Pages