# DataFrame ## Topics - [Home](https://kotlin.github.io/dataframe/home.html.md) - [API Reference](https://kotlin.github.io/dataframe/apireference.html.md): Browse the complete Kotlin DataFrame API reference documentation generated with Dokka across all modules. - [Guides And Examples](https://kotlin.github.io/dataframe/guides-and-examples.html.md): Browse a collection of guides and examples covering key features and real-world use cases of Kotlin DataFrame — from basics to advanced data analysis. - [Quickstart Guide](https://kotlin.github.io/dataframe/quickstart.html.md): Get started with Kotlin DataFrame in a few simple steps: load data, transform it, and visualize it — all in an interactive Kotlin Notebook. - [Kotlin DataFrame Features in Kotlin Notebook](https://kotlin.github.io/dataframe/kotlin-dataframe-features-in-kotlin-notebook.html.md): Discover how Kotlin DataFrame integrates with Kotlin Notebook for seamless interactive data analysis in IntelliJ IDEA. - [Troubleshooting](https://kotlin.github.io/dataframe/troubleshooting.html.md) - [Kotlin DataFrame for SQL & Backend Developers](https://kotlin.github.io/dataframe/guide-for-backend-sql-developers.html.md): Quickly transition from SQL to Kotlin DataFrame: load your datasets, perform essential transformations, and visualize your results — directly within a Kotlin Notebook. - [Setup Kotlin DataFrame](https://kotlin.github.io/dataframe/setup.html.md): Install Kotlin DataFrame in your preferred environment — Kotlin Notebook, Android, Jupyter, or Datalore — and start working with data right away. - [Setup Kotlin DataFrame in Gradle](https://kotlin.github.io/dataframe/setupgradle.html.md): Set up Kotlin DataFrame in your Gradle project, configure dependencies, and start using the API with full IDE support. - [Setup Kotlin DataFrame in Maven](https://kotlin.github.io/dataframe/setupmaven.html.md): Set up Kotlin DataFrame in your Maven project, configure dependencies, and start using the API with full IDE support. - [Setup Kotlin DataFrame on Android](https://kotlin.github.io/dataframe/setupandroid.html.md): Integrate Kotlin DataFrame into your Android app using the standard JVM dependency and simple Gradle configuration. - [Setup Kotlin DataFrame in Kotlin Toolchain](https://kotlin.github.io/dataframe/setupkotlintoolchain.html.md): Set up Kotlin DataFrame in your Kotlin Toolchain project, configure dependencies, and start using the API with full IDE support. - [Setup Kotlin DataFrame in Kotlin Notebook](https://kotlin.github.io/dataframe/setupkotlinnotebook.html.md): Use Kotlin DataFrame directly in Kotlin Notebook — write code, explore results, and refine your analysis step by step in a live environment. - [Setup Kotlin DataFrame in Jupyter](https://kotlin.github.io/dataframe/setupjupyter.html.md): Run Kotlin DataFrame inside Jupyter notebooks using the Kotlin Jupyter kernel — ideal for interactive data exploration and analysis. - [Setup Kotlin DataFrame on Datalore](https://kotlin.github.io/dataframe/setupdatalore.html.md): Set up Kotlin DataFrame on Datalore — a cloud-based platform with Kotlin notebook support for collaborative data analysis. - [Custom Gradle Configuration](https://kotlin.github.io/dataframe/setupcustomgradle.html.md): Add Kotlin DataFrame to your Gradle project and configure only the modules you need for data processing and IO. - [Modules](https://kotlin.github.io/dataframe/modules.html.md) - [Packaging into a fat JAR](https://kotlin.github.io/dataframe/packaging.html.md): Package Kotlin DataFrame into a fat or uber JAR without losing ServiceLoader providers from META-INF/services. - [Concepts And Principles](https://kotlin.github.io/dataframe/concepts.html.md): Learn what Kotlin DataFrame is about — its core concepts, design principles, and usage philosophy. - [Access APIs](https://kotlin.github.io/dataframe/apilevels.html.md) - [String API](https://kotlin.github.io/dataframe/stringapi.html.md): Work with columns in Kotlin DataFrame using simple string-based selectors. - [Data Abstractions](https://kotlin.github.io/dataframe/types.html.md) - [DataFrame](https://kotlin.github.io/dataframe/dataframe.html.md) - [DataColumn](https://kotlin.github.io/dataframe/datacolumn.html.md) - [DataRow](https://kotlin.github.io/dataframe/datarow.html.md) - [Hierarchical data structures](https://kotlin.github.io/dataframe/hierarchical.html.md) - [NaN and NA](https://kotlin.github.io/dataframe/nanandna.html.md) - [Number Unification](https://kotlin.github.io/dataframe/numberunification.html.md) - [Spelling Conventions](https://kotlin.github.io/dataframe/spellingconventions.html.md): Clarifies naming conventions used in Kotlin DataFrame documentation for the library, data format, and Kotlin type. - [Extension Properties API](https://kotlin.github.io/dataframe/extensionpropertiesapi.html.md) - [Data Schemas](https://kotlin.github.io/dataframe/schemas.html.md): Define, generate, and use typed data schemas in Kotlin DataFrame with `@DataSchema`, compiler plugin support, and extension property generation for safer dataframe operations. - [Data Schemas Generation From Existing DataFrame](https://kotlin.github.io/dataframe/dataschemagenerationmethods.html.md): Generate useful Kotlin definitions based on your DataFrame structure. - [Schema inheritance](https://kotlin.github.io/dataframe/schemasinheritance.html.md) - [Data Schemas in Kotlin Notebook](https://kotlin.github.io/dataframe/data-schemas-in-kotlin-notebook.html.md) - [Import Data Schemas, e.g. from OpenAPI, in Kotlin Notebook](https://kotlin.github.io/dataframe/schemasimportopenapijupyter.html.md) - [Data Schemas and Extension Properties Troubleshooting](https://kotlin.github.io/dataframe/data-schemas-and-extension-properties-troubleshooting.html.md) - [Gradle Plugin (deprecated)](https://kotlin.github.io/dataframe/gradle-plugin.html.md) - [Data Schemas in Gradle projects](https://kotlin.github.io/dataframe/schemasgradle.html.md) - [Import SQL Metadata as a Schema in Gradle Project](https://kotlin.github.io/dataframe/schemasimportsqlgradle.html.md) - [Import OpenAPI Schemas in Gradle project (Experimental)](https://kotlin.github.io/dataframe/schemasimportopenapigradle.html.md) - [Setup And Overview](https://kotlin.github.io/dataframe/compiler-plugin.html.md): Explore the Kotlin DataFrame Compiler Plugin — a powerful tool providing on-the-fly type-safe column-accessors for dataframes. - [Static Interpretation of DataFrame API](https://kotlin.github.io/dataframe/staticinterpretation.html.md) - [@DataSchema Declarations](https://kotlin.github.io/dataframe/dataschema.html.md) - [Compiler Plugin Examples](https://kotlin.github.io/dataframe/compilerpluginexamples.html.md) - [Known limitations and workarounds](https://kotlin.github.io/dataframe/compilerpluginlimitationsandworkarounds.html.md) - [Operations](https://kotlin.github.io/dataframe/operations.html.md): Explore the full range of operations for transforming and analyzing data with Kotlin DataFrame. - [Create](https://kotlin.github.io/dataframe/create.html.md) - [Create DataColumn](https://kotlin.github.io/dataframe/createcolumn.html.md) - [Create DataFrame](https://kotlin.github.io/dataframe/createdataframe.html.md) - [Input/output](https://kotlin.github.io/dataframe/io.html.md) - [Read](https://kotlin.github.io/dataframe/read.html.md): Learn how to load structured data into Kotlin DataFrame from CSV, JSON, Excel, SQL databases, and more. - [Read from SQL databases](https://kotlin.github.io/dataframe/readsqldatabases.html.md): Read data and infer schemas from SQL databases directly into Kotlin DataFrame, with support for PostgreSQL, MySQL, SQLite, and more. - [How to Extend DataFrame Library for Custom SQL Database Support: Example with HSQLDB](https://kotlin.github.io/dataframe/readsqlfromcustomdatabase.html.md) - [SQL to DataFrame column type mapping](https://kotlin.github.io/dataframe/readsqltypemapping.html.md): Overview of how SQL column types are mapped to Kotlin types when reading a DataFrame from each supported JDBC database. - [MariaDB type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-mariadb.html.md): Reference table of how each MariaDB column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [MySQL type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-mysql.html.md): Reference table of how each MySQL column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [PostgreSQL type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-postgresql.html.md): Reference table of how each PostgreSQL column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [MS SQL Server type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-mssql.html.md): Reference table of how each MS SQL Server column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [H2 type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-h2.html.md): Reference table of how each H2 column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [SQLite type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-sqlite.html.md): How SQLite's dynamic type system is mapped to Kotlin types when read into a Kotlin DataFrame, including the type-affinity rules DataFrame relies on. - [DuckDB type mapping](https://kotlin.github.io/dataframe/readsqltypemapping-duckdb.html.md): Reference table of how each DuckDB column type is mapped to a Kotlin type when read into a Kotlin DataFrame. - [Write](https://kotlin.github.io/dataframe/write.html.md) - [General info](https://kotlin.github.io/dataframe/info.html.md) - [columnsCount](https://kotlin.github.io/dataframe/columnscount.html.md) - [rowsCount](https://kotlin.github.io/dataframe/rowscount.html.md) - [isEmpty](https://kotlin.github.io/dataframe/isempty.html.md) - [countDistinct](https://kotlin.github.io/dataframe/countdistinct.html.md) - [columnNames](https://kotlin.github.io/dataframe/columnnames.html.md) - [columnTypes](https://kotlin.github.io/dataframe/columntypes.html.md) - [head](https://kotlin.github.io/dataframe/head.html.md) - [tail](https://kotlin.github.io/dataframe/tail.html.md): Discover `tail` operation in Kotlin DataFrame. - [schema](https://kotlin.github.io/dataframe/schema.html.md) - [describe](https://kotlin.github.io/dataframe/describe.html.md) - [Access Data](https://kotlin.github.io/dataframe/access.html.md) - [Indexing](https://kotlin.github.io/dataframe/indexing.html.md) - [Iterating](https://kotlin.github.io/dataframe/iterate.html.md) - [Get rows](https://kotlin.github.io/dataframe/getrow.html.md) - [rows](https://kotlin.github.io/dataframe/rows.html.md) - [single](https://kotlin.github.io/dataframe/single.html.md): Discover `single` operation in Kotlin DataFrame. - [first](https://kotlin.github.io/dataframe/first.html.md) - [last](https://kotlin.github.io/dataframe/last.html.md) - [minBy](https://kotlin.github.io/dataframe/minby.html.md) - [maxBy](https://kotlin.github.io/dataframe/maxby.html.md) - [asSequence](https://kotlin.github.io/dataframe/assequence.html.md): Discover `asSequence` operation in Kotlin DataFrame. - [Get columns](https://kotlin.github.io/dataframe/getcolumns.html.md) - [columns](https://kotlin.github.io/dataframe/columns.html.md) - [getColumn](https://kotlin.github.io/dataframe/getcolumn.html.md) - [values](https://kotlin.github.io/dataframe/values.html.md) - [Modify](https://kotlin.github.io/dataframe/modify.html.md) - [add](https://kotlin.github.io/dataframe/add.html.md) - [Adjust schema](https://kotlin.github.io/dataframe/adjustschema.html.md) - [append](https://kotlin.github.io/dataframe/append.html.md) - [cast](https://kotlin.github.io/dataframe/cast.html.md) - [concat](https://kotlin.github.io/dataframe/concat.html.md): Discover `concat` operation for Kotlin DataFrame. - [convert](https://kotlin.github.io/dataframe/convert.html.md) - [convertTo](https://kotlin.github.io/dataframe/convertto.html.md) - [distinct](https://kotlin.github.io/dataframe/distinct.html.md) - [drop / dropNulls / dropNaNs / dropNA](https://kotlin.github.io/dataframe/drop.html.md) - [duplicate](https://kotlin.github.io/dataframe/duplicate.html.md) - [explode](https://kotlin.github.io/dataframe/explode.html.md) - [fill](https://kotlin.github.io/dataframe/fill.html.md) - [filter](https://kotlin.github.io/dataframe/filter.html.md): Discover the `filter` operation for Kotlin DataFrame. - [flatten](https://kotlin.github.io/dataframe/flatten.html.md) - [gather](https://kotlin.github.io/dataframe/gather.html.md) - [group](https://kotlin.github.io/dataframe/group.html.md) - [groupBy](https://kotlin.github.io/dataframe/groupby.html.md) - [implode](https://kotlin.github.io/dataframe/implode.html.md) - [inferType](https://kotlin.github.io/dataframe/infertype.html.md) - [insert](https://kotlin.github.io/dataframe/insert.html.md) - [join](https://kotlin.github.io/dataframe/join.html.md) - [joinWith](https://kotlin.github.io/dataframe/joinwith.html.md) - [map](https://kotlin.github.io/dataframe/map.html.md) - [merge](https://kotlin.github.io/dataframe/merge.html.md) - [move](https://kotlin.github.io/dataframe/move.html.md) - [parse](https://kotlin.github.io/dataframe/parse.html.md) - [pivot](https://kotlin.github.io/dataframe/pivot.html.md) - [remove](https://kotlin.github.io/dataframe/remove.html.md) - [rename](https://kotlin.github.io/dataframe/rename.html.md) - [reorder](https://kotlin.github.io/dataframe/reorder.html.md) - [replace](https://kotlin.github.io/dataframe/replace.html.md) - [requireColumn](https://kotlin.github.io/dataframe/require.html.md) - [reverse](https://kotlin.github.io/dataframe/reverse.html.md) - [Select columns](https://kotlin.github.io/dataframe/select.html.md) - [Slice rows](https://kotlin.github.io/dataframe/slicerows.html.md) - [sortBy](https://kotlin.github.io/dataframe/sortby.html.md) - [split](https://kotlin.github.io/dataframe/split.html.md) - [toList](https://kotlin.github.io/dataframe/tolist.html.md) - [unfold](https://kotlin.github.io/dataframe/unfold.html.md) - [ungroup](https://kotlin.github.io/dataframe/ungroup.html.md) - [update](https://kotlin.github.io/dataframe/update.html.md) - [xs](https://kotlin.github.io/dataframe/xs.html.md) - [Add / map / remove columns](https://kotlin.github.io/dataframe/addremove.html.md) - [Slice rows](https://kotlin.github.io/dataframe/slicerows.html.md) - [Filter rows](https://kotlin.github.io/dataframe/filterrows.html.md) - [Reorder rows](https://kotlin.github.io/dataframe/reorderrows.html.md) - [GroupBy / concat rows](https://kotlin.github.io/dataframe/groupbyconcat.html.md) - [Update / convert values](https://kotlin.github.io/dataframe/updateconvert.html.md) - [Split / merge columns](https://kotlin.github.io/dataframe/splitmerge.html.md) - [Move / rename / reorder columns](https://kotlin.github.io/dataframe/moverename.html.md) - [Group / ungroup / flatten columns](https://kotlin.github.io/dataframe/groupungroupflatten.html.md) - [Insert / replace columns](https://kotlin.github.io/dataframe/insertreplace.html.md) - [Explode / implode columns](https://kotlin.github.io/dataframe/explodeimplode.html.md) - [Pivot / gather columns](https://kotlin.github.io/dataframe/pivotgather.html.md) - [Append / duplicate rows](https://kotlin.github.io/dataframe/appendduplicate.html.md) - [Summary statistics](https://kotlin.github.io/dataframe/summarystatistics.html.md) - [count](https://kotlin.github.io/dataframe/count.html.md) - [min / max](https://kotlin.github.io/dataframe/minmax.html.md) - [sum](https://kotlin.github.io/dataframe/sum.html.md) - [median](https://kotlin.github.io/dataframe/median.html.md) - [percentile](https://kotlin.github.io/dataframe/percentile.html.md) - [mean](https://kotlin.github.io/dataframe/mean.html.md) - [std](https://kotlin.github.io/dataframe/std.html.md) - [valueCounts](https://kotlin.github.io/dataframe/valuecounts.html.md) - [Cumulative statistics](https://kotlin.github.io/dataframe/cumulativestatistics.html.md) - [cumSum](https://kotlin.github.io/dataframe/cumsum.html.md) - [Statistical Relationship](https://kotlin.github.io/dataframe/statisticalrelationship.html.md) - [corr](https://kotlin.github.io/dataframe/corr.html.md) - [Row statistics](https://kotlin.github.io/dataframe/rowstats.html.md) - [Multiple DataFrames](https://kotlin.github.io/dataframe/multipledataframes.html.md) - [add](https://kotlin.github.io/dataframe/adddf.html.md) - [concat](https://kotlin.github.io/dataframe/concatdf.html.md): Discover the `concat` operation for Kotlin DataFrame. - [join](https://kotlin.github.io/dataframe/join.html.md) - [joinWith](https://kotlin.github.io/dataframe/joinwith.html.md) - [Column Operations](https://kotlin.github.io/dataframe/columnoperations.html.md) - [Column arithmetics](https://kotlin.github.io/dataframe/columnarithmetics.html.md) - [Column statistics](https://kotlin.github.io/dataframe/columnstatistics.html.md) - [asIterable](https://kotlin.github.io/dataframe/asiterable.html.md): Discover `asIterable` operation in Kotlin DataFrame. - [asSequence](https://kotlin.github.io/dataframe/assequencecolumn.html.md): Discover `asSequence` operation in Kotlin DataFrame. - [between](https://kotlin.github.io/dataframe/between.html.md): Return a Boolean DataColumn indicating whether each value lies between two bounds. - [first](https://kotlin.github.io/dataframe/firstoncolumn.html.md): Discover `first` operation in Kotlin DataFrame. - [last](https://kotlin.github.io/dataframe/lastoncolumn.html.md): Discover `last` operation in Kotlin DataFrame. - [single](https://kotlin.github.io/dataframe/singleoncolumn.html.md): Discover `single` operation in Kotlin DataFrame. - [Column selectors](https://kotlin.github.io/dataframe/columnselectors.html.md) - [Utility functions](https://kotlin.github.io/dataframe/utils.html.md): Overview of common utility operations in Kotlin DataFrame. - [any](https://kotlin.github.io/dataframe/any.html.md): Discover `any` operation in Kotlin DataFrame. - [all](https://kotlin.github.io/dataframe/all.html.md): Discover `all` operation in Kotlin DataFrame. - [none](https://kotlin.github.io/dataframe/none.html.md): Discover `none` operation in Kotlin DataFrame. - [chunked](https://kotlin.github.io/dataframe/chunked.html.md): Discover `chunked` operation in Kotlin DataFrame. - [shuffle](https://kotlin.github.io/dataframe/shuffle.html.md): Discover `shuffle` operation in Kotlin DataFrame. - [Interop with Collections](https://kotlin.github.io/dataframe/collectionsinterop.html.md) - [toList](https://kotlin.github.io/dataframe/tolist.html.md) - [toMap](https://kotlin.github.io/dataframe/tomap.html.md) - [associate](https://kotlin.github.io/dataframe/associate.html.md): Discover `associate` operation for Kotlin DataFrame. - [associateBy](https://kotlin.github.io/dataframe/associateby.html.md): Discover `associateBy` operation for Kotlin DataFrame. - [Rendering](https://kotlin.github.io/dataframe/rendering.html.md) - [toHtml](https://kotlin.github.io/dataframe/tohtml.html.md) - [format](https://kotlin.github.io/dataframe/format.html.md): DataFrame Format Operation: Apply CSS formatting for rendering a dataframe to HTML. - [Jupyter Notebooks](https://kotlin.github.io/dataframe/jupyterrendering.html.md) - [Data Sources](https://kotlin.github.io/dataframe/data-sources.html.md): Discover all the data formats Kotlin DataFrame can work with — including JSON, CSV, Excel, SQL databases, and more. - [JSON](https://kotlin.github.io/dataframe/json.html.md): Support for working with JSON data — load, explore, and save structured JSON using Kotlin DataFrame. - [OpenAPI](https://kotlin.github.io/dataframe/openapi.html.md): Work with JSON data based on OpenAPI 3.0 schemas using Kotlin DataFrame — helpful for consuming structured API responses. - [CSV / TSV](https://kotlin.github.io/dataframe/csv-tsv.html.md): Work with CSV and TSV files — read, analyze, and export tabular data using Kotlin DataFrame. - [Excel](https://kotlin.github.io/dataframe/excel.html.md): Read from and write to Excel files in `.xls` or `.xlsx` formats with Kotlin DataFrame for seamless spreadsheet integration. - [Apache Arrow](https://kotlin.github.io/dataframe/apachearrow.html.md): Read and write Apache Arrow files in Kotlin — efficient binary format support with Kotlin DataFrame. - [Parquet](https://kotlin.github.io/dataframe/parquet.html.md): Read Parquet files via Apache Arrow in Kotlin DataFrame — high‑performance columnar storage for analytics. - [SQL](https://kotlin.github.io/dataframe/sql.html.md): Work with SQL databases in Kotlin using DataFrame and JDBC — read tables and queries with ease. - [PostgreSQL](https://kotlin.github.io/dataframe/postgresql.html.md): Work with PostgreSQL databases in Kotlin — read tables and queries into DataFrames using JDBC. - [MySQL](https://kotlin.github.io/dataframe/mysql.html.md): Connect to MySQL databases and load data into Kotlin DataFrame using JDBC — query, analyze, and transform SQL data in Kotlin. - [Microsoft SQL Server (MS SQL)](https://kotlin.github.io/dataframe/microsoft-sql-server.html.md): Connect to Microsoft SQL Server using Kotlin DataFrame and JDBC — load structured data directly into your Kotlin workflow. - [SQLite](https://kotlin.github.io/dataframe/sqlite.html.md): Use Kotlin DataFrame to read data from SQLite databases with minimal setup via JDBC. - [H2](https://kotlin.github.io/dataframe/h2.html.md): Use Kotlin DataFrame to query H2 databases via JDBC — read tables, run SQL queries, or fetch result sets directly. - [MariaDB](https://kotlin.github.io/dataframe/mariadb.html.md): Access MariaDB databases using Kotlin DataFrame and JDBC — fetch data from tables or custom SQL queries with ease. - [DuckDB](https://kotlin.github.io/dataframe/duckdb.html.md): Work with DuckDB databases in Kotlin — read tables and queries into DataFrames using JDBC. - [Custom SQL Source](https://kotlin.github.io/dataframe/custom-sql-source.html.md): Connect Kotlin DataFrame to any JDBC-compatible database using a custom SQL source configuration. - [Custom integrations with unsupported data sources](https://kotlin.github.io/dataframe/integrations.html.md): Examples of how to integrate Kotlin DataFrame with other data frameworks like Exposed, Spark, or Multik. - [Support](https://kotlin.github.io/dataframe/support.html.md) - [Frequently Asked Questions](https://kotlin.github.io/dataframe/faq.html.md) - [Migration to 1.0](https://kotlin.github.io/dataframe/migrationto-1-0.html.md) - [Migration from Gradle/KSP Plugin](https://kotlin.github.io/dataframe/migration-from-plugins.html.md)