Get number of fails and successes from a dataframe in time series

Question

With a dataFrame like this:

Time                    Status      ResponseTime     PID
2016-07-13 17:33:49     OK          1623             42
2016-07-13 17:33:50     KO          1593             35
2016-07-13 17:33:50     OK          1604             19
2016-07-13 17:33:51     KO          1605             28
2016-07-13 17:33:51     OK          1617             42
2016-07-13 17:33:52     OK          1654             35
2016-07-13 17:33:52     OK          2044             19
2016-07-13 17:33:53     KO          1630             42

How can I draw a kind of a histogram which would present number of KOs and OKs for each minute?

piRSquared · Accepted Answer · 2016-07-13T20:06:03.053

text = """Time                    Status      ResponseTime     PID
2016-07-13 17:33:49     OK          1623             42
2016-07-13 17:33:50     KO          1593             35
2016-07-13 17:33:50     OK          1604             19
2016-07-13 17:33:51     KO          1605             28
2016-07-13 17:33:51     OK          1617             42
2016-07-13 17:33:52     OK          1654             35
2016-07-13 17:33:52     OK          2044             19
2016-07-13 17:33:53     KO          1630             42
2016-07-13 17:34:49     OK          1623             42
2016-07-13 17:34:50     KO          1593             35
2016-07-13 17:34:50     OK          1604             19
2016-07-13 17:34:51     KO          1605             28
2016-07-13 17:34:51     OK          1617             42
2016-07-13 17:34:52     OK          1654             35
2016-07-13 17:34:52     OK          2044             19
2016-07-13 17:34:53     KO          1630             42
"""

df = pd.read_csv(StringIO(text), sep='\s{2,}', engine='python', index_col=0, parse_dates=[0])

df1 = df.groupby(pd.TimeGrouper('Min')).Status.value_counts().unstack()
df1

df1.plot.bar()

If you want to limit to 'KO':

df1.KO.plot.bar()

And one more question, how to format Time axis to show only hour and minute? — Snorlax, Jul 13 '16 at 20:13
@kulawyjoe simple way is to `df1.index = df1.index.strftime('%H:%M')`. Then run plots. — piRSquared, Jul 13 '16 at 20:18
@kulawyjoe a better answer is found here --- > http://stackoverflow.com/a/14946444/2336654 — piRSquared, Jul 13 '16 at 20:19

Get number of fails and successes from a dataframe in time series

1 Answers1