Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- df1 <-data.frame(ID_NUMBER = c(990,50000,52000,764000,764000,764000,1420000,1420000,1470000,1470000,2176000,2176000,2401000,2401000,2667000,2667000,3519000,3721000,3721000,4654000,4654000,4685000),
- CalNumber = c(0,1126.61,1152.24,26900.12,26900.2,26910,50673.98,50674.31,52161.18,52161.73,77743.17,77743.7,85593.97,85594.42,94854.76,94855,124033.46,130973.56,130973.59,162935.73,162935.85,163446.89),
- Date = c('8/8/2013' ,'8/16/2008' ,'8/8/2013' ,'8/8/2013' ,'8/16/2008' ,'8/16/2008' ,'8/16/2008' ,'8/8/2013' ,'8/16/2008' ,'8/8/2013' ,'8/16/2008' ,'8/8/2013' ,'8/16/2008' ,'8/8/2013' ,'8/16/2008' ,'8/8/2013' ,'8/8/2013' ,'8/8/2013' ,'8/16/2008' ,'8/16/2008' ,'8/8/2013' ,'8/8/2013'))
- ID_NUMBER CalNumber Date
- 990 0 8/8/2013 0:00
- 50000 1126.61 8/16/2008 0:00
- 52000 1152.24 8/8/2013 0:00
- 764000 26900.12 8/8/2013 0:00
- 764000 26900.2 8/16/2008 0:00
- 764000 26910 8/16/2008
- 1420000 50673.98 8/16/2008 0:00
- 1420000 50674.31 8/8/2013 0:00
- 1470000 52161.18 8/16/2008 0:00
- 1470000 52161.73 8/8/2013 0:00
- 2176000 77743.17 8/16/2008 0:00
- 2176000 77743.7 8/8/2013 0:00
- 2401000 85593.97 8/16/2008 0:00
- 2401000 85594.42 8/8/2013 0:00
- 2667000 94854.76 8/16/2008 0:00
- 2667000 94855 8/8/2013 0:00
- 3519000 124033.46 8/8/2013 0:00
- 3721000 130973.56 8/8/2013 0:00
- 3721000 130973.59 8/16/2008 0:00
- 4654000 162935.73 8/16/2008 0:00
- 4654000 162935.85 8/8/2013 0:00
- 4685000 163446.89 8/8/2013 0:00
- ID_NUMBER CalNumber Date CalcDiff IsNew isPrimary
- 990 0 8/8/2013 -- Y Y
- 50000 1126.61 8/16/2008 -- Y Y
- 52000 1152.24 8/8/2013 -- Y Y
- 764000 26900.12 8/8/2013 -- N Y
- 764000 26900.2 8/16/2008 .08 N N
- 764000 26910 8/16/2008 9.8 Y Y
- 1420000 50673.98 8/16/2008 -- N N
- 1420000 50674.31 8/8/2013 .33 N Y
- 1470000 52161.18 8/16/2008 -- N N
- 1470000 52161.73 8/8/2013 .55 N Y
- 2176000 77743.17 8/16/2008 -- N Y
- 2176000 77743.7 8/8/2013 .53 N N
- 2401000 85593.97 8/16/2008 -- N Y
- 2401000 85594.42 8/8/2013 .45 N N
- 2667000 94854.76 8/16/2008 -- N N
- 2667000 94855 8/8/2013 .24 N Y
- 3519000 124033.46 8/8/2013 -- Y Y
- 3721000 130973.56 8/8/2013 -- N Y
- 3721000 130973.59 8/16/2008 .03 N N
- 4654000 162935.73 8/16/2008 -- Y Y
- 4654000 162936.85 8/8/2013 1.12 Y Y
- 4685000 163446.89 8/8/2013 -- Y Y
Add Comment
Please, Sign In to add comment