0

I have survey data with the typical Likert scales. however, the responses choices are in separate columns in the CSV. Could someone help me join the answer choices in the same column?

Question: In the past 30 days to what extent has childcare been a source of stress: Choices - Not at all, Somewhat, Challenging but able to manage, Very Challenging It makes it difficult to conduct simple descriptive statistics e.g. count().

Any help is greatly appreciated.

In the past 30 days to what extent has childcare been a source of stress.

count(Test4R$NO_ChildCare_Stress_Last30Days) x freq 1 0 1 2 1 14 3 NA 41

count(Test4R$Somewhat_ChildcareStress) x freq 1 0 1 2 1 16 3 NA 39 count(Test4R$Very_challenge_ChildCare) x freq 1 0 1 2 1 4 3 NA 51 count(Test4R$Challenge_ChildCare_Stress) x freq 1 1 26 2 NA 30

Luis
  • 97
  • 2
  • 2
  • 10
  • 1
    Please try to explain exactly where you're getting stuck, e.g. are you able to import the data at all, do you have the data but can't calculate a specific answer from it, etc. Then try to come up with a [reproducible example](https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example) that describes the problem, at the point you're stuck. – Marius Aug 03 '18 at 05:53
  • it seems that you should `read.csv` with argument `skip = 1`. Then, edit the question with the output of `dput(df)` or if it is too big, `dput(head(df, 20))`, please. – Rui Barradas Aug 03 '18 at 06:03
  • Hi Marius, I am getting stuck in running the counts on the Likert scale. For example, I would like to compute how many selected challenging, not at all, somewhat, etc. However, since each choice is is a separate column, it is not as straightforward as I expected. I expected each choice to be a different number in the same column. E.g. 1=challenging, 2=somewhat, etc. – Luis Aug 03 '18 at 13:19
  • Hi Rui, I’ll try it. I guess the other thing I could is manually change the scores in the CSV. 1=challenging, 2=somewhat but I would prefer to use my time analyzing and interpreting the output. – Luis Aug 03 '18 at 13:21

0 Answers0