search

coderxio / sagerx

Open drug data pipelines curated by pharmacists.
https://coderx.io/sagerx
Other
41 stars 11 forks source link

FDA NDC package equivalence (discrete packaging information) #8

Open Bridg109 opened 2 years ago

Bridg109 commented 2 years ago

Proposal

Parse the fda_ndc package field into a package equivalency table

Rationale

adds digestible package information for people to use tied to NDCs

jrlegrand commented 2 years ago

@Bridg109 - did you get very far with this? Is this just regexing the fda package information field to get total count of unit per outer NDC?

Bridg109 commented 2 years ago

I stopped when we changed to postgres. Noting it should be easier now

On Sun, May 22, 2022, 8:44 AM Joseph LeGrand @.***> wrote:

@Bridg109 https://github.com/Bridg109 - did you get very far with this? Is this just regexing the fda package information field to get total count of unit per outer NDC?

— Reply to this email directly, view it on GitHub https://github.com/coderxio/sagerx/issues/8#issuecomment-1133899407, or unsubscribe https://github.com/notifications/unsubscribe-auth/AJUPMCRBOWTV5EIFBXPN5WDVLI23FANCNFSM5GYRMQFQ . You are receiving this because you were mentioned.Message ID: @.***>

jrlegrand commented 4 months ago

See some analysis and notes on this page: https://coderx.io/sagerx/source-data/dailymed

See branch I associated with this issue (jrlegrand/pack-size).

I've noticed that "parts" (i.e. kit parts) tend to be the final part of a description.

Also - parts can have "sub-parts"(?) like this: * 1 SYRINGE in 1 TRAY / .4 mL in 1 SYRINGE (0025-0329-01)

I'm thinking that we have 3(?) layers - maybe more:

Example: 2 KIT in 1 CARTON (0025-0333-02) / 1 KIT in 1 KIT 1 SYRINGE in 1 TRAY / .4 mL in 1 SYRINGE (0025-0329-01) 1 mL in 1 PACKET (0069-1111-01)

  1. packaging components
    1. 2 KIT in 1 CARTON (0025-0333-02)
    2. 1 KIT in 1 KIT 1 SYRINGE in 1 TRAY / .4 mL in 1 SYRINGE (0025-0329-01) 1 mL in 1 PACKET (0069-1111-01)
  2. packaging parts (both relate to component ii)
      • 1 SYRINGE in 1 TRAY / .4 mL in 1 SYRINGE (0025-0329-01)
      • 1 mL in 1 PACKET (0069-1111-01)
  3. packaging subparts (relates to part i)
    1. / .4 mL in 1 SYRINGE (0025-0329-01)

Another way of visualizing this: