- Pandas
- Interesting Articles:
- Azure & KQL
- Azure Data Explorer
- Kusto Query Language (KQL) Reference Blogposts
- Microsoft Jupyter Notebooks
- Anaconda
- Conda Cheatsheet
- Jupyter Notebooks
- Better interactive Tables
- Dashboarding and Visualization
- Graph Analytics
- Constellation
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
- streamlit.io
- voila
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