{"id":1642,"date":"2019-05-24T21:06:53","date_gmt":"2019-05-24T18:06:53","guid":{"rendered":"http:\/\/www.gokberkcan.com\/?p=1642"},"modified":"2019-05-24T21:06:53","modified_gmt":"2019-05-24T18:06:53","slug":"rda-regresyon-modellerini-excele-aktarmak","status":"publish","type":"post","link":"https:\/\/www.gokberkcan.com\/?p=1642","title":{"rendered":"R'da regresyon modellerini Excel'e aktarmak"},"content":{"rendered":"\n

R kullanarak yapt\u0131\u011f\u0131m ilk regresyon modelimin sonu\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015fmama aktar\u0131rken write.csv’den tutun da write ile ba\u015flayan b\u00fct\u00fcn d\u0131\u015fa aktar\u0131m\u0131 fonksiyonlar\u0131n\u0131 denedim. Hi\u00e7biri kabul etmedi summary fonksiyonu ile \u00e7al\u0131\u015fmay\u0131. Biraz da el h\u0131z\u0131ma g\u00fcvenip babadan kalma bir y\u00f6ntemi kullanmaya ba\u015flad\u0131m: kadar: kopyala + yap\u0131\u015ft\u0131r. S\u00f6z konusu olan R’\u0131n regresyon sonu\u00e7 tablolar\u0131 ise bu y\u00f6ntem biraz u\u011fra\u015ft\u0131r\u0131yor a\u00e7\u0131k\u00e7as\u0131. Excel’e aktard\u0131\u011f\u0131m tablolar\u0131n bi\u00e7imini sat\u0131r sat\u0131r d\u00fczeltmek gerekiyor asl\u0131nda. Sat\u0131rlar\u0131 s\u00fctunlara \u00e7evirmeden faydalan\u0131p istedi\u011fim gibi bi\u00e7imlendiriyordum tablolar\u0131m. R i\u00e7in d\u00fczenli ziyaret etti\u011fim Stack Exchange’de denk geldi\u011fim cevaplar da \u00e7o\u011funlukla “stargazer” paketini tavsiye ediyordu.. Akl\u0131m\u0131n hep kenar\u0131nda olup kurulu paketlerde aylard\u0131r bekleyen stargazer<\/em>‘i denemeye kadar verdim bir g\u00fcn. HTML bi\u00e7iminde dosyaya aktard\u0131\u011f\u0131m tablolar\u0131 Excel’e aktarmak ger\u00e7ekten \u00e7ok basitle\u015fti o andan itibaren. Kullan\u0131nca da fark ettim ki asl\u0131nda benim teker teker yapt\u0131\u011f\u0131m her ad\u0131m\u0131 stargazer<\/em> bitirilmi\u015f halde \u00f6n\u00fcme s\u00fcr\u00fcyor. E\u011fer LaTeX diline hakimseniz tablolar\u0131n sunumunu daha da geli\u015ftirmek elinizde. Paketin anlat\u0131m\u0131 k\u0131lavuza dayanarak yap\u0131lm\u0131\u015ft\u0131r.<\/p>\n\n\n

\u00d6nce paketi<\/g> kural\u0131m, sonra<\/g> da \u00e7a\u011f\u0131ral\u0131m<\/p>\n\n\n

>install.packages(\"startgazer\")
>library(stargazer)<\/code><\/p>\n\n\n

Sonu\u00e7lar\u0131n\u0131 tablolara yans\u0131tmak istedi\u011fimiz \u00fc\u00e7 farkl\u0131 model olu\u015fturual\u0131m<\/p>\n\n\n

>linear.1 <- lm(rating ~ complaints + privileges + learning + raises + critical, data=attitude)
>linear.2 <- lm(rating ~ complaints + privileges + learning, data=attitude)<\/code>
>attitude$high.rating <- (attitude$rating > 70)
>probit.model <- glm(high.rating ~ learning + critical + advance, data=attitude, family = binomial(link = \"probit\"))<\/code><\/p>\n\n\n

Pakete ait stargazer fonksiyonunu en temel haliyle kullanmak i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131n<\/p>\n\n\n

>stargazer(linear.1, linear.2, probit.model, title=\"Kar\u015f\u0131la\u015ft\u0131rmal\u0131 Sonu\u00e7lar\", digits=4, align=TRUE)<\/code><\/p>\n\n\n

Yukar\u0131daki form\u00fcl <\/g>size sonu\u00e7lar\u0131 LaTeX format\u0131nda ve ondal\u0131k hanade 4 basamak ile verecek verecek. Bug\u00fcne kadar hi\u00e7 LaTeX ile \u00e7al\u0131\u015fmad\u0131ysan\u0131z (benim gibi), sonu\u00e7lar\u0131 HTML olarak elde etmeniz m\u00fcmk\u00fcn.<\/p>\n\n\n

>stargazer(linear.1, linear.2, probit.model, title=\"Kar\u015f\u0131la\u015ft\u0131rmal\u0131 Sonu\u00e7lar\", align=TRUE,digits=4,type=\"html\")<\/code><\/p>\n\n\n

Peki sonu\u00e7lar\u0131 Excel’e aktarmak i\u00e7in ne yapmak gerekiyor?<\/p>\n\n\n

>write.csv(stargazer(linear.1, linear.2, probit.model, title=\"Kar\u015f\u0131la\u015ft\u0131rmal\u0131 Sonu\u00e7lar\", align=TRUE,digits=4,type=\"html\"),file=\"model.csv\")<\/code><\/p>\n\n\n

CSV dosyas\u0131n\u0131 Excel veya Calc ile a\u00e7\u0131n, ve B kolonunda <table> ile <\/table> aras\u0131ndaki b\u00fct\u00fcn kodlar\u0131 kopyalay\u0131p Windows’un Not Defteri’ne (notepad.exe) yap\u0131\u015ft\u0131r\u0131n. Dosyay\u0131 HTML uzant\u0131s\u0131 ile kaydedip taray\u0131c\u0131n\u0131z ile a\u00e7\u0131n ve istedi\u011finiz gibi d\u00fczenleyin.<\/p>\n\n\n

Ad\u0131m ad\u0131m gitti\u011finizde emin olun ki R’dan Excel’e kopyalay\u0131p yap\u0131\u015ft\u0131rmaktan daha kolay oldu\u011funu g\u00f6receksiniz. Kolay gelsin.<\/p>\n","protected":false},"excerpt":{"rendered":"

R kullanarak yapt\u0131\u011f\u0131m ilk regresyon modelimin sonu\u00e7lar\u0131n\u0131 \u00e7al\u0131\u015fmama aktar\u0131rken write.csv’den tutun da write ile ba\u015flayan b\u00fct\u00fcn d\u0131\u015fa aktar\u0131m\u0131 fonksiyonlar\u0131n\u0131 denedim. Hi\u00e7biri kabul etmedi summary fonksiyonu ile \u00e7al\u0131\u015fmay\u0131. Biraz da el h\u0131z\u0131ma g\u00fcvenip babadan kalma bir y\u00f6ntemi kullanmaya ba\u015flad\u0131m: kadar: kopyala + yap\u0131\u015ft\u0131r. S\u00f6z konusu olan R’\u0131n regresyon sonu\u00e7 tablolar\u0131 ise bu y\u00f6ntem biraz u\u011fra\u015ft\u0131r\u0131yor a\u00e7\u0131k\u00e7as\u0131. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-1642","post","type-post","status-publish","format-standard","hentry","category-r"],"_links":{"self":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts\/1642","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1642"}],"version-history":[{"count":0,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=\/wp\/v2\/posts\/1642\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1642"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1642"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gokberkcan.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1642"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}