[FIXED] Bar plot for multidimensional columns using pandas

Issue

I want to plot my dataframe (df) as a bar plot based on the time columns, where each bar represents the value counts() for each letter that appears in the column.

Expected output

.

date,00:00:00,01:00:00,02:00:00,03:00:00,04:00:00
2002-02-01,Y,Y,U,N,N
2002-02-02,U,N,N,N,N
2002-02-03,N,N,N,N,N
2002-02-04,N,N,N,N,N
2002-02-05,N,N,N,N,N

When I select individual time columns, I can do as below

import pandas as pd 
import numpy as np 
from datetime import datetime
import matplotlib.pyplot as plt

df = pd.read_csv('df.csv')
df = df['04:00:00'].value_counts()
df.plot(kind='bar')
plt.show()

How can I plot all the columns on the same bar plot as shown on the expected output.

Solution

One possible solution is:

pd.DataFrame({t: df[t].value_counts() for t in df.columns if t != "date"}).T.plot.bar()

Answered By - Davide_sd