# Kotlin DataFrame Documentation

Kotlin DataFrame is a typesafe DSL for structured data processing in Kotlin.
This index provides links to individual topics in a format optimized for LLMs.

- [Full Content](https://kotlin.github.io/dataframe/llms-full.txt)

- [Access Data](https://kotlin.github.io/dataframe/_llms/access.txt)
- [add](https://kotlin.github.io/dataframe/_llms/add.txt)
- [add](https://kotlin.github.io/dataframe/_llms/adddf.txt)
- [Add / map / remove columns](https://kotlin.github.io/dataframe/_llms/addremove.txt)
- [Adjust schema](https://kotlin.github.io/dataframe/_llms/adjustschema.txt)
- [all](https://kotlin.github.io/dataframe/_llms/all.txt)
- [any](https://kotlin.github.io/dataframe/_llms/any.txt)
- [Apache Arrow](https://kotlin.github.io/dataframe/_llms/apachearrow.txt)
- [Access APIs](https://kotlin.github.io/dataframe/_llms/apilevels.txt)
- [append](https://kotlin.github.io/dataframe/_llms/append.txt)
- [Append / duplicate rows](https://kotlin.github.io/dataframe/_llms/appendduplicate.txt)
- [asIterable](https://kotlin.github.io/dataframe/_llms/asiterable.txt)
- [asSequence](https://kotlin.github.io/dataframe/_llms/assequence.txt)
- [asSequence](https://kotlin.github.io/dataframe/_llms/assequencecolumn.txt)
- [associate](https://kotlin.github.io/dataframe/_llms/associate.txt)
- [associateBy](https://kotlin.github.io/dataframe/_llms/associateby.txt)
- [between](https://kotlin.github.io/dataframe/_llms/between.txt)
- [cast](https://kotlin.github.io/dataframe/_llms/cast.txt)
- [chunked](https://kotlin.github.io/dataframe/_llms/chunked.txt)
- [Interop with Collections](https://kotlin.github.io/dataframe/_llms/collectionsinterop.txt)
- [Column arithmetics](https://kotlin.github.io/dataframe/_llms/columnarithmetics.txt)
- [columnNames](https://kotlin.github.io/dataframe/_llms/columnnames.txt)
- [Column Operations](https://kotlin.github.io/dataframe/_llms/columnoperations.txt)
- [columns](https://kotlin.github.io/dataframe/_llms/columns.txt)
- [columnsCount](https://kotlin.github.io/dataframe/_llms/columnscount.txt)
- [Column selectors](https://kotlin.github.io/dataframe/_llms/columnselectors.txt)
- [Column statistics](https://kotlin.github.io/dataframe/_llms/columnstatistics.txt)
- [columnTypes](https://kotlin.github.io/dataframe/_llms/columntypes.txt)
- [Setup And Overview](https://kotlin.github.io/dataframe/_llms/compiler-plugin.txt)
- [Compiler Plugin Examples](https://kotlin.github.io/dataframe/_llms/compilerpluginexamples.txt)
- [Known limitations and workarounds](https://kotlin.github.io/dataframe/_llms/compilerpluginlimitationsandworkarounds.txt)
- [concat](https://kotlin.github.io/dataframe/_llms/concat.txt)
- [concat](https://kotlin.github.io/dataframe/_llms/concatdf.txt)
- [Concepts And Principles](https://kotlin.github.io/dataframe/_llms/concepts.txt)
- [convert](https://kotlin.github.io/dataframe/_llms/convert.txt)
- [convertTo](https://kotlin.github.io/dataframe/_llms/convertto.txt)
- [corr](https://kotlin.github.io/dataframe/_llms/corr.txt)
- [count](https://kotlin.github.io/dataframe/_llms/count.txt)
- [countDistinct](https://kotlin.github.io/dataframe/_llms/countdistinct.txt)
- [Create](https://kotlin.github.io/dataframe/_llms/create.txt)
- [Create DataColumn](https://kotlin.github.io/dataframe/_llms/createcolumn.txt)
- [Create DataFrame](https://kotlin.github.io/dataframe/_llms/createdataframe.txt)
- [CSV / TSV](https://kotlin.github.io/dataframe/_llms/csv-tsv.txt)
- [cumSum](https://kotlin.github.io/dataframe/_llms/cumsum.txt)
- [Cumulative statistics](https://kotlin.github.io/dataframe/_llms/cumulativestatistics.txt)
- [Custom SQL Source](https://kotlin.github.io/dataframe/_llms/custom-sql-source.txt)
- [Data Schemas and Extension Properties Troubleshooting](https://kotlin.github.io/dataframe/_llms/data-schemas-and-extension-properties-troubleshooting.txt)
- [Data Schemas in Kotlin Notebook](https://kotlin.github.io/dataframe/_llms/data-schemas-in-kotlin-notebook.txt)
- [Data Sources](https://kotlin.github.io/dataframe/_llms/data-sources.txt)
- [DataColumn](https://kotlin.github.io/dataframe/_llms/datacolumn.txt)
- [DataFrame](https://kotlin.github.io/dataframe/_llms/dataframe.txt)
- [DataRow](https://kotlin.github.io/dataframe/_llms/datarow.txt)
- [@DataSchema Declarations](https://kotlin.github.io/dataframe/_llms/dataschema.txt)
- [Data Schemas Generation From Existing DataFrame](https://kotlin.github.io/dataframe/_llms/dataschemagenerationmethods.txt)
- [describe](https://kotlin.github.io/dataframe/_llms/describe.txt)
- [distinct](https://kotlin.github.io/dataframe/_llms/distinct.txt)
- [drop / dropNulls / dropNaNs / dropNA](https://kotlin.github.io/dataframe/_llms/drop.txt)
- [DuckDB](https://kotlin.github.io/dataframe/_llms/duckdb.txt)
- [duplicate](https://kotlin.github.io/dataframe/_llms/duplicate.txt)
- [Excel](https://kotlin.github.io/dataframe/_llms/excel.txt)
- [explode](https://kotlin.github.io/dataframe/_llms/explode.txt)
- [Explode / implode columns](https://kotlin.github.io/dataframe/_llms/explodeimplode.txt)
- [Extension Properties API](https://kotlin.github.io/dataframe/_llms/extensionpropertiesapi.txt)
- [Frequently Asked Questions](https://kotlin.github.io/dataframe/_llms/faq.txt)
- [fill](https://kotlin.github.io/dataframe/_llms/fill.txt)
- [filter](https://kotlin.github.io/dataframe/_llms/filter.txt)
- [Filter rows](https://kotlin.github.io/dataframe/_llms/filterrows.txt)
- [first](https://kotlin.github.io/dataframe/_llms/first.txt)
- [first](https://kotlin.github.io/dataframe/_llms/firstoncolumn.txt)
- [flatten](https://kotlin.github.io/dataframe/_llms/flatten.txt)
- [format](https://kotlin.github.io/dataframe/_llms/format.txt)
- [gather](https://kotlin.github.io/dataframe/_llms/gather.txt)
- [getColumn](https://kotlin.github.io/dataframe/_llms/getcolumn.txt)
- [Get columns](https://kotlin.github.io/dataframe/_llms/getcolumns.txt)
- [Get rows](https://kotlin.github.io/dataframe/_llms/getrow.txt)
- [Gradle Plugin (deprecated)](https://kotlin.github.io/dataframe/_llms/gradle-plugin.txt)
- [group](https://kotlin.github.io/dataframe/_llms/group.txt)
- [groupBy](https://kotlin.github.io/dataframe/_llms/groupby.txt)
- [GroupBy / concat rows](https://kotlin.github.io/dataframe/_llms/groupbyconcat.txt)
- [Group / ungroup / flatten columns](https://kotlin.github.io/dataframe/_llms/groupungroupflatten.txt)
- [Kotlin DataFrame for SQL & Backend Developers](https://kotlin.github.io/dataframe/_llms/guide-for-backend-sql-developers.txt)
- [Guides And Examples](https://kotlin.github.io/dataframe/_llms/guides-and-examples.txt)
- [H2](https://kotlin.github.io/dataframe/_llms/h2.txt)
- [head](https://kotlin.github.io/dataframe/_llms/head.txt)
- [Hierarchical data structures](https://kotlin.github.io/dataframe/_llms/hierarchical.txt)
- [Home](https://kotlin.github.io/dataframe/_llms/home.txt)
- [implode](https://kotlin.github.io/dataframe/_llms/implode.txt)
- [Indexing](https://kotlin.github.io/dataframe/_llms/indexing.txt)
- [inferType](https://kotlin.github.io/dataframe/_llms/infertype.txt)
- [General info](https://kotlin.github.io/dataframe/_llms/info.txt)
- [insert](https://kotlin.github.io/dataframe/_llms/insert.txt)
- [Insert / replace columns](https://kotlin.github.io/dataframe/_llms/insertreplace.txt)
- [Custom integrations with unsupported data sources](https://kotlin.github.io/dataframe/_llms/integrations.txt)
- [Input/output](https://kotlin.github.io/dataframe/_llms/io.txt)
- [isEmpty](https://kotlin.github.io/dataframe/_llms/isempty.txt)
- [Iterating](https://kotlin.github.io/dataframe/_llms/iterate.txt)
- [join](https://kotlin.github.io/dataframe/_llms/join.txt)
- [joinWith](https://kotlin.github.io/dataframe/_llms/joinwith.txt)
- [JSON](https://kotlin.github.io/dataframe/_llms/json.txt)
- [Jupyter Notebooks](https://kotlin.github.io/dataframe/_llms/jupyterrendering.txt)
- [Kotlin DataFrame Features in Kotlin Notebook](https://kotlin.github.io/dataframe/_llms/kotlin-dataframe-features-in-kotlin-notebook.txt)
- [last](https://kotlin.github.io/dataframe/_llms/last.txt)
- [last](https://kotlin.github.io/dataframe/_llms/lastoncolumn.txt)
- [map](https://kotlin.github.io/dataframe/_llms/map.txt)
- [MariaDB](https://kotlin.github.io/dataframe/_llms/mariadb.txt)
- [maxBy](https://kotlin.github.io/dataframe/_llms/maxby.txt)
- [mean](https://kotlin.github.io/dataframe/_llms/mean.txt)
- [median](https://kotlin.github.io/dataframe/_llms/median.txt)
- [merge](https://kotlin.github.io/dataframe/_llms/merge.txt)
- [Microsoft SQL Server (MS SQL)](https://kotlin.github.io/dataframe/_llms/microsoft-sql-server.txt)
- [Migration from Gradle/KSP Plugin](https://kotlin.github.io/dataframe/_llms/migration-from-plugins.txt)
- [Migration to 1.0](https://kotlin.github.io/dataframe/_llms/migrationto-1-0.txt)
- [minBy](https://kotlin.github.io/dataframe/_llms/minby.txt)
- [min / max](https://kotlin.github.io/dataframe/_llms/minmax.txt)
- [Modify](https://kotlin.github.io/dataframe/_llms/modify.txt)
- [Modules](https://kotlin.github.io/dataframe/_llms/modules.txt)
- [move](https://kotlin.github.io/dataframe/_llms/move.txt)
- [Move / rename / reorder columns](https://kotlin.github.io/dataframe/_llms/moverename.txt)
- [Multiple DataFrames](https://kotlin.github.io/dataframe/_llms/multipledataframes.txt)
- [MySQL](https://kotlin.github.io/dataframe/_llms/mysql.txt)
- [NaN and NA](https://kotlin.github.io/dataframe/_llms/nanandna.txt)
- [none](https://kotlin.github.io/dataframe/_llms/none.txt)
- [Number Unification](https://kotlin.github.io/dataframe/_llms/numberunification.txt)
- [OpenAPI](https://kotlin.github.io/dataframe/_llms/openapi.txt)
- [Operations](https://kotlin.github.io/dataframe/_llms/operations.txt)
- [Packaging into a fat JAR](https://kotlin.github.io/dataframe/_llms/packaging.txt)
- [Parquet](https://kotlin.github.io/dataframe/_llms/parquet.txt)
- [parse](https://kotlin.github.io/dataframe/_llms/parse.txt)
- [percentile](https://kotlin.github.io/dataframe/_llms/percentile.txt)
- [pivot](https://kotlin.github.io/dataframe/_llms/pivot.txt)
- [Pivot / gather columns](https://kotlin.github.io/dataframe/_llms/pivotgather.txt)
- [PostgreSQL](https://kotlin.github.io/dataframe/_llms/postgresql.txt)
- [Quickstart Guide](https://kotlin.github.io/dataframe/_llms/quickstart.txt)
- [Read](https://kotlin.github.io/dataframe/_llms/read.txt)
- [Read from SQL databases](https://kotlin.github.io/dataframe/_llms/readsqldatabases.txt)
- [How to Extend the DataFrame Library for Custom SQL Database Support: Example with HSQLDB](https://kotlin.github.io/dataframe/_llms/readsqlfromcustomdatabase.txt)
- [DuckDB type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-duckdb.txt)
- [H2 type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-h2.txt)
- [MariaDB type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-mariadb.txt)
- [MS SQL Server type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-mssql.txt)
- [MySQL type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-mysql.txt)
- [PostgreSQL type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-postgresql.txt)
- [SQLite type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping-sqlite.txt)
- [SQL to DataFrame column type mapping](https://kotlin.github.io/dataframe/_llms/readsqltypemapping.txt)
- [remove](https://kotlin.github.io/dataframe/_llms/remove.txt)
- [rename](https://kotlin.github.io/dataframe/_llms/rename.txt)
- [Rendering](https://kotlin.github.io/dataframe/_llms/rendering.txt)
- [reorder](https://kotlin.github.io/dataframe/_llms/reorder.txt)
- [Reorder rows](https://kotlin.github.io/dataframe/_llms/reorderrows.txt)
- [replace](https://kotlin.github.io/dataframe/_llms/replace.txt)
- [requireColumn](https://kotlin.github.io/dataframe/_llms/require.txt)
- [reverse](https://kotlin.github.io/dataframe/_llms/reverse.txt)
- [rows](https://kotlin.github.io/dataframe/_llms/rows.txt)
- [rowsCount](https://kotlin.github.io/dataframe/_llms/rowscount.txt)
- [Row statistics](https://kotlin.github.io/dataframe/_llms/rowstats.txt)
- [schema](https://kotlin.github.io/dataframe/_llms/schema.txt)
- [Data Schemas](https://kotlin.github.io/dataframe/_llms/schemas.txt)
- [Data Schemas in Gradle projects](https://kotlin.github.io/dataframe/_llms/schemasgradle.txt)
- [Import OpenAPI Schemas in Gradle project (Experimental)](https://kotlin.github.io/dataframe/_llms/schemasimportopenapigradle.txt)
- [Import Data Schemas, e.g. from OpenAPI, in Kotlin Notebook](https://kotlin.github.io/dataframe/_llms/schemasimportopenapijupyter.txt)
- [Import SQL Metadata as a Schema in Gradle Project](https://kotlin.github.io/dataframe/_llms/schemasimportsqlgradle.txt)
- [Schema inheritance](https://kotlin.github.io/dataframe/_llms/schemasinheritance.txt)
- [Select columns](https://kotlin.github.io/dataframe/_llms/select.txt)
- [Setup Kotlin DataFrame](https://kotlin.github.io/dataframe/_llms/setup.txt)
- [Setup Kotlin DataFrame on Android](https://kotlin.github.io/dataframe/_llms/setupandroid.txt)
- [Custom Gradle Configuration](https://kotlin.github.io/dataframe/_llms/setupcustomgradle.txt)
- [Setup Kotlin DataFrame on Datalore](https://kotlin.github.io/dataframe/_llms/setupdatalore.txt)
- [Setup Kotlin DataFrame in Gradle](https://kotlin.github.io/dataframe/_llms/setupgradle.txt)
- [Setup Kotlin DataFrame in Jupyter](https://kotlin.github.io/dataframe/_llms/setupjupyter.txt)
- [Setup Kotlin DataFrame in Kotlin Notebook](https://kotlin.github.io/dataframe/_llms/setupkotlinnotebook.txt)
- [Setup Kotlin DataFrame in Kotlin Toolchain](https://kotlin.github.io/dataframe/_llms/setupkotlintoolchain.txt)
- [Setup Kotlin DataFrame in Maven](https://kotlin.github.io/dataframe/_llms/setupmaven.txt)
- [](https://kotlin.github.io/dataframe/_llms/shadow-resources.txt)
- [shuffle](https://kotlin.github.io/dataframe/_llms/shuffle.txt)
- [single](https://kotlin.github.io/dataframe/_llms/single.txt)
- [single](https://kotlin.github.io/dataframe/_llms/singleoncolumn.txt)
- [Slice rows](https://kotlin.github.io/dataframe/_llms/slicerows.txt)
- [sortBy](https://kotlin.github.io/dataframe/_llms/sortby.txt)
- [Spelling Conventions](https://kotlin.github.io/dataframe/_llms/spellingconventions.txt)
- [split](https://kotlin.github.io/dataframe/_llms/split.txt)
- [Split / merge columns](https://kotlin.github.io/dataframe/_llms/splitmerge.txt)
- [SQL](https://kotlin.github.io/dataframe/_llms/sql.txt)
- [SQLite](https://kotlin.github.io/dataframe/_llms/sqlite.txt)
- [Static Interpretation of DataFrame API](https://kotlin.github.io/dataframe/_llms/staticinterpretation.txt)
- [Statistical Relationship](https://kotlin.github.io/dataframe/_llms/statisticalrelationship.txt)
- [std](https://kotlin.github.io/dataframe/_llms/std.txt)
- [String API](https://kotlin.github.io/dataframe/_llms/stringapi.txt)
- [sum](https://kotlin.github.io/dataframe/_llms/sum.txt)
- [Summary statistics](https://kotlin.github.io/dataframe/_llms/summarystatistics.txt)
- [Support](https://kotlin.github.io/dataframe/_llms/support.txt)
- [tail](https://kotlin.github.io/dataframe/_llms/tail.txt)
- [toHtml](https://kotlin.github.io/dataframe/_llms/tohtml.txt)
- [toList](https://kotlin.github.io/dataframe/_llms/tolist.txt)
- [toMap](https://kotlin.github.io/dataframe/_llms/tomap.txt)
- [Troubleshooting](https://kotlin.github.io/dataframe/_llms/troubleshooting.txt)
- [Data Abstractions](https://kotlin.github.io/dataframe/_llms/types.txt)
- [unfold](https://kotlin.github.io/dataframe/_llms/unfold.txt)
- [ungroup](https://kotlin.github.io/dataframe/_llms/ungroup.txt)
- [update](https://kotlin.github.io/dataframe/_llms/update.txt)
- [Update / convert values](https://kotlin.github.io/dataframe/_llms/updateconvert.txt)
- [Utility functions](https://kotlin.github.io/dataframe/_llms/utils.txt)
- [valueCounts](https://kotlin.github.io/dataframe/_llms/valuecounts.txt)
- [values](https://kotlin.github.io/dataframe/_llms/values.txt)
- [Write](https://kotlin.github.io/dataframe/_llms/write.txt)
- [xs](https://kotlin.github.io/dataframe/_llms/xs.txt)