Documents for calculating a median from "binned" values area included in the MedianCalculation.zip file. They Python script is in Python 3 and I have included a sample CSV file that I used. For HH income I use table B19001 from the ACS and I do a check first using a known geography and compare the calculated median with the Census provided one from table B19013. In this case it is for Androscoggin County, Maine. The Census provided median HH income is $55,002 and the script and the excel spreadsheet calculated $55,054 - very close and within the margin of error so I know it is working as expected. The PDF document is how I got the method to do it. I use the Summary Files that I pull into SQL server, so you will see my query notes for that in the Excel sheet as well. For questions, contact Jami Dennis jami@geodetic.xyz