I have server logs for each user which is in the following format:

I have separate logs for each user, so all events are conducted by one user. The example above is not inclusive of all columns and this is formatted/cleaned up data. The events are not of interest, what I am trying to plot is the activity of the user X on a given day by the hour, i.e.

A chart (x-axis: dates, y-axis: 24 hour) showing user X had 2 activities between 1-2 PM.

Any help is appreciated.

CodePudding user response：

You might want to use