Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next 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 [WikiRT - SLQ Wiki Reporting Tool] |
||
|---|---|---|---|
| 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 | ||
| Line 52: | Line 59: | ||
| ==== Development tools ==== | ==== Development tools ==== | ||
| - | |||
| - | Tools | ||
| This script/ | This script/ | ||
