Skip to Main Content

AI Services


For appeals, questions and feedback, please email

IDR data extraction

user-vsu33Jun 23 2023

Currently, you can download IDR report files in xml, xlsx, rtf, and a couple of other formats. In any case, when I attempted to convert this information into a data frame (in python), the results were illegible because the original formatting does not allow to extract information from the cells properly. Thus, without manual maniputlations to the xlsx file, there is no way to upload this data and analyse it, and I would really like to automate data extraction process.

Is there a way to reformat data (or get an SQL query to extract it separately) from the IDR reports so it would be more suitable for analysis using python or other tools?

Thank you!

Post Details
Added on Jun 23 2023