{"id":3863,"date":"2024-03-25T15:22:33","date_gmt":"2024-03-25T15:22:33","guid":{"rendered":"http:\/\/van-maanen.com\/?p=3863"},"modified":"2024-03-25T15:22:33","modified_gmt":"2024-03-25T15:22:33","slug":"ordinary-least-squares-in-pandas","status":"publish","type":"post","link":"http:\/\/archief.van-maanen.com\/?p=3863","title":{"rendered":"Ordinary Least Squares in Pandas"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">Below, I read a table and I apply the ordinary least squares methode to it:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">import pandas as pd\nfrom sqlalchemy.engine import create_engine\nfrom sqlalchemy.engine import URL\nimport sqlalchemy as sa\nimport statsmodels.api as sm\n\ntable_name = 'MIGRATED_DIVORCE_SETTLEMENT__C'\n\nconnection_string = \"DRIVER={ODBC Driver 17 for SQL Server};SERVER=DESKTOP-8J58OIP\\MSSQLSERVER_19;DATABASE=Speel;UID=sa;PWD=**\"\nconnection_url = URL.create(\"mssql+pyodbc\", query={\"odbc_connect\": connection_string})\nengine = create_engine(connection_url)\nwith engine.begin() as conn:\n    df = pd.read_sql_query(sa.text(\"SELECT * FROM Rapportage.\" + table_name), conn)\n\nonderzoek = df[['Person_ID_1__c','Person_ID_2__c']].apply(pd.to_numeric).dropna()\nprint(onderzoek.info())\nprint(onderzoek.head())\n\ny = onderzoek['Person_ID_1__c']\nx = onderzoek['Person_ID_2__c']\nx = sm.add_constant(x)\n\nprint(type(x))\nprint(type(y))\n\nmodel = sm.OLS(y, x).fit()\n\n#view model summary\nprint(model.summary())\n\nprint('**********programma beindigd****')<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Below, I read a table and I apply the ordinary least squares methode to it: import pandas as pd from sqlalchemy.engine import create_engine from sqlalchemy.engine import URL import sqlalchemy as sa import statsmodels.api as sm table_name = &#8216;MIGRATED_DIVORCE_SETTLEMENT__C&#8217; connection_string = &#8220;DRIVER={ODBC Driver 17 for SQL Server};SERVER=DESKTOP-8J58OIP\\MSSQLSERVER_19;DATABASE=Speel;UID=sa;PWD=**&#8221; connection_url = URL.create(&#8220;mssql+pyodbc&#8221;, query={&#8220;odbc_connect&#8221;: connection_string}) engine = create_engine(connection_url) with [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[],"class_list":["post-3863","post","type-post","status-publish","format-standard","hentry","category-niet-gecategoriseerd"],"_links":{"self":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3863"}],"version-history":[{"count":0,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=\/wp\/v2\/posts\/3863\/revisions"}],"wp:attachment":[{"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3863"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/archief.van-maanen.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}