Python package to manipulate health (CMS) data

Package cms

fts2yaml is a generic parser for FTS format for both Medicaid and Medicare.
create_schema_config is used to interpret options to introspect raw files or parse FTS
registry Command line tool to create and/or update data models for raw CMS data (See create_schema_config for options)
random_selector Selects random lines from a CSV-like file
random_selector Selects random lines from a set of CMS files described by an FTS file
medicare data loader Subclass of generic Data Loader aware of the raw Medicare CMS data structure. Matches FTS and DAT files.

Package cms.tools

CMS Test data generator Selects random lines from a set of CMS files described by an FTS file
mcr_combine_tables Command-line tool to combine disparate tables with raw medicare CMS data into a single consolidated view. See details
medpar_converter Converter for CMS DAT files described by FTS to CSV
mcr_file Module to manipulate with a single Medicare CMS DAT file
mcr_fts2csv Simple converter from FWF format to CSV
mcr_fts2db Loader of FWF data into the database
mcr_registry Common content for the Medicare data model YAML file
mcr_sas Abstract class to look for and process Medicare files from 1999 to 2010
mcr_sas2db Loader looks for SAS 7BDAT files
mcr_sas2yaml Introspector for SAS 7BDAT files, generating YAML data model for each file

This package contains code that was written to try to extract corrupted medicare data for 2015. Ultimately, this attempt was unsuccessful.

Additional details

Parsing FTS

File transfer summary (FTS) document contains information about the data extract. These are plain text files containing information such as the number of columns in the data extract, number of rows and the size of the data file. The FTS document provides the starting positions, the length and the generic format of each of the column (such as character, numeric or date)