Sqldf mtcars Problem fetching empty column name

[hitesh117]

Hi All,
I am using sqldf package to run query on mtcars dataset, but I am facing issue fetching car names. Please find the query below :

sqldf("select * from df limit 10")

Now, above query does not fetch me car names as output as it does not have column name.
Please let me know how to fetch car name using only sqldf query not indexing.

Thanks in advance.

[andresrcs]

On mtcars dataset, car models are stored as row names, as far as I know sql doesn't understand this concept so you would need to manually convert row names to a column before using sqldf.

library(tidyverse)
library(sqldf)

df <- mtcars %>% 
    rownames_to_column(var = "model")

sqldf("select * from df limit 10")
#>                model  mpg cyl  disp  hp drat    wt  qsec vs am gear carb
#> 1          Mazda RX4 21.0   6 160.0 110 3.90 2.620 16.46  0  1    4    4
#> 2      Mazda RX4 Wag 21.0   6 160.0 110 3.90 2.875 17.02  0  1    4    4
#> 3         Datsun 710 22.8   4 108.0  93 3.85 2.320 18.61  1  1    4    1
#> 4     Hornet 4 Drive 21.4   6 258.0 110 3.08 3.215 19.44  1  0    3    1
#> 5  Hornet Sportabout 18.7   8 360.0 175 3.15 3.440 17.02  0  0    3    2
#> 6            Valiant 18.1   6 225.0 105 2.76 3.460 20.22  1  0    3    1
#> 7         Duster 360 14.3   8 360.0 245 3.21 3.570 15.84  0  0    3    4
#> 8          Merc 240D 24.4   4 146.7  62 3.69 3.190 20.00  1  0    4    2
#> 9           Merc 230 22.8   4 140.8  95 3.92 3.150 22.90  1  0    4    2
#> 10          Merc 280 19.2   6 167.6 123 3.92 3.440 18.30  1  0    4    4