The Hunters Hut
The Hunters Hut

General Notes

Pandas

Interesting Articles:

  • SettingWithCopy Warning, the difference between view and copy, ways to fix the issue: https://www.dataquest.io/blog/settingwithcopywarning/

Azure & KQL

Azure Data Explorer

This is a great resource to query sample data online and test some KQL queries. It can be accessed via https://dataexplorer.azure.com/clusters/help/databases/Samples

Kusto Query Language (KQL) Reference Blogposts

  • Easy post on how to generate visualizations and some summary functions: https://squaredup.com/blog/aggregating-and-visualizing-data-with-kusto/

Microsoft Jupyter Notebooks

The open API supported by Azure Sentinel allows you to use Jupyter notebooks to query, transform, analyze and visualize Azure Sentinel data. This makes notebooks a powerful addition to Azure Sentinel and is especially well-suited to ad-hoc investigations, hunting or customized workflows.

https://github.com/Azure/Azure-Sentinel-Notebooks

Anaconda

Conda Cheatsheet

The Anaconda team put together a great summary of commands: https://docs.conda.io/projects/conda/en/4.6.0/_downloads/52a95608c49671267e40c689e0bc00ca/conda-cheatsheet.pdf

Jupyter Notebooks

Better interactive Tables

Dashboarding and Visualization

To QGRID tables don’t properly display in Voila unless a small patch is applied: https://github.com/voila-dashboards/voila/issues/72#issuecomment-696356918

Graph Analytics

Constellation

Constellation is free open source software for data visualisation & analytics. It is a graph focused visualisation and data analysis application enabling data access, federation and manipulation activities across large and complex datasets.

Constellation is a NetBeans Java application designed to run on MacOSX, Windows or Linux desktops. The software is suited to any network dataset with a rich feature dataset, including social network data, network infrastructure, chemical composition and many more.

  • Link: https://www.constellation-app.com