library(sqldf)
data(surnamesgal14)
loc <- length(unique(surnamesgal14$muni))
apes2=sqldf('select muni, count(surname) as ni,
sum(number) as population from surnamesgal14
group by muni;')
surnamesgal14$pki0 <- surnamesgal14$pki
result = fGeometricMean (x= surnamesgal14[surnamesgal14$number != 0,],
pki="pki", pki0="pki0" , location = "muni",
s = apes2$ni[1:loc])
result
data(namesmengal16)
loc <- length(unique(namesmengal16$muni))
names2=sqldf('select muni, count(name) as ni,
sum(number) as population from namesmengal16
group by muni;')
namesmengal16$pki <- (namesmengal16$number /
namesmengal16$population)
namesmengal16$pki0 <- namesmengal16$pki
result = fGeometricMean (x= namesmengal16[namesmengal16$number != 0,],
pki="pki", pki0="pki0" , location = "muni",
s = names2$ni[1:loc])
result
data(nameswomengal16)
loc <- length(unique(nameswomengal16$muni))
names2=sqldf('select muni, count(name) as ni,
sum(number) as population from nameswomengal16
group by muni;')
nameswomengal16$pki <- (nameswomengal16$number /
nameswomengal16$population)
nameswomengal16$pki0 <- nameswomengal16$pki
result = fGeometricMean (x= nameswomengal16[nameswomengal16$number != 0,],
pki = "pki", pki0 = "pki0", location = "muni",
s = names2$ni[1:loc])
result
Run the code above in your browser using DataLab