John Cerrito

John Cerrito has practiced pharmacy for over 30 years. He currently is a doctor of pharmacy practicing retail and consulting pharmacy. He has considerable expertise in drug interactions and in working with healthcare claims data to investigate health outcomes.

Publications

Clinical Data Mining for Physician Decision Making and Investigating Health Outcomes: Methods for Prediction and Analysis
Clinical Data Mining for Physician Decision Making and Investigating Health Outcomes: Methods for Prediction and Analysis
Patricia Cerrito, John Cerrito. © 2010. 370 pages.
The investigation of healthcare databases can be used to examine physician decisions and develop evidence-based treatment guidelines that optimize patient outcomes. Clinical Data...
Preprocessing the Data
Preprocessing the Data
Patricia Cerrito, John Cerrito. © 2010. 10 pages.
In this book, we provide tools that are needed to investigate administrative and clinical databases that are routinely collected in the support of patient treatment. Often, these...
Errors and Missing Values in the Dataset
Errors and Missing Values in the Dataset
Patricia Cerrito, John Cerrito. © 2010. 8 pages.
Many of the datasets provided by the federal government have been well cleaned. However, like many other datasets collected for health outcomes research, these datasets contain...
Introduction to the Use of MEPS (Medical Expenditure Panel Survey)
Introduction to the Use of MEPS (Medical Expenditure Panel Survey)
Patricia Cerrito, John Cerrito. © 2010. 38 pages.
We will begin with data from the Medical Expenditure Panel Survey and use it throughout the text. This dataset has been provided since 1996 and contains yearly information...
Preprocessing Medpar Data
Preprocessing Medpar Data
Patricia Cerrito, John Cerrito. © 2010. 12 pages.
Medicare data provide information that hospitals submit for billing purposes, Medpar, or Medicare Provider Analysis and Review. It is publicly available (for a fee) at...
Extracting Data from the National Inpatient Sample
Extracting Data from the National Inpatient Sample
Patricia Cerrito, John Cerrito. © 2010. 25 pages.
In the other type of health care database that we discuss in this chapter, there are multiple columns for each patient observation. It is more difficult to find both the most...
Creating a One-to-One Relationship in the Data from a Many-to-Many
Creating a One-to-One Relationship in the Data from a Many-to-Many
Patricia Cerrito, John Cerrito. © 2010. 22 pages.
One of the biggest problems in dealing with healthcare data is that there can be multiple patient events for the same individual. Without finding some way to combine these many...
Merging Different Datasets to Allow for a Complete Analysis (Inpatient, Outpatient, Physician Visits, Medications)
Merging Different Datasets to Allow for a Complete Analysis (Inpatient, Outpatient, Physician Visits, Medications)
Patricia Cerrito, John Cerrito. © 2010. 38 pages.
If we want to gain a complete picture of patient treatment, we need to examine all patient encounters with the medical profession. Then, we need to divide them into episodes of...
Introduction to Analysis Using Time Components
Introduction to Analysis Using Time Components
Patricia Cerrito, John Cerrito. © 2010. 39 pages.
The introduction of a time component requires the use of statistical methods that can utilize dependent data. The assumption of independence that is required for regression...
More Survival Data Mining of Multiple Time of Endpoints
More Survival Data Mining of Multiple Time of Endpoints
Patricia Cerrito, John Cerrito. © 2010. 22 pages.
Survival analysis is almost always reserved for an endpoint of mortality or recurrence. (Mantel, 1966) However, it can be used for many different types of endpoints as the...
Using the Data to Define Patient Compliance
Using the Data to Define Patient Compliance
Patricia Cerrito, John Cerrito. © 2010. 19 pages.
Patient compliance with treatment is essential. However, it is difficult to examine the issue of compliance from claims and administrative databases that include no direct input...
Compression of Diagnosis and Procedure Codes
Compression of Diagnosis and Procedure Codes
Patricia Cerrito, John Cerrito. © 2010. 15 pages.
Each of the datasets has many different diagnosis and procedure codes to represent a patient’s condition. There are thousands of potential codes, and millions of potential...
Comparisons of Patient Severity Indices
Comparisons of Patient Severity Indices
Patricia Cerrito, John Cerrito. © 2010. 38 pages.
In this section, we will briefly discuss two methods of ranking patient severity. The first method we consider is the AHRQ comorbidities, which is a collection of 30 patient...
Decision Trees and Their Development: Use of Data to Determine the Quality of Care
Decision Trees and Their Development: Use of Data to Determine the Quality of Care
Patricia Cerrito, John Cerrito. © 2010. 18 pages.
Decision trees are developed to support physicians who must make treatment decisions. Risk estimates are used to find the optimal treatment pathway for a group of patients....
Example of Diabetes Using CMS Data
Example of Diabetes Using CMS Data
Patricia Cerrito, John Cerrito. © 2010. 13 pages.
We want to examine the treatment of patients with diabetes, and the reasons these patients are in the hospital. In order to do this, we must consider a cohort of patients who...
Example of Breathing Illnesses, Asthma and COPD Using MEPS Data
Example of Breathing Illnesses, Asthma and COPD Using MEPS Data
Patricia Cerrito, John Cerrito. © 2010. 11 pages.
Asthma and COPD (chronic obstructive pulmonary disease) require maintenance and emergency medication. We want to examine the use of the required medications, as well as to...
Example of Wound Care Using Medpar Data
Example of Wound Care Using Medpar Data
Patricia Cerrito, John Cerrito. © 2010. 17 pages.
Medpar Data is used for billing Medicare; it typically is “packed” into different sheets of data. The first step required to use the data is to “unpack” it into its component...
Discussion
Discussion
Patricia Cerrito, John Cerrito. © 2010. 6 pages.
Now that the data are more readily available for outcomes research and the techniques to analyze that data are available, we need to use the tools to investigate the total...