{"id":175,"date":"2009-12-01T00:13:10","date_gmt":"2009-12-01T04:13:10","guid":{"rendered":"http:\/\/www.sofastatistics.com\/blog\/?p=175"},"modified":"2009-12-01T00:13:10","modified_gmt":"2009-12-01T04:13:10","slug":"0-8-13-better-support-for-inconsistent-data-and-missing-values","status":"publish","type":"post","link":"http:\/\/www.sofastatistics.com\/blog\/0-8-13-better-support-for-inconsistent-data-and-missing-values\/","title":{"rendered":"0.8.13 better support for inconsistent data and missing values"},"content":{"rendered":"<p>Removing rough edges and handling less perfect incoming data have been the recent focus of attention.  The main changes in 0.8.13 are:<\/p>\n<ul>\n<li>Better support for inconsistent data and missing values.<\/li>\n<li>The user is informed what happens to files being imported.<\/li>\n<li>The user has the option of halting a large raw data table report.<\/li>\n<li>CSV importing now asks user if file has header and offers to clean up files with mixed line separators.<\/li>\n<li>New projects have the default SOFA database preconfigured ready to save tables to.<\/li>\n<li>Program now returns useful message if SQLite table with median or std dev fails because of non-numeric values (in purportedly numeric field).<\/li>\n<li>Attempts to make new tables without a connection to the default database now receive a useful message.<\/li>\n<li>Users are given the opportunity to pull out of opening a large data table.<\/li>\n<\/ul>\n<p> Also importantly, there have been a myriad of bug fixes:<\/p>\n<ul>\n<li>Fixed bug when using SQLite database other than the SOFA default one.<\/li>\n<li>Report tables now handle non-numeric values in numeric fields (SQLite). <\/li>\n<li>Fixed simple but fatal bugs affecting raw and summary tables.<\/li>\n<li>Fixed bug when user path includes international characters.<\/li>\n<li>Fixed bug using MS SQL for making report tables.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Removing rough edges and handling less perfect incoming data have been the recent focus of attention. The main changes in 0.8.13 are: Better support for inconsistent data and missing values. The user is informed what happens to files being imported. The user has the option of halting a large raw data table report. CSV importing [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-175","post","type-post","status-publish","format-standard","hentry","category-general"],"_links":{"self":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/175","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/comments?post=175"}],"version-history":[{"count":1,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/175\/revisions"}],"predecessor-version":[{"id":176,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/posts\/175\/revisions\/176"}],"wp:attachment":[{"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/media?parent=175"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/categories?post=175"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.sofastatistics.com\/blog\/wp-json\/wp\/v2\/tags?post=175"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}