{"id":1547,"date":"2026-03-19T11:40:23","date_gmt":"2026-03-19T15:40:23","guid":{"rendered":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/?p=1547"},"modified":"2026-03-23T21:08:28","modified_gmt":"2026-03-24T01:08:28","slug":"exam-2-study-guide-semi-structured-data-python-basics-json-pandas-etl-hypothesis-testing-data-visualization-during-class-time-on-3-26","status":"publish","type":"post","link":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/2026\/03\/19\/exam-2-study-guide-semi-structured-data-python-basics-json-pandas-etl-hypothesis-testing-data-visualization-during-class-time-on-3-26\/","title":{"rendered":"Exam #2 Study Guide: Semi-structured Data, Python Basics\/JSON\/Pandas, ETL, Hypothesis Testing, Data Visualization [During class time on 3\/26]"},"content":{"rendered":"<ul>\n<li>The exam is closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions.<\/li>\n<li>Exam # 2 covers all the lectures from \u201cSemi-structured data\u201d to \u201cData visualization\u201d.\u00a0<\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/gem0zgthmyecc63g5rmbt\/Exam-2-Study-Guide.docx?rlkey=qh0xm1ox8xfu63zvbzaexn79q&amp;dl=1\">Study Guide for Exam #2 (word)<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/2qjk1xawq53nh5h1le9jq\/Review-for-Exam-2.pptx?rlkey=job74gik40cy9tjitfb3kfetg&amp;dl=1\">Study Guide for Exam #2 (ppt)<\/a><\/li>\n<li>Additional practice questions:\n<ul>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/y88yr2gp8eg7wr6chd3y5\/Review-JSON-and-Pandas.ipynb?rlkey=zqihwe1or3wmdkrdpgixa3ggj&amp;dl=1\">Python code<\/a>\u00a0\u00a0\/\u00a0\u00a0<a href=\"https:\/\/www.dropbox.com\/scl\/fi\/37ypkrc282ru2pofbdiik\/Review-JSON-and-Pandas.html?rlkey=5xor5tf2ka3nr8tkyrudzyoil&amp;dl=1\">solution<\/a><\/li>\n<li><a href=\"https:\/\/www.dropbox.com\/scl\/fi\/6l5zfz2tuz3uwqky5j6o2\/airbnb_practice.json?rlkey=v0p30qw6cl79kjglvq141oakv&amp;dl=1\">airbnb_practice.json<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>The exam is closed book, closed notes. The exam will be a combination of multiple-choice and short-answer questions. Exam # 2 covers all the lectures from \u201cSemi-structured data\u201d to \u201cData visualization\u201d.\u00a0 Study Guide for Exam #2 (word) Study Guide for Exam #2 (ppt) Additional practice questions: Python code\u00a0\u00a0\/\u00a0\u00a0solution airbnb_practice.json<\/p>\n","protected":false},"author":17214,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_genesis_hide_title":false,"_genesis_hide_breadcrumbs":false,"_genesis_hide_singular_image":false,"_genesis_hide_footer_widgets":false,"_genesis_custom_body_class":"","_genesis_custom_post_class":"","_genesis_layout":"","footnotes":""},"categories":[719019],"tags":[],"class_list":{"0":"post-1547","1":"post","2":"type-post","3":"status-publish","4":"format-standard","6":"category-review-and-exam-study-guides","7":"entry"},"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/posts\/1547","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/users\/17214"}],"replies":[{"embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/comments?post=1547"}],"version-history":[{"count":3,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/posts\/1547\/revisions"}],"predecessor-version":[{"id":1552,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/posts\/1547\/revisions\/1552"}],"wp:attachment":[{"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/media?parent=1547"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/categories?post=1547"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/community.mis.temple.edu\/mis2502sec002spring2026\/wp-json\/wp\/v2\/tags?post=1547"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}