PythonDataScienceHandbook VS OSQuery

Python Data Science Handbook

Python Data Science Handbook — learn to use Python libraries such as NumPy, Pandas, Matplotlib, Scikit-Learn, and related tools to effectively store, manipulate, and gain insight from data

I don't know what tools you will be using but if you will be using Python you can start with Python Data Science Handbook by Jake VanderPlas and Data Science & Big Data Analytics: Discovering, Analyzing, Visualizing and Presenting DataData Science & Big Data Analytics: Discovering, Analyzing, Visualizing and Presenting Data which gives a very good outlook on the data science and big data frame work. PS: Jake's book is also available as jupyter notebooks so you can read and run the code at the same time.

Python Data Science Handbook by Jake VanderPlas (https://jakevdp.github.io/PythonDataScienceHandbook/)

Otherwise you can work through courses on Datacamp, Coursera, Udemy, etc, or check out this book for a more general non-spatial perspective.

7. Data Science Handbook Are you looking for a comprehensive guide to data science with Python? Look no further than the Data Science Handbook by Jake VanderPlas. This repository contains the entire book, which introduces essential tools and techniques used in data science, including IPython, NumPy, Pandas, Matplotlib, and Scikit-Learn. It’s a fantastic resource for anyone looking to deepen their understanding of data science concepts and best practices.

I can recommend https://jakevdp.github.io/PythonDataScienceHandbook/

Perhaps the OP means OsQuery: https://github.com/osquery/osquery

OsQuery is an SQLite extension consisting of hundreds of virtual tables

There's at least one open data quality issue for `process_open_sockets` on macOS[1]. It's a few years old however and, if you aren't seeing that casting error, you probably aren't hitting it. But that's a good example of the kind of debt that's been built up over time.

(In terms of general purpose/flexible tooling, I'm not aware of a close replacement for osquery.)

[1]: https://github.com/osquery/osquery/issues/6319

The largest we have successfully deployed is on the OSQuery schema https://osquery.io/ which is 277 tables and lots of business context (malwares, vulnerabilities, Windows registry keys, etc).

From a self hosted standpoint OSQuery or Wazuh are your best bets for monitoring USB devices. Windows makes blocking really challenging and I’m not aware of any “free” solutions that attempt it.

Configure auditd to monitor host activity: https://izyknows.medium.com/linux-auditd-for-threat-detection-d06c8b941505 or osquery: https://osquery.io/ (or similar software: filebeat for example).

OS Query : Easily ask questions about your Linux, Windows, and macOS infrastructure

Osquery + Fleet. https://osquery.io/ https://fleetdm.com/, using the two allows you to build a query to answer what ever questions you (or an auditor) might have about your environment.