df-research/dataframe/docs/StardustDocs/topics/guides/Guides-And-Examples.md

Guides And Examples

Browse a collection of guides and examples covering key features and real-world use cases of Kotlin DataFrame — from basics to advanced data analysis. Explore Kotlin DataFrame with detailed user guides and real-world examples, showcasing practical use cases and data workflows. A curated list of Kotlin DataFrame guides and examples that walk you through common operations and data analysis patterns step by step.

Guides

Explore our structured, in-depth guides to steadily improve your Kotlin DataFrame skills — step by step.

• — get started with Kotlin DataFrame in a few simple steps: load data, transform it, and visualize it.

• — migration guide for backend developers with SQL/ORM experience moving to Kotlin DataFrame

• — learn about extension properties for DataFrame and make working with your data both convenient and type-safe.

• Enhanced Column Selection DSL — explore powerful DSL for typesafe and flexible column selection in Kotlin DataFrame.

• — discover interactive Kotlin DataFrame outputs in Kotlin Notebook.

• 40 Puzzles — inspired by 100 pandas puzzles. An interactive guide that takes you from simple tasks to complex challenges, teaching you how to solve them using Kotlin DataFrame in a concise and elegant style.
• Reading from files: CSV, JSON, ApacheArrow — read your data from various formats into DataFrame.
• SQL Databases Interaction — set up SQL database access and read query results efficiently into DataFrame.
• Custom SQL Database Support — extend DataFrame library for custom SQL database support.
• GeoDataFrame Guide — explore the GeoDataFrame module that brings a convenient Kotlin DataFrame API to geospatial workflows, enhanced with beautiful Kandy-Geo visualizations (experimental).

• Using Unsupported Data Sources: — A guide by examples. While these might one day become proper integrations of DataFrame, for now, we provide them as examples for how to make such integrations yourself.
  • Apache Spark Interop (With and Without Kotlin Spark API)
  • Multik Interop
  • JetBrains Exposed Interop
  • Hibernate ORM
• OpenAPI Guide — learn how to parse and explore OpenAPI JSON structures using Kotlin DataFrame, enabling structured access and intuitive analysis of complex API schemas (experimental, supports OpenAPI 3.0.0).

Examples

Explore our extensive collection of practical examples and real-world analytics workflows.

• Kotlin DataFrame Compiler Plugin Gradle Example
  — a simple Gradle project demonstrating the usage of the compiler plugin,
  showcasing DataFrame expressions with extension properties
  that are generated on-the-fly in the IDEA project.

• Kotlin DataFrame Compiler Plugin Maven Example
  — a simple Maven project demonstrating the usage of the compiler plugin,
  showcasing DataFrame expressions with extension properties
  that are generated on-the-fly in the IDEA project.

• Titanic Example — discover the famous "Titanic" dataset with the Kotlin DataFrame analysis toolkit and Kandy visualizations.

• Track and Analyze GitHub Star Growth — query GitHub’s API with the Kotlin Notebook Ktor client, then analyze and visualize the data using Kotlin DataFrame and Kandy.

• GitHub Example — a practical example of working with deeply nested, hierarchical DataFrames using GitHub data.

• Netflix Example — explore TV shows and movies from Netflix with the powerful Kotlin DataFrame API and beautiful Kandy visualizations.

• Top-12 German Companies Financial Analyze — analyze key financial metrics for several major German companies.

• Movies Example — basic Kotlin DataFrame operations on data from movielens.

• YouTube Example — explore YouTube videos with YouTube REST API and Kotlin DataFrame.

• IMDb SQL Database Example — analyze IMDb data stored in MariaDB using Kotlin DataFrame and visualize with Kandy.

• Reading Parquet files from Apache Spark — this project showcases how to export data and ML models from Apache Spark via reading from Parquet files. Also, Kandy used to visualize the exported data and Linear Regression model.

See also Kandy User Guides and Examples Gallery for the best data visualizations using Kotlin DataFrame and Kandy together!