{"id":6746,"date":"2024-01-17T02:25:54","date_gmt":"2024-01-17T05:25:54","guid":{"rendered":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/2024\/01\/17\/data-analysis-with-python-for-excel-users-full-course\/"},"modified":"2024-01-17T02:25:54","modified_gmt":"2024-01-17T05:25:54","slug":"data-analysis-with-python-for-excel-users-full-course","status":"publish","type":"post","link":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/2024\/01\/17\/data-analysis-with-python-for-excel-users-full-course\/","title":{"rendered":"Data Analysis with Python for Excel Users &#8211; Full Course"},"content":{"rendered":"<p><iframe loading=\"lazy\" width=\"580\" height=\"385\" src=\"https:\/\/www.youtube.com\/embed\/WcDaZ67TVRo?modestbranding=1\" frameborder=\"0\" allowfullscreen><\/iframe><br \/>\n<br \/>Learn how to use Python and Pandas for data analysis. This course will be especially helpful if you have experience with Excel, but that is not required. Learn how to create pivot tables, work with data, and make visualizations using Python, Pandas, and Jupyter Notebook.<\/p>\n<p>\ud83d\udcbb Source Code &#038; Datasets:<br \/>\n\ud83d\udd17 Datasets: <\/p>\n<p>\u270f\ufe0f Course developed by Frank Andrade.<br \/>\n\ud83d\udd17 YouTube Channel:<br \/>\n\ud83d\udd17 PDF Python Cheat Sheet for this Course:<br \/>\n\ud83d\udd17 My Complete Python Courses for Data Analysis &#038; Data Science: <\/p>\n<p>\u2b50\ufe0f Course Contents \u2b50\ufe0f<br \/>\n\u2328\ufe0f (0:00:00) Intro<br \/>\n\u2328\ufe0f (0:01:48) Install Python and Jupyter Notebook with Anaconda<br \/>\n\u2328\ufe0f (0:03:53) Jupyter Notebook Interface<br \/>\n\u2328\ufe0f (0:13:56) Cell Types and Cell Mode<br \/>\n\u2328\ufe0f (0:21:34) Jupyter Notebook Shortcuts<br \/>\n\u2328\ufe0f (0:26:39) Module 1 &#8211; Hello World<br \/>\n\u2328\ufe0f (0:30:30) Data Type<br \/>\n\u2328\ufe0f (0:39:10) Variables<br \/>\n\u2328\ufe0f (0:46:53) Lists<br \/>\n\u2328\ufe0f (1:11:14) Dictionaries<br \/>\n\u2328\ufe0f (1:21:50) IF Statement<br \/>\n\u2328\ufe0f (1:28:04) FOR Loop<br \/>\n\u2328\ufe0f (1:33:49) Functions<br \/>\n\u2328\ufe0f (1:40:59) Modules<br \/>\n\u2328\ufe0f (1:44:41) Module 2 -Introduction to Pandas<br \/>\n\u2328\ufe0f (1:51:08) How to create a dataframe<br \/>\n\u2328\ufe0f (2:07:34) How to show a dataframe<br \/>\n\u2328\ufe0f (2:14:24) Basic Attributes, Functions and Methods<br \/>\n\u2328\ufe0f (2:26:17) Selecting One Column from a Dataframe<br \/>\n\u2328\ufe0f (2:32:13) Selecting Two or More Columns from a Dataframe<br \/>\n\u2328\ufe0f (2:37:50) Add New Column to a Dataframe (Simple Assignment)<br \/>\n\u2328\ufe0f (2:47:51) Operations in dataframes<br \/>\n\u2328\ufe0f (2:56:04) The value_counts() method<br \/>\n\u2328\ufe0f (seo-automated-<a href=\"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/2019\/11\/14\/dicas-do-linkedin-sobre-o-uso-da-plataforma-na-area-da-saude\/\" data-seo-automated-link-building=\"3\" title=\"Dicas do LinkedIn sobre o uso da plataforma na \u00e1rea da sa\u00fade\">link<\/a>-building-1:00:16) Sort a DataFrame with the sort_values() method<br \/>\n\u2328\ufe0f (3:09:56) Module 3: Introduction to Pivot Tables in Pandas<br \/>\n\u2328\ufe0f (3:14:42) The pivot() method<br \/>\n\u2328\ufe0f (3:20:49) The pivot_table() method<br \/>\n\u2328\ufe0f (3:29:00) Data Visualization with Pandas (New Dataset + Pivot Table)<br \/>\n\u2328\ufe0f (3:38:38) Lineplot<br \/>\n\u2328\ufe0f (3:43:05) Barplot<br \/>\n\u2328\ufe0f (3:50:52) Piechart<br \/>\n\u2328\ufe0f (3:54:36) Save Plot and Export Pivot Table<\/p>\n<p>\ud83c\udf89 Thanks to our Champion and Sponsor supporters:<br \/>\n\ud83d\udc7e Raymond Odero<br \/>\n\ud83d\udc7e Agust\u00edn Kussrow<br \/>\n\ud83d\udc7e aldo ferretti<br \/>\n\ud83d\udc7e Otis Morgan<br \/>\n\ud83d\udc7e DeezMaster<\/p>\n<p>&#8212;<\/p>\n<p>Learn to code for free and get a developer job: <\/p>\n<p>Read hundreds of articles on programming:<br \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Learn how to use Python and Pandas for data analysis. This course will be especially helpful if you have experience with Excel, but that is not required. Learn how to create pivot tables, work with data, and make visualizations using Python, Pandas, and Jupyter Notebook. \ud83d\udcbb Source Code &#038; Datasets: \ud83d\udd17 Datasets: \u270f\ufe0f Course developed &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/2024\/01\/17\/data-analysis-with-python-for-excel-users-full-course\/\"> <span class=\"screen-reader-text\">Data Analysis with Python for Excel Users &#8211; Full Course<\/span> Ler Mais &#8220;<\/a><\/p>\n","protected":false},"author":1,"featured_media":6747,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-global-header-display":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":""},"categories":[2],"tags":[16440,2192,4418,531,3049,10684,5846,4789,2195,16441,1410,2193],"_links":{"self":[{"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/posts\/6746"}],"collection":[{"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/comments?post=6746"}],"version-history":[{"count":0,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/posts\/6746\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/media\/6747"}],"wp:attachment":[{"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/media?parent=6746"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/categories?post=6746"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dicasempregos.cidadesbr.net.br\/vagas\/wp-json\/wp\/v2\/tags?post=6746"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}