{"id":1170,"date":"2023-02-24T09:06:22","date_gmt":"2023-02-24T14:06:22","guid":{"rendered":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1170"},"modified":"2023-02-24T09:12:06","modified_gmt":"2023-02-24T14:12:06","slug":"intermediate-structured-query-language-for-data-analytics-ws231-day-4","status":"publish","type":"post","link":"https:\/\/folvera.commons.gc.cuny.edu\/?p=1170","title":{"rendered":"Intermediate Structured Query Language for Data Analytics (WS231) \u2014 Day 4"},"content":{"rendered":"<p>We continued working on normalization replacing values of cities\/counties with <a href=\"https:\/\/www.techtarget.com\/whatis\/definition\/Federal-Information-Processing-Standards-FIPS\" target=\"_blank\" rel=\"noopener\">FIPS<\/a> (<a href=\"https:\/\/www.techtarget.com\/whatis\/definition\/Federal-Information-Processing-Standards-FIPS\" target=\"_blank\" rel=\"noopener\">Federal Information Processing Standards<\/a>) values for these cities\/counties. We had to <a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2023\/02\/importing_excel_file.pdf\">import data into our working database<\/a> <tt>WS231<\/tt>. We ran into errors along the way and had to make the proper changes to normalize our data. In any case, the main part of the whole process was having fun!<\/p>\n<p>Download the\u00a0<a href=\"https:\/\/folvera.commons.gc.cuny.edu\/wp-content\/blogs.dir\/2501\/files\/2023\/02\/WS231.20230222.pdf\">class notes<\/a>\u00a0for day 4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>We continued working on normalization replacing values of cities\/counties with FIPS (Federal Information Processing Standards) values for these cities\/counties. We had to import data into our working database WS231. We ran into errors along the way and had to make the proper changes to normalize our data. In any case, the main part of the [&hellip;]<\/p>\n","protected":false},"author":7213,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"send_to_group_blog":0,"footnotes":""},"categories":[32,3,1,2],"tags":[],"class_list":["post-1170","post","type-post","status-publish","format-standard","hentry","category-ws231","category-computer-programming","category-cuny","category-sql"],"_links":{"self":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/users\/7213"}],"replies":[{"embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1170"}],"version-history":[{"count":2,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1170\/revisions"}],"predecessor-version":[{"id":1173,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=\/wp\/v2\/posts\/1170\/revisions\/1173"}],"wp:attachment":[{"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/folvera.commons.gc.cuny.edu\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}