{"id":3720,"date":"2026-07-20T03:38:52","date_gmt":"2026-07-20T03:38:52","guid":{"rendered":"https:\/\/tucumandevelopers.com\/index.php\/2026\/07\/20\/ada-an-open-source-ai-data-analyst-that-shows-its-math\/"},"modified":"2026-07-20T03:38:52","modified_gmt":"2026-07-20T03:38:52","slug":"ada-an-open-source-ai-data-analyst-that-shows-its-math","status":"publish","type":"post","link":"https:\/\/tucumandevelopers.com\/index.php\/2026\/07\/20\/ada-an-open-source-ai-data-analyst-that-shows-its-math\/","title":{"rendered":"ADA: an open-source AI data analyst that shows its math"},"content":{"rendered":"<div>\n<div><\/header>\n<div data-article-id=\"4183515\" id=\"article-body\">\n<p>I watched my sister paste a CSV into on of our LLM overlords and ask a question then reword it and get a different number. That&#8217;s the problem with letting an LLM both read your question and trust it&#8217;s math.<\/p>\n<p>ADA splits the two jobs. Drop in a CSV or Excel file, get a dashboard, anomaly detection, a forecast, and plain-English answers, all calculated locally using pandas (locally in the sense of never leaving the server and going to the AI apis.). The LLM layer that you can use (it&#8217;s optional) but that only sees column names and never your rows, and the whole thing works with zero API key if need be (not the LLM part of course).<\/p>\n<p>MIT licensed, solo-built, open to contributors (in fact would need help to make it move out of LLMs and have a few open issues).<\/p>\n<p>I wish to make it as LLM free as possible as I want to make it deterministic. <\/p>\n<p>Live demo: automated-data-analyst.streamlit.app<br \/> Repo: <a href=\"https:\/\/github.com\/saineshnakra\/automated-data-analyst\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/github.com\/saineshnakra\/automated-data-analyst<\/a><\/p>\n<\/p><\/div>\n<\/article>\n<p> <!-- Bottom content skipped via SKIP_BOTTOM_CONTENT config --> <\/div>\n<p> <\/main> <\/div>\n<\/div>\n<\/div>\n<\/div>\n<p>Fuente: <a href=\"https:\/\/dev.to\/sainesh_nakra\/ada-an-open-source-ai-data-analyst-that-shows-its-math-3ka7\">Art\u00edculo original<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>I watched my sister paste a CSV into on of our LLM overlords and ask a question then reword it and get a different number. That&#8217;s the problem with letting an LLM both read your question and trust it&#8217;s math. ADA splits the two jobs. Drop in a CSV or Excel file, get a dashboard, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3719,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[41],"tags":[],"class_list":["post-3720","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-devto"],"jetpack_publicize_connections":[],"_links":{"self":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/3720","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/comments?post=3720"}],"version-history":[{"count":0,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/posts\/3720\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media\/3719"}],"wp:attachment":[{"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/media?parent=3720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/categories?post=3720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/tucumandevelopers.com\/index.php\/wp-json\/wp\/v2\/tags?post=3720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}