Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add major university column to persons file #43

Closed
bstabler opened this issue Jan 11, 2018 · 1 comment
Closed

Add major university column to persons file #43

bstabler opened this issue Jan 11, 2018 · 1 comment

Comments

@bstabler
Copy link
Contributor

@DDudich's #Scripts Adds Major university column to persons file as well as fixing Null value in Standard Occupation Classification (SOC) column.

x <- read.csv("persons.csv",as.is=T)
x$soc <- as.numeric(gsub("NUL",0,x$soc))
x$majoruni <-0
x<- x[order(x[,30],x[,10]),c(1:23,31,24:30)]
x$PERID <- 1:nrow(x)
write.csv(x,"persons_sorted_uni.csv",row.names=F)

@bettinardi
Copy link
Collaborator

Editing this so that the ABM code just needs to deal with these two for the person file:
x<- x[order(x[,30],x[,10]),c(1:23,31,24:30)]
x$PERID <- 1:nrow(x)

Overall we discussed three other elements:

  1. Update the seq MAZ numbering
  2. Update HH, Pop, and HHP, based on syn pop inputs. We will add a flag to mark visitors, and visitors won't be included in these totals.
  3. update household table (and person if you want) with Seq MAZ field

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

3 participants