{"id":10,"date":"2025-10-07T10:52:13","date_gmt":"2025-10-07T17:52:13","guid":{"rendered":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/points\/pandas-essential-training-2017\/"},"modified":"2025-10-07T10:52:13","modified_gmt":"2025-10-07T17:52:13","slug":"pandas-essential-training-2017","status":"publish","type":"points","link":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/points\/pandas-essential-training-2017\/","title":{"rendered":"pandas Essential Training (2017)"},"content":{"rendered":"<p data-start=\"&quot;\\&quot;\\\\&quot;69\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;261\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;69\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;88\\\\&quot;\\&quot;&quot;\">What I Learned:<\/strong><br data-start=\"&quot;\\&quot;\\\\&quot;88\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;91\\\\&quot;\\&quot;&quot;\" \/>In <em data-start=\"&quot;\\&quot;\\\\&quot;94\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;128\\\\&quot;\\&quot;&quot;\">Pandas Essential Training (2017)<\/em>, I learned how to use Python\u2019s <strong data-start=\"&quot;\\&quot;\\\\&quot;160\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;178\\\\&quot;\\&quot;&quot;\">pandas library<\/strong> to efficiently manipulate, clean, and analyze data. Key skills I gained include:<\/p>\n<ul data-start=\"&quot;\\&quot;\\\\&quot;263\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;677\\\\&quot;\\&quot;&quot;\">\n<li data-start=\"&quot;\\&quot;\\\\&quot;263\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;328\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;265\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;328\\\\&quot;\\&quot;&quot;\">Importing data from various sources like CSV and Excel files.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;329\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;415\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;331\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;415\\\\&quot;\\&quot;&quot;\">Exploring datasets with functions such as <code data-start=\"&quot;\\&quot;\\\\&quot;373\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;382\\\\&quot;\\&quot;&quot;\">.head()<\/code>, <code data-start=\"&quot;\\&quot;\\\\&quot;384\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;393\\\\&quot;\\&quot;&quot;\">.info()<\/code>, and <code data-start=\"&quot;\\&quot;\\\\&quot;399\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;412\\\\&quot;\\&quot;&quot;\">.describe()<\/code>.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;416\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;499\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;418\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;499\\\\&quot;\\&quot;&quot;\">Cleaning data by handling missing values, renaming columns, and filtering rows.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;500\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;585\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;502\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;585\\\\&quot;\\&quot;&quot;\">Performing operations like grouping, aggregating, merging, and pivoting datasets.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;586\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;677\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;588\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;677\\\\&quot;\\&quot;&quot;\">Creating basic visualizations using pandas\u2019 integration with libraries like Matplotlib.<\/p>\n<\/li>\n<\/ul>\n<p data-start=\"&quot;\\&quot;\\\\&quot;679\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;891\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;679\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;716\\\\&quot;\\&quot;&quot;\">How It Relates to My Major (MIS):<\/strong><br data-start=\"&quot;\\&quot;\\\\&quot;716\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;719\\\\&quot;\\&quot;&quot;\" \/>As a Management Information Systems (MIS) major, understanding data is crucial because businesses rely on accurate analysis for decision-making. Learning pandas helps me:<\/p>\n<ul data-start=\"&quot;\\&quot;\\\\&quot;893\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1415\\\\&quot;\\&quot;&quot;\">\n<li data-start=\"&quot;\\&quot;\\\\&quot;893\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;989\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;895\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;989\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;895\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;933\\\\&quot;\\&quot;&quot;\">Analyze business data efficiently:<\/strong> I can clean and transform raw data to uncover trends.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;990\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1113\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;992\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1113\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;992\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1032\\\\&quot;\\&quot;&quot;\">Support data-driven decision making:<\/strong> With pandas, I can provide insights that help managers make strategic choices.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;1114\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1246\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;1116\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1246\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;1116\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1149\\\\&quot;\\&quot;&quot;\">Integrate with other systems:<\/strong> Pandas works well with databases, spreadsheets, and other tools used in business intelligence.<\/p>\n<\/li>\n<li data-start=\"&quot;\\&quot;\\\\&quot;1247\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1415\\\\&quot;\\&quot;&quot;\">\n<p data-start=\"&quot;\\&quot;\\\\&quot;1249\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1415\\\\&quot;\\&quot;&quot;\"><strong data-start=\"&quot;\\&quot;\\\\&quot;1249\\\\&quot;\\&quot;&quot;\" data-end=\"&quot;\\&quot;\\\\&quot;1281\\\\&quot;\\&quot;&quot;\">Prepare for analytics roles:<\/strong> Skills in data manipulation and analysis are directly applicable to roles like business analyst, data analyst, or UX\/UI researcher.<\/p>\n<\/li>\n<\/ul>\n","protected":false},"author":2672,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-10","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points\/10","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/users\/2672"}],"replies":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/comments?post=10"}],"version-history":[{"count":0,"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/points\/10\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.cob.sjsu.edu\/melaniesportfolio\/wp-json\/wp\/v2\/media?parent=10"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}