{"id":15,"date":"2025-09-26T09:34:48","date_gmt":"2025-09-26T16:34:48","guid":{"rendered":"https:\/\/community.cob.sjsu.edu\/ryanphan\/points\/ll-course-1-getting-things-done\/"},"modified":"2025-09-26T09:34:48","modified_gmt":"2025-09-26T16:34:48","slug":"ll-course-1-getting-things-done","status":"publish","type":"points","link":"https:\/\/community.cob.sjsu.edu\/ryanphan\/points\/ll-course-1-getting-things-done\/","title":{"rendered":"LL Course 1: Getting Things Done"},"content":{"rendered":"<p>This course, &#8220;pandas Essential Training (2017),&#8221; covers the following key topics:<\/p>\n<ul>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">DataFrames and Series<\/strong>: Learn the basics of these fundamental data structures in pandas.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Data Input and Validation<\/strong>: Understand how to read data using\u00a0<code class=\"&quot;attributed-text__inline-code\">read_csv()<\/code>, and validate it using functions like\u00a0<code class=\"&quot;attributed-text__inline-code\">shape<\/code>,\u00a0<code class=\"&quot;attributed-text__inline-code\">head()<\/code>,\u00a0<code class=\"&quot;attributed-text__inline-code\">tail()<\/code>, and\u00a0<code class=\"&quot;attributed-text__inline-code\">info()<\/code>.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Basic Analysis<\/strong>: Perform basic data analysis using functions such as\u00a0<code class=\"&quot;attributed-text__inline-code\">value_counts()<\/code>,\u00a0<code class=\"&quot;attributed-text__inline-code\">sort_values()<\/code>, Boolean indexing, and string handling.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Basic Plotting<\/strong>: Explore plotting techniques, different plot types, colors, figsize, colormaps, and Seaborn for basic plotting.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Indexing<\/strong>: Learn about indexing, including\u00a0<code class=\"&quot;attributed-text__inline-code\">set_index()<\/code>,\u00a0<code class=\"&quot;attributed-text__inline-code\">reset_index()<\/code>,\u00a0<code class=\"&quot;attributed-text__inline-code\">sort_index()<\/code>, and using\u00a0<code class=\"&quot;attributed-text__inline-code\">loc[]<\/code>\u00a0and\u00a0<code class=\"&quot;attributed-text__inline-code\">iloc[]<\/code>.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Grouping Data<\/strong>: Use the\u00a0<code class=\"&quot;attributed-text__inline-code\">groupby<\/code>\u00a0function to group data and perform computations.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Reshaping Data<\/strong>: Reshape data using\u00a0<code class=\"&quot;attributed-text__inline-code\">stack()<\/code>\u00a0and\u00a0<code class=\"&quot;attributed-text__inline-code\">unstack()<\/code>.<\/li>\n<li class=\"&quot;attributed-text__list-item&quot;\"><strong class=\"&quot;attributed-text__text\">Data Visualizations<\/strong>: Create heatmaps and custom colormaps.<\/li>\n<\/ul>\n<p>The course includes practical exercises based on the Olympic medal winners&#8217; dataset from 1896 to 2008, providing hands-on experience with the pandas library. <a href=\"\/\/community.cob.sjsu.edu\/ryanphan\/wp-content\/uploads\/sites\/1406\/2025\/09\/CertificateOfCompletion_pandas-Essential-Training-2017.pdf&quot;\">CertificateOfCompletion_pandas Essential Training 2017<\/a><\/p>\n","protected":false},"author":2724,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-15","points","type-points","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/points\/15","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/points"}],"about":[{"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/types\/points"}],"author":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/users\/2724"}],"replies":[{"embeddable":true,"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/comments?post=15"}],"version-history":[{"count":0,"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/points\/15\/revisions"}],"wp:attachment":[{"href":"https:\/\/community.cob.sjsu.edu\/ryanphan\/wp-json\/wp\/v2\/media?parent=15"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}