Pandas: Create a horizontal stacked bar plot of one column versus other columns
6. Horizontal Stacked Bar Plot of Opening and Closing Prices
Write a Pandas program to create a horizontal stacked bar plot of opening, closing stock prices of Alphabet Inc. between two specific dates.
Use the alphabet_stock_data.csv file to extract data.
alphabet_stock_data:
alphabet_stock_data Table
Date | Open | High | Low | Close | Adj Close | Volume |
---|---|---|---|---|---|---|
2020-04-01 | 1122 | 1129.689941 | 1097.449951 | 1105.619995 | 1105.619995 | 2343100 |
2020-04-02 | 1098.26001 | 1126.859985 | 1096.400024 | 1120.839966 | 1120.839966 | 1964900 |
2020-04-03 | 1119.015015 | 1123.540039 | 1079.810059 | 1097.880005 | 1097.880005 | 2313400 |
2020-04-06 | 1138 | 1194.660034 | 1130.939941 | 1186.920044 | 1186.920044 | 2664700 |
... | ... | ... | ... | ... | ... | ... |
... | ... | ... | ... | ... | ... | ... |
2020-09-29 | 1470.390015 | 1476.662964 | 1458.805054 | 1469.329956 | 1469.329956 | 978200 |
2020-09-30 | 1466.800049 | 1489.75 | 1459.880005 | 1469.599976 | 1469.599976 | 1700600 |
Sample Solution:
Python Code :
import pandas as pd
import matplotlib.pyplot as plt
df = pd.read_csv("alphabet_stock_data.csv")
start_date = pd.to_datetime('2020-4-1')
end_date = pd.to_datetime('2020-4-30')
df['Date'] = pd.to_datetime(df['Date'])
new_df = (df['Date']>= start_date) & (df['Date']<= end_date)
df1 = df.loc[new_df]
df2 = df1[['Date', 'Open', 'Close']]
df3 = df2.set_index('Date')
plt.figure(figsize=(20,20))
df3.plot.barh(stacked=True)
plt.suptitle('Opening/Closing stock prices Alphabet Inc.,\n01-04-2020 to 30-04-2020', fontsize=12, color='black')
plt.show()
Sample Output:
Click for download alphabet_stock_data.csv
For more Practice: Solve these Related Problems:
- Write a Pandas program to create a horizontal stacked bar plot showing the opening and closing prices of Alphabet Inc. over a selected period.
- Write a Pandas program to generate a horizontal stacked bar chart where each bar represents a day split between open and close prices.
- Write a Pandas program to produce a horizontal stacked bar plot with custom color mapping for open and close price segments.
- Write a Pandas program to plot a horizontal stacked bar chart that visually compares the proportions of opening versus closing prices daily.
Python Code Editor:
Have another way to solve this solution? Contribute your code (and comments) through Disqus.
Previous: Write a Pandas program to create a stacked bar plot of opening, closing stock prices of Alphabet Inc. between two specific dates.
Next: Write a Pandas program to create a histograms plot of opening, closing, high, low stock prices of Alphabet Inc. between two specific dates.
What is the difficulty level of this exercise?
Test your Programming skills with w3resource's quiz.