Saturday, 15 February 2014

r - How to connect data dictionaries to the unlabeled data -



r - How to connect data dictionaries to the unlabeled data -

i'm working large authorities datasets section of transportation available tab-delimited text files accompanied info dictionaries. example, auto complaints file 670mb file of unlabeled info (when unzipped), , comes a dictionary. here excerpts:

last updated: apr 24, 2014 fields: ======= field# name type/size description ------ --------- --------- -------------------------------------- 1 cmplid char(9) nhtsa's internal unique sequence number. updateable field,thus info given record potentially alter 1 info output file next. 2 odino char(9) nhtsa's internal reference number. number may repeated multiple components. also, if ldate prior dec 15, 2002, number may repeated multiple products owned same complainant.

some of fields have foreign keys listed so:

21 cmpl_type char(4) source of complaint code: cag =consumer action grouping con =forwarded congressional office dp =defect petition,result of defect petition evoq =hotline voq ewr =early warning reporting ins =insurance company ivoq =nhtsa web site letr =consumer letter mavq =nhtsa mobile app mivq =nhtsa mobile app mvoq =optical marked voq rc =recall complaint,result of recall investigation rp =recall petition,result of recall petition svoq =portable safety complaint form (pdf) voq =nhtsa vehicle owners questionnaire

there import instructions microsoft access, don't have , not utilize if did. think info dictionary meant machine-readable.

my question: info dictionary standard format of kind? i've tried google around, it's hard without right terminology. import r, though i'm flexible long can done programmatically.

r ms-access data-dictionary

No comments:

Post a Comment