I am working with data that has multiple diagnosis codes. All the Diagnosis codes are laid out in multiple columns. 1 column for each diagnosis code…25 in total. What I want to do is take my excel file and get counts across the entire file for certain diagnosis codes.
Diagnosis Code Count of Diagnosis Code
Dx 4
Dx1 12
Dx2 19
I am new to python programming and I am able to pull in my excel document and I can groupby the different diagnosis codes, problem is I have to group by many 25 diagnosis code columns.
Kristin Vogelei is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
Importing data as CSV file can help you easily to move to excel (after saving file open it in excel). Hears a website you can learn about it and hear’s how to import a file while on the run.