Median prices
There are times when the median is a better tool than the mean. Lets imagine that you are analyzing the stock data in the DataFrame prices again. You want to know if the stock's price is trending down by comparing the opening and closing prices. Remember the DataFrame has the columns OPEN, HI, LOW, and CLOSE.
Cet exercice fait partie du cours
Intermediate Python for Finance
Instructions
- Calculate the median of the opening prices.
- Calculate the median of the closing prices.
- Compare the opening and closing medians to get the trend.
Exercice interactif pratique
Essayez cet exercice en complétant cet exemple de code.
# Get the median of the opening prices
med_open = ____.loc[:, '____'].____()
# Get the median of the closing prices
med_close = ____.____[:, '____'].____()
if ____ > ____:
print("Trending down.")