Skip to content

Instantly share code, notes, and snippets.

@DerekHawkins

DerekHawkins/log_file_analysis_5.py

Created July 28, 2021 18:12
Show Gist options
  • Save DerekHawkins/31be16bf1e5f6aa788876514d0d44b07 to your computer and use it in GitHub Desktop.
Save DerekHawkins/31be16bf1e5f6aa788876514d0d44b07 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
log_file_analysis_5.py
pivot = log_file.pivot_table(index='request_type', values='server_response',
aggfunc={'server_response':'count'})\
.sort_values(by='server_response', ascending=False).reset_index().\
rename(columns={'request_type':'file_name', 'server_response':'number_of_pings'})
fig = go.Figure(data=[go.Table(
header=dict(values=list(pivot.columns),
fill_color='blue',
font=dict(color='white', size=12),
align='left'),
cells=dict(values=[pivot.file_name,pivot.number_of_pings],
fill_color='lavender',
align='left'))
])
fig.show()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment