{"id":425,"date":"2015-11-02T16:31:15","date_gmt":"2015-11-02T20:31:15","guid":{"rendered":"https:\/\/fieldscience.cs.earlham.edu\/?p=425"},"modified":"2015-11-09T09:47:18","modified_gmt":"2015-11-09T13:47:18","slug":"cleaning-up","status":"publish","type":"post","link":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/","title":{"rendered":"Cleaning Up"},"content":{"rendered":"<p>I&#8217;ve continued working on my master table.I&#8217;ve been doing two things to the data,cleaning up the format it&#8217;s in,and substituting dummy values for those records where we don&#8217;t have values.I&#8217;ve also been doing a reasonableness check with the data by comparing our calendars and where the calendars said we were to the data we have.This has let me know what data we can safely get rid of,like the couple of testing streams we have from around hostels.<\/p>\n<p>I&#8217;m almost done with cleaning up and should be able to just put all of my nice clean data (all in one format!!) into the fieldscience db.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>I&#8217;ve continued working on my master table.I&#8217;ve been doing two things to the data,cleaning up the format it&#8217;s in,and substituting dummy values for those records where we don&#8217;t have values.I&#8217;ve also been doing a reasonableness check with the data by &hellip; <a href=\"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/\">Read More<\/a><\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"kt_blocks_editor_width":"","footnotes":""},"categories":[7,11],"tags":[44,13],"class_list":["post-425","post","type-post","status-publish","format-standard","hentry","category-deeksha","category-progress-reports","tag-collecting-data","tag-database"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Cleaning Up - fieldscience @ earlham<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cleaning Up - fieldscience @ earlham\" \/>\n<meta property=\"og:description\" content=\"I&#8217;ve continued working on my master table.I&#8217;ve been doing two things to the data,cleaning up the format it&#8217;s in,and substituting dummy values for those records where we don&#8217;t have values.I&#8217;ve also been doing a reasonableness check with the data by &hellip; Read More\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/\" \/>\n<meta property=\"og:site_name\" content=\"fieldscience @ earlham\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-02T20:31:15+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2015-11-09T13:47:18+00:00\" \/>\n<meta name=\"author\" content=\"Deeksha Srinath\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Deeksha Srinath\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/\"},\"author\":{\"name\":\"Deeksha Srinath\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/861d0c3eb342628b2ed3c8146ac16b46\"},\"headline\":\"Cleaning Up\",\"datePublished\":\"2015-11-02T20:31:15+00:00\",\"dateModified\":\"2015-11-09T13:47:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/\"},\"wordCount\":118,\"commentCount\":0,\"keywords\":[\"collecting data\",\"Database\"],\"articleSection\":[\"Deeksha\",\"Progress Reports\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/\",\"url\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/\",\"name\":\"Cleaning Up - fieldscience @ earlham\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/#website\"},\"datePublished\":\"2015-11-02T20:31:15+00:00\",\"dateModified\":\"2015-11-09T13:47:18+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/861d0c3eb342628b2ed3c8146ac16b46\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/2015\\\/11\\\/cleaning-up\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cleaning Up\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/#website\",\"url\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/\",\"name\":\"fieldscience @ earlham\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/#\\\/schema\\\/person\\\/861d0c3eb342628b2ed3c8146ac16b46\",\"name\":\"Deeksha Srinath\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g\",\"caption\":\"Deeksha Srinath\"},\"url\":\"https:\\\/\\\/fieldscience.cs.earlham.edu\\\/index.php\\\/author\\\/dsrina13\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Cleaning Up - fieldscience @ earlham","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/","og_locale":"en_US","og_type":"article","og_title":"Cleaning Up - fieldscience @ earlham","og_description":"I&#8217;ve continued working on my master table.I&#8217;ve been doing two things to the data,cleaning up the format it&#8217;s in,and substituting dummy values for those records where we don&#8217;t have values.I&#8217;ve also been doing a reasonableness check with the data by &hellip; Read More","og_url":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/","og_site_name":"fieldscience @ earlham","article_published_time":"2015-11-02T20:31:15+00:00","article_modified_time":"2015-11-09T13:47:18+00:00","author":"Deeksha Srinath","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Deeksha Srinath","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/#article","isPartOf":{"@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/"},"author":{"name":"Deeksha Srinath","@id":"https:\/\/fieldscience.cs.earlham.edu\/#\/schema\/person\/861d0c3eb342628b2ed3c8146ac16b46"},"headline":"Cleaning Up","datePublished":"2015-11-02T20:31:15+00:00","dateModified":"2015-11-09T13:47:18+00:00","mainEntityOfPage":{"@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/"},"wordCount":118,"commentCount":0,"keywords":["collecting data","Database"],"articleSection":["Deeksha","Progress Reports"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/","url":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/","name":"Cleaning Up - fieldscience @ earlham","isPartOf":{"@id":"https:\/\/fieldscience.cs.earlham.edu\/#website"},"datePublished":"2015-11-02T20:31:15+00:00","dateModified":"2015-11-09T13:47:18+00:00","author":{"@id":"https:\/\/fieldscience.cs.earlham.edu\/#\/schema\/person\/861d0c3eb342628b2ed3c8146ac16b46"},"breadcrumb":{"@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/2015\/11\/cleaning-up\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/fieldscience.cs.earlham.edu\/"},{"@type":"ListItem","position":2,"name":"Cleaning Up"}]},{"@type":"WebSite","@id":"https:\/\/fieldscience.cs.earlham.edu\/#website","url":"https:\/\/fieldscience.cs.earlham.edu\/","name":"fieldscience @ earlham","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fieldscience.cs.earlham.edu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/fieldscience.cs.earlham.edu\/#\/schema\/person\/861d0c3eb342628b2ed3c8146ac16b46","name":"Deeksha Srinath","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a543c5785bc3c87e3e44cbe7b096681fa563c2e67dc0575c2cc513fd191f45c6?s=96&d=wavatar&r=g","caption":"Deeksha Srinath"},"url":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/author\/dsrina13\/"}]}},"_links":{"self":[{"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/425","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/comments?post=425"}],"version-history":[{"count":1,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/425\/revisions"}],"predecessor-version":[{"id":428,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/posts\/425\/revisions\/428"}],"wp:attachment":[{"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/media?parent=425"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/categories?post=425"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fieldscience.cs.earlham.edu\/index.php\/wp-json\/wp\/v2\/tags?post=425"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}