Tried plotting yfinance data by framing into pandas with the help of seaborn and matplotlib. Shows error no matter what. How to fix this?
python
Ethan Jacksonimport yfinance as yf
import matplotlib.pyplot as plt
import seaborn as sns
import pandas as pd
df = yf.download('AAPL',start="2021-01-01",end='2025-07-13')
print(df.head()) #display the first five rows of the dataframe
print(df) #to display hte entire dataframe
print(df['Low']) #to select a particular column
print(df.head(122)) #to select a range of rows
print ( " TO CATEGORISE DATA ")
print(df[df['High']>150]) #to categorise data
df['Daily Return'] = df['Close'].pct_change() #to add new column
print(df.head())
print(df.columns) #printing the headers of the columns
df= df.reset_index()
print(df.head())
print(df.columns)
#creating a line plot of 'Close' w.r.t data
print("\nType of 'Date' column:", type(df['Date']))
print("Type of 'Close' column:", type(df['Close']))
sns.lineplot(x='Date',y='Close',data=df)
#df=pd.DataFrame(df)
#df['Close'].plot(kind='line',x='Date',y='Close',title="Representatiion of Close w.r.t. Date")
plt.show()
The problem is with the last few lines of the code. I was expecting a line plot but error it is. How to fix this?
Answer
Your error was caused by the following code
sns.lineplot(x='Date',y='Close',data=df)
This is because df is multi-indexed. Use the following code instead of the above code
sns.lineplot(data=df.droplevel(1, axis=1), x='Date', y='Close')
