Question
Python Programming Code - to find significant temperature change ein time series data. Steps to follow are below. Here are the required files https://drive.google.com/drive/folders/1Rck95WJsRzaMdSfB7OCFBR-VnufVHsB1?usp=sharing -
Python Programming Code - to find significant temperature change ein time series data. Steps to follow are below.
Here are the required files
https://drive.google.com/drive/folders/1Rck95WJsRzaMdSfB7OCFBR-VnufVHsB1?usp=sharing
- The zip file has xlsx and csv file. We should use csv formatted one. Note that csv file isnotcomma separated. It is semicolon separated instead.
- Open csv file in pandas and remove all columns except Date, Time, and T. T is for temperature in Celsius.
- Remove all rows with T < -5 or T>50. You will consider only temperatures between -5 and 50.
- Use simple linear regression analysis to find most extreme temperature changes (decrease and increase) during a 12-hr windows. Hint: You will search for the largest slope variable for the increase and smallest slope for the decrease. If you find same min/max slope for more than one 12-hr course, just use one of them to plot.
- Use matplotlib to show to your finding side by side. The resulting figure should be similar below figure (roughly). The data in below chart are just imaginary examples. Title of subplot should show starting date of the sample (date of first sample). The x-axis title should show regression line formula.
(do not copy from other sources)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started