Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Next revision Both sides next revision | ||
facilities:slq_wiki:reporting [2021/01/20 16:17] pgullberg How it works |
facilities:slq_wiki:reporting [2021/01/20 16:22] pgullberg Table |
||
---|---|---|---|
Line 12: | Line 12: | ||
=== Step 0 – Converting the Apache log to a Dataframe | === Step 0 – Converting the Apache log to a Dataframe | ||
Converts log to Pandas Dataframe by specifying separating characters, filtering columns, creating table headers. In addition, converts the date and time into a workable format so that it is automatically recognised as a timestamp and can be filtered and sorted as needed using Pandas. | Converts log to Pandas Dataframe by specifying separating characters, filtering columns, creating table headers. In addition, converts the date and time into a workable format so that it is automatically recognised as a timestamp and can be filtered and sorted as needed using Pandas. | ||
+ | |||
+ | ^ TIME | Date and time of request (includes time zone by default) | ||
+ | ^ IP ADDRESS | ||
+ | ^ USERNAME | ||
+ | ^ REFERER | ||
+ | ^ REQUEST | ||
+ | ^ USER AGENT | Browser (and version), Operating system and hardware type used to send request | ||
=== Step 1 – Date masking | === Step 1 – Date masking |