Skip to content

Instantly share code, notes, and snippets.

@cecilialiao

cecilialiao/gist:4530302

Last active December 11, 2015 02:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save cecilialiao/4530302 to your computer and use it in GitHub Desktop.
Save cecilialiao/4530302 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
august_raw$costperunit <- august_raw$ACT.COST/august_raw$QUANTITY
summary(august_raw)
SHA PCT PRACTICE BNF.CODE
Q31 :1570430 5QC : 213379 M85063 : 3208 0103050P0AAAAAA: 8561
Q36 :1459636 5QV : 179775 C83019 : 3039 0407010H0AAAMAM: 8537
Q34 :1165719 5P5 : 173293 K83002 : 2953 0501012G0AAABAB: 8499
Q35 :1044825 5N9 : 151460 N83028 : 2866 0501013B0AAABAB: 8498
Q32 :1039957 5QA : 147953 Y01008 : 2786 0501080W0AAAEAE: 8483
Q39 : 972798 5N1 : 146439 C84024 : 2776 0103050L0AAAAAA: 8475
(Other):2803267 (Other):9044333 (Other):10039004 (Other) :10005579
BNF.NAME ITEMS
3m Health Care_Cavilon Durable Barrier C: 10356 Min. : 1.000
Omeprazole_Cap E/C 20mg : 8561 1st Qu.: 1.000
Paracet_Tab 500mg : 8537 Median : 2.000
Fluclox Sod_Cap 500mg : 8499 Mean : 8.303
Amoxicillin_Cap 500mg : 8498 3rd Qu.: 5.000
Trimethoprim_Tab 200mg : 8483 Max. :2920.000
(Other) :10003698
NIC ACT.COST QUANTITY PERIOD
Min. : 0.00 Min. : 0.01 Min. : 0 Min. :201208
1st Qu.: 8.08 1st Qu.: 7.59 1st Qu.: 28 1st Qu.:201208
Median : 22.56 Median : 21.05 Median : 100 Median :201208
Mean : 69.15 Mean : 64.17 Mean : 692 Mean :201208
3rd Qu.: 63.69 3rd Qu.: 59.21 3rd Qu.: 336 3rd Qu.:201208
Max. :76766.52 Max. :70750.02 Max. :1814298 Max. :201208
X costperunit
Mode:logical Min. : 0
NA's:10056632 1st Qu.: 0
Median : 0
Mean :Inf
3rd Qu.: 1
Max. :Inf
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment