This Jupyter/Kotlin notebook provides 100 examples of queries and functions using the Kotlin dataframe library.
It is a clone of "SQL for Data Scientists in 100 Queries" by Greg Wilson, with each example translated from SQL to use Kotlin dataframe API.
note: the original author has evolved his project... the version that was cloned to build this project can be found here
You can quickly browse or read this project's examples online via HTML, or download the .ipynb notebook and execute it yourself interactively. It should work in a traditional Jupyter setup (browser-based, launched via Python) or, directly in IntelliJ as a Kotlin notebook.
- traditional Jupyter: requires Kotlin kernel for Jupyter
- IntelliJ: requires Kotlin notebook plugin
Hope this is helpful!
if this is interesting/helpful, you might enjoy my KotlinConf 2023 Amsterdam presentation: Replacing SQL with Kotlin's 'dataframe' on the Las Vegas Strip
technical note: I initially experienced some compatibility issues in traditional Jupyter when utilizing the kandy plotting library -- the kernel is based on JVM language level 1.8 while kandy is on 11 -- I found a solution by adding the following line to %python_venv_root%/Lib/site-packages/run_kotlin_kernel/run_kernel.py , right above the subprocess.call line : jar_args.append('-jvmTarget=11')