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.
Este exercício faz parte do curso
Intermediate Python for Finance
Instruções do exercício
- Calculate the median of the opening prices.
- Calculate the median of the closing prices.
- Compare the opening and closing medians to get the trend.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
# Get the median of the opening prices
med_open = ____.loc[:, '____'].____()
# Get the median of the closing prices
med_close = ____.____[:, '____'].____()
if ____ > ____:
print("Trending down.")