Making a clustered bar chart, Pandas

Question

I have a little pandas dataframe that looks like this:

    Word   Percentage1  Percentage2
1   drink   18.166654   29.014272
2   cherry  13.498262   12.802642
3   berry   9.810123    6.775552
4   plum    7.964429    7.105845
5   crisp   7.892941    4.715009
...
50  spices  0.856775    1.663586

Words (50) and the two columns with figures corresponding to every one of them signifying the incidence of the word. How do I make a clustered chart to show the comparison of the two figures for each word? I have tried virtually every piece of code that was offered to other people on this site, I just don't understand how to group the two "Percentage" columns.

Answer 1

If I understand you correctly, you can do in this way:

df.plot(x="Word", y=["Percentage1", "Percentage2"], kind="bar")

Answer 2

try this,

df.set_index('Word').plot(kind='bar')

O/P

If you don't want to perform chart for all the values columns in df use this. Just setting index act as X and rest of all the columns act as y

Input:

     Word  Percentage1  Percentage2  Percentage3  Percentage4
0   drink    18.166654    29.014272     7.105845    29.014272
1  cherry    13.498262    12.802642     4.715009    12.802642
2   berry     9.810123     6.775552     6.097997     3.408988
3    plum     7.964429     7.105845    12.802642    19.620618
4   crisp     7.892941     4.715009     6.775552    35.832248

O/P