| id | age | sample date | sample site | result |
| 1 | 1 | 10/14/2022 | 0 | 0 |
| 1 | 1 | 10/25/2022 | 1 | 0 |
| 1 | 1 | 11/1/2022 | 1 | 1 |
| 1 | 1 | 11/8/2022 | 1 | 0 |
| 2 | 9 | 09/27/2022 | 1 | 0 |
| 2 | 9 | 10/15/2022 | 1 | 1 |
| 2 | 9 | 10/24/2022 | 0 | 0 |
| 3 | 4 | 9/22/2022 | 1 | 1 |
| 3 | 4 | 10/05/2022 | 1 | 0 |
Specialized on Data processing, Data management Implementation plan, Data Collection tools - electronic and paper base, Data cleaning specifications, Data extraction, Data transformation, Data load, Analytical Datasets, and Data analysis. BJ Data Tech Solutions teaches on design and developing Electronic Data Collection Tools using CSPro, and STATA commands for data manipulation. Setting up Data Management systems using modern data technologies such as Relational Databases, C#, PHP and Android.
Tuesday, November 8, 2022
Multiple observations per id. How to filter observations if within a number of days of episode
Hi! I'm working with a large data set that has multiple observations per id. Basically, there's one observation per collected sample. I'm trying to filter by "patients" that sent a sample within a number of days (before and/or after) of a positive result. Roughly my data looks like this:
Could you help me figure out how to get this data?
No comments:
Post a Comment