kgilds / getrealscripts Goto Github PK

http://stackoverflow.com/questions/24447877/invalid-factor-level-na-generated-when-pasting-in-a-dataframe-in-r

Needed to convert a factor to character because we were introducing a new factor.

Make sure the column names readable and understandable.

Soon

Here is how I think you fix it the duplicate issue.

gradesUnique <- gradesq1 [!(duplicated(gradesq1$girlCode) | duplicated(gradesq1$girlCode, fromLast = TRUE)), ]

going to have to merge based on the selected outcomes or place in general date frame and re-run q4.

However, it fits withing Q2 data structure.

Soon rather than later.

Fix
test1<- sub("313", "", gateway$girlCode)

fixgirlCode<- sub("", "313", test1)

gateway2 <-cbind(gateway, fixgirlCode)

Delete anything that is not used and make sure everything is working.

Use Dplyr to select different views.

preDupes <-duplicated(pre$girlCode) | duplicated(pre$girlCode, fromLast=TRUE)

preDupes <-pre[preDupes, ]

dim(preDupes)

write.csv(preDupes, "girlSurveyDups022715.csv")

This code worked.

Make sure we are clear what is what when well pull the query down.

Scale package may be the answer. Get to a single number and note that is is in a percent format.

Start with 3 separate apps.

Change value to factor.

mq1Reading$value <- as.factor(mq1Reading$value)

names(mq1Reading)

change Labels on the levels

levels(mq1Reading$value) <- c("F","D", "C", "B", "A")

change Labels on the levels

levels(q1freeRead3$value) <- c("F","D", "C", "B", "A")

Bind the data frames together.

mq1Reading2 <-rbind(mq1Reading, q1freeRead3)

#Label the levels

levels(mq1Lang$value) <- c("F", "D", "C", "B", "A")

CREATE VIEW "readingOutcomes" AS select * FROM preSurvey2015 LEFT OUTER JOIN q1Reading ON preSurvey2015.girlCode=q1Reading.girlCode

CREATE VIEW "allOutcomes" AS select * from outcomesgrades LEFT OUTER JOIN q1behavior ON outcomesgrades.girlCode=q1behavior.girlCode