| Id | Total Amount |
| 1 | 34 |
| 1 | -34 |
| 1 | 25 |
| 2 | 13 |
| 2 | 14 |
| 3 | 456 |
| 3 | 43 |
| 3 | -456 |
| 3 | 765 |
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.
Wednesday, September 23, 2020
Flagging negative values within an id
Hi. My dataset has an id variable and a total amount variable. There are multiple observations per id and within a single id there are sometimes negative numbers of the same positive number in another observation. How do I flag these entries that are merely negatives of each other? For example, in the given table below, I want to flag the first two entries for id 1 and the first and third entry for id 3.
No comments:
Post a Comment