Displaying 1 result from an estimated 1 matches for "npostal".
Did you mean:
postal
2012 Jan 03
1
sqldf and not converting integers to floating point in SQLite
...en INSEE, and diving the value
of the postal in that INSEE by that number).
library(sqldf)
table1 <- read.csv("c:/R/table1.csv", sep=";")
table2 <- read.csv("c:/R/table2.csv", sep=";")
table3 <- sqldf("select table2.INSEE, table1.VALUE / counts.nPostals
as value_spread from table1, table2,(select POSTAL, count(INSEE) as
nPostals from table2 group by POSTAL) counts where table1.POSTAL =
counts.POSTAL and table1.POSTAL=table2.POSTAL")
Unfortunately, the value I'm working with is an integer. In SQLite,
this results in the computed value al...