TalkPython Move from Excel to Python with Pandas Course 2020 En

1. 04 Intro to Pandas/10-working-with-column-names.mp450.38MB
2. 01 Welcome to the course/01-welcome-to-the-course.mp42.78MB
3. 01 Welcome to the course/02-challenges-of-excel.mp47.69MB
4. 01 Welcome to the course/03-where-do-excel-errors-come-from.mp42.5MB
5. 01 Welcome to the course/04-why-python.mp44.94MB
6. 01 Welcome to the course/05-course-topics.mp43.39MB
7. 01 Welcome to the course/06-get-the-source.mp4916.16KB
8. 01 Welcome to the course/07-meeting-your-instructor.mp43.76MB
9. 02 Setup and installations/01-python-concepts-youll-need.mp43.5MB
10. 02 Setup and installations/02-working-on-windows.mp42.8MB
11. 02 Setup and installations/03-downloading-miniconda.mp41.11MB
12. 02 Setup and installations/04-installing-miniconda.mp46.41MB
13. 02 Setup and installations/05-launching-miniconda.mp4935.65KB
14. 02 Setup and installations/06-creating-a-conda-environment.mp44.96MB
15. 02 Setup and installations/07-conda-quick-reference.mp42.01MB
16. 03 Code data concepts/01-getting-organized.mp42.84MB
17. 03 Code data concepts/02-recommended-file-structure.mp43.03MB
18. 03 Code data concepts/03-launching-jupyter-notebooks.mp41.21MB
19. 03 Code data concepts/04-auto-launch-conda-env-with-windows-terminal.mp43.29MB
20. 03 Code data concepts/05-create-a-project-with-cookiecutter.mp49.56MB
21. 03 Code data concepts/06-launching-jupyter-notebooks.mp45.16MB
22. 03 Code data concepts/07-organizing-within-the-notebook.mp43.2MB
23. 03 Code data concepts/08-data-compatible-with-pandas.mp43.78MB
24. 03 Code data concepts/09-where-does-excel-fit-in.mp41.39MB
25. 04 Intro to Pandas/01-intro-to-pandas.mp42.95MB
26. 04 Intro to Pandas/02-pandas-dataframe-vs-excel-worksheets.mp47.44MB
27. 04 Intro to Pandas/03-understanding-initial-data-intro.mp45.79MB
28. 04 Intro to Pandas/04-demo-understanding-initial-data.mp421.35MB
29. 04 Intro to Pandas/05-concept-understanding-your-dataframe.mp42.11MB
30. 04 Intro to Pandas/06-working-with-column-names.mp428.1MB
31. 04 Intro to Pandas/07-diving-into-the-data.mp410.36MB
32. 04 Intro to Pandas/08-working-with-m-ultiple-columns.mp415.2MB
33. 04 Intro to Pandas/09-concept-working-with-columns.mp43.57MB
34. 04 Intro to Pandas/11-concept-selecting-rows-and-columns.mp42.91MB
35. 04 Intro to Pandas/12-advanced-autocomplete-and-help.mp419.77MB
36. 05 Data wrangling with Pandas/01-what-is-data-wrangling.mp42.99MB
37. 05 Data wrangling with Pandas/02-pandas-data-types.mp45.2MB
38. 05 Data wrangling with Pandas/03-walk-through-of-data-types-in-excel.mp414.86MB
39. 05 Data wrangling with Pandas/04-pandas-dt-the-data-time-accessor.mp418.44MB
40. 05 Data wrangling with Pandas/05-string-and-math-manipulations.mp424.61MB
41. 05 Data wrangling with Pandas/06-concept-filtering-data.mp43.35MB
42. 05 Data wrangling with Pandas/07-examples-of-booling-filtering-in-pandas.mp426.44MB
43. 05 Data wrangling with Pandas/08-filtering-by-dates.mp427.39MB
44. 05 Data wrangling with Pandas/09-concept-filtering-and-cleaning-text-and-dates.mp44.37MB
45. 06 Aggregating, grouping, and merging/01-aggregating-merging-grouping-intro.mp44.17MB
46. 06 Aggregating, grouping, and merging/02-examples-of-aggregation-in-excel.mp48.88MB
47. 06 Aggregating, grouping, and merging/03-examples-of-aggregation-in-pandas.mp442.28MB
48. 06 Aggregating, grouping, and merging/04-concept-pandas-groupby.mp42.01MB
49. 06 Aggregating, grouping, and merging/05-concept-pivot-tables-and-crosstab.mp46.49MB
50. 06 Aggregating, grouping, and merging/06-demo-pivot-table-and-crosstab.mp429.14MB
51. 06 Aggregating, grouping, and merging/07-demo-merging-data-in-excel.mp429.27MB
52. 06 Aggregating, grouping, and merging/08-demo-merging-data-in-pandas.mp442.47MB
53. 06 Aggregating, grouping, and merging/09-concept-appending-data.mp42.38MB
54. 07 Data IO (input and output)/01-intro-input-output.mp41.68MB
55. 07 Data IO (input and output)/02-reading-non-tabular-excel-files.mp422.05MB
56. 07 Data IO (input and output)/03-read-excel-convert-data-types.mp428.31MB
57. 07 Data IO (input and output)/04-reading-excel-summary.mp42.46MB
58. 07 Data IO (input and output)/05-demo-simple-excel-save.mp410.57MB
59. 07 Data IO (input and output)/06-demo-multi-sheet-excel.mp410MB
60. 07 Data IO (input and output)/07-demo-complex-excel-save.mp412.1MB
61. 07 Data IO (input and output)/08-excel-writer-summary.mp42.08MB
62. 07 Data IO (input and output)/09-excel-large-file-fail.mp43.75MB
63. 07 Data IO (input and output)/10-pandas-large-file-success.mp412.93MB
64. 08 Case study walk through. Sales commissions/01-Introduction.mp44.01MB
65. 08 Case study walk through. Sales commissions/02-environment-setup.mp44.78MB
66. 08 Case study walk through. Sales commissions/03-excel-file-intro.mp43.37MB
67. 08 Case study walk through. Sales commissions/04-notebook-setup-file-reading.mp46.58MB
68. 08 Case study walk through. Sales commissions/05-Commission-rate-calc.mp419.5MB
69. 08 Case study walk through. Sales commissions/06-Summary-results-more-questions.mp43.87MB
70. 08 Case study walk through. Sales commissions/07-Combine_customer_sales_rep.mp410.21MB
71. 08 Case study walk through. Sales commissions/08-Cleanup-region.mp420.98MB
72. 08 Case study walk through. Sales commissions/09-Merge-sales-reps.mp413.84MB
73. 08 Case study walk through. Sales commissions/10-cleaned_joined_file.mp426.09MB
74. 08 Case study walk through. Sales commissions/11-excel_file_review.mp47.07MB
75. 08 Case study walk through. Sales commissions/12-process_review.mp42.51MB
76. 08 Case study walk through. Sales commissions/13-excel-invoice-files.mp47.82MB
77. 08 Case study walk through. Sales commissions/14-excel-customer-invoice-files.mp49.22MB
78. 08 Case study walk through. Sales commissions/15-product-commission-scenarios.mp425.29MB
79. 08 Case study walk through. Sales commissions/16-product-commission-variable-amounts.mp419.77MB
80. 08 Case study walk through. Sales commissions/17-commission-state-adjustments.mp418.23MB
81. 08 Case study walk through. Sales commissions/18-final-excel-report.mp414.86MB
82. 08 Case study walk through. Sales commissions/19-wrapup.mp46.77MB
83. 09 Course conclusion and review/01-excel-challenges.mp44.23MB
84. 09 Course conclusion and review/02-conda-review.mp42.01MB
85. 09 Course conclusion and review/03-file-jupyter-structure.mp45.26MB
86. 09 Course conclusion and review/04-dataframe-summary.mp43.81MB
87. 09 Course conclusion and review/05-data-wrangling.mp47.03MB
88. 09 Course conclusion and review/06-grouping-joining-data.mp46.39MB
89. 09 Course conclusion and review/07-file-io.mp42.21MB
90. 09 Course conclusion and review/08-practical-example.mp45.83MB
91. 09 Course conclusion and review/09-thank-you-next-steps.mp42.8MB
92. 10 Appendix. Python language concepts/1-refresher-shape-of-a-program.mp44.23MB
93. 10 Appendix. Python language concepts/2-refresher-variables.mp42.09MB
94. 10 Appendix. Python language concepts/3-refresher-truthiness.mp44.43MB
95. 10 Appendix. Python language concepts/4-refresher-if-else.mp43.26MB
96. 10 Appendix. Python language concepts/5-refresher-complex-conditionals.mp43.48MB
97. 10 Appendix. Python language concepts/6-refresher-for-in.mp43.91MB
98. 10 Appendix. Python language concepts/7-refresher-functions.mp42.44MB
99. 10 Appendix. Python language concepts/8-refresher-create-functions.mp43.94MB
100. 10 Appendix. Python language concepts/9-refresher-file.mp43.09MB
101. 10 Appendix. Python language concepts/10-refresher-import.mp44.41MB
102. 10 Appendix. Python language concepts/11-refresher-pypi.mp49.28MB
103. 10 Appendix. Python language concepts/12-refresher-pip.mp47.37MB
104. 10 Appendix. Python language concepts/13-refresher-virtual-environments.mp415.2MB
105. 10 Appendix. Python language concepts/14-refresher-slicing.mp46.6MB
106. 10 Appendix. Python language concepts/15-refresher-tuples.mp44.66MB
107. 10 Appendix. Python language concepts/16-refresher-named-tuples.mp45.07MB
108. 10 Appendix. Python language concepts/17-refresher-class-structure.mp45.78MB
109. 10 Appendix. Python language concepts/18-refresher-objects-vs-classes.mp44.85MB
110. 10 Appendix. Python language concepts/19-refresher-inheretance.mp45.04MB
111. 10 Appendix. Python language concepts/20-refresher-polymorphism.mp42.69MB
112. 10 Appendix. Python language concepts/21-refresher-dictionaries.mp46.95MB
113. 10 Appendix. Python language concepts/22-refresher-exceptions.mp45.4MB
114. 10 Appendix. Python language concepts/23-refresher-lambdas.mp44.46MB
115. 10 Appendix. Python language concepts/24-refresher-list-comprehensions.mp46.88MB
116. 10 Appendix. Python language concepts/25-refresher-want-more.mp43.11MB