A modern programming language that makes developers happier.

kotlinlang

Screenshot from 2025-05-02 02-18-11.png

Screenshot from 2025-05-02 02-17-51.png

Hello, when i don't have a column names like in the first row names like - country, region, expenditures, total libraries, etc. and my first row is directly values - like Albania, Europe, 132312, 12312, etc.

and I query about first this happens - see image

There should be a column names first(title) before the values?

THe first values I put became the title in the kotlin notebook

in using plot can i specify the column like column1 not the string name?

```x(column = "country")
y(column = "totalLibries")```
Anyways - I understand now why there's a column names - Just asking what if there's no column names

```x(column = 1)
y(column = 2)```

image.png

If you have a dataset like this, where the first row contains data, not a header - just set `firstRowIsHeader = false` in `readExcel` .

And yeah, you can specify a column using index:
```df.plot { 
    line {
        x(getColumn(0))
        y(getColumn(1))
    }
}```
BUT it won't help you if you already read file incorrectly and your first row is used as a header.
So, just read your excel with `firstRowIsHeader = false` as I said before. Then you will have column names like "A", "B", etc - you can use them for plotting:
```df.plot {
   line {
      x(A)
      y(B)
   }
}```
But better rename them first :smile:.