Skip to content

AlgorexHealth/cms-sqlite-loader

Repository files navigation

cms-sqlite-loader

This repository contains python code to ETL the synthetic PUF from medicare found here:

This ETL code creates a 1-to-1 mapping between a CMS PUF artifact file (a CSV), and a SQLite .db file.

Motivation

A CMS Synthetic PUF Claims file has all the data needed to do analysis. However it comes in a slightly inconvenient format for querying at the cost for a universally known format: CSV.

Sqlite is a powerful embeddable database that allows complete access to the entirety of the SQL specification, and stores all its data in a single file that is 100% portable from sysyste to system. This last quality allows us to do the following:

CMS Synthetic PUF

Here our ETL code maps from one serialization (a CSV file) to another (a SQLite db file).

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published