How to calculate amount of patients

[Tinde]

I have a dataframe with patients that have answered twice in same questionnaire in couple of years. Now I need to calculate how many patient developed problem, how many improved and how many maintained having problems. The answers are in scale 1-6 where <3 is no problem, 3-4.75 is sometimes problem and >= 5 is problems.

I have merged these two dataframe to one and tried to calculate difference by coding dat5$noproblem = ((dat5$sleepProblems.x)<3)-((dat5$sleepProblems.y)<3) but I only get a dataframe there is zero and minus 1 and which dimension is NULL.
I tried do the same with diff((dat5$sleepProblems.x<3) - lag((dat5$sleepProblems.y<3))) but I still get just list of different values.

How I can get the amount of patients?

(Sorry for unclear description)

[valeri]

Hi @Tinde,

as mentioned in your thread on SO, please provide some more details of the data and much better at least a sample of the data. You can use the dput function to get your data in a shape ready to copy-paste.

[mara]

@valeri

as mentioned in your thread on SO,

If this is also cross-posted on SO, please link to your post here as well.

Please see our site policy about cross-posting. We ask that, if it can't be avoided, you at least link to the other post, and keep the thread updated if you have received a solution to avoid someone spending time answering a question that's already been resolved.

FAQ: Is it OK if I cross-post?

Posting the same question both here and on other sites Posting the same question to multiple forums at the same time is often considered impolite. We don't completely ban such cross-posting, but we ask you to think hard before you do it and to follow some rules. Cross-post sparingly Rather than post the same thing here and elsewhere from the get-go, post in one place at a time. Let enough time go by (think days, not hours) before you take your question somewhere else. Sometimes people at another site may suggest you post here if your question doesn't fit within the scope of the other site. Always link to your other posts, and update everywhere with any solution…

[Tinde]

Oh sorry, didn't realize that! My problem is now solved and link to SO is here: https://stackoverflow.com/questions/58991351/calculating-amount-of-patients-in-r