So I'm struggling to solve a basic problem with some of the data I have and I can't seem to get round it. I have this data table

I can't for the life of me figure out how to convert this into a stacked bar chart that looks like this. I need the colours to represent the different Amino acids. Honestly I've been awake for 30 hours at this point so any help would be appreciated.

I've tried to convert to a long format however that still creates the same issue as before. When I use the default plot setting this is what I get

CodePudding user response：

For a stacked barplot via pandas, each of the columns will be converted to a layer of bars. The index of the dataframe will be used as the x-axis.

In the given dataframe, you seem to want the columns for the x-axis. Using .T to transpose the dataframe (exchanging rows and columns), will help. First, you'll need to set the amino acids as index.

import matplotlib.pyplot as plt
import pandas as pd

df = pd.read_html('https://stackoverflow.com/questions/71654486/stacked-bar-chart-with-multiple-variables-in-python')[0]

ax = df.set_index('Amino Acid').T.plot.bar(stacked=True, rot=0, cmap='tab20', figsize=(10, 7))
ax.legend(bbox_to_anchor=(1.01, 1.02), loc='upper left')
plt.tight_layout()
plt.show()